| Purpose |
| Questions and Answers |
| Question 1: Does the system provide the ability to add logos to a Mail Merge document? |
| Question 2: When using the Mail Merge Workbench why are some of the toolbar features disabled? |
| Question 3: Why does the Edit Template Button on the Web Mail Merge Details Screen (P05WMMWB) not work? Unable to edit and update the document. |
| Question 5: Duplicate Key Error - "JAS_MSG317:Duplicate Key Not Allowed. Please correct the duplicate key field" is received when adding data items to P05WMMWB, Web Mail Merge Workbench. |
| Question 6: What Microsoft Office Word version is supported with Mail Merge? |
This document address frequently asked questions regarding the mail merge process.
Answer 1: Currently mail merge document does not support picture or logo. Unfortunately this limitation is common throughout the JDE E1 system mail merges including Human Resources. The basis of the problem is that using Word to build the template and then save off as a .html form you will have visibility as within the Windows regime and outside of JDE constraints. The Middleware will only use rich text outside of the desktop Windows operating environment (on AS/400 / AIX / Unix / Windows server edition), the OLE is therefore ignored completely and is not incorporated into the output document. Even though you may have this emailing direct, because the UBE is routed via the server, the capability for OLE objects is not there.
Answer 2: That is correct. Everything is grayed out except the Insert Merge Field button because this is a Microsoft Word tool bar and the only part that integrates with EnterpriseOne is the Insert Merge Field button. The rest of the tool bar is disabled.
It is necessary to set this up through a Word Document outside of J.D. Edwards EnterpriseOne. Perform the following:
Answer 3: The Active X Options may not be set correctly. In Internet Explorer go to Tools & Select Internet Options and select the Security Tab. All of the ActiveX options need to be set at either Enable or Prompt.
Answer 4: If the template has the columns aligned, the problem comes when the merge fields are replaced and the replacement values are smaller than the merge fields. This is causing the rest of the line to shift to the left. It is recommended to use a table to force column alignment. Edit the HTML template(BENEFIT.htm) in MS Word. Insert a standard table with as many rows and columns as needed and then copy and paste each item into the correct cell in the table. Users can set the table so that the table grid lines do not display. With this template users may want to insert 4 tables one for each section, each containing 3 columns. Then copy the existing data into the table as in the example below. Once all of the data has been entered into the table, set the table properties to hide the lines. This is done by selecting the entire table and right clicking, then selecting borders and shading and selecting none.
Answer 5: More than one data structure in the Data Structure Field will cause this JAS error. Remove multiple data structures in the data structure field for P05WMMWB.
Answer 6: It is recommended to edit the Mail Merge template directly from Microsoft Word. Regardless of Word version after making changes choose File, Export, Change File Type, choose Save as type to Web Page, Filtered (click Yes to the pop-up to remove Office-specific tags).