Using Email and Mail Merge

This chapter provides an overview of email and mail merge, and discusses how to:

Click to jump to parent topicUnderstanding Email and Mail Merge

The email feature is integrated into the JD Edwards EnterpriseOne system and enables you to send email messages to groups or individuals without using a separate program, such as Microsoft Outlook or Lotus Notes. You can send saved messages and create new messages, and you can vary the recipients.

Rather than specifying long lists of email recipients, you can easily create groups that are comprised of individuals or subgroups. For example, you might create a groups for customers, local or regional associates, or employees in the department.

As business needs change, you can modify email groups.

If you routinely send mass emails or regular mailings, the Email Merge and Mail Merge features might be beneficial.

The Mail Merge feature is driven by a wizard that guides you through the process of selecting a template and configuring it for the mailing. This process is similar to the one that is used by the Proposal Generation feature.

Email merge works like a traditional mail merge, enabling you to create personalized communications that automatically retrieve information from the JD Edwards EnterpriseOne system such as the recipient's name, address, and so on.

Click to jump to parent topicManaging Email Groups

This section provides an overviews of email groups and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding Email Groups

The Email Group application enables you to create new email groups and add or remove individuals from groups.

You create new email groups in two steps: first create the group, and then add to the group the subgroups or individuals who will be included in the email's distribution when it is sent.

If you are adding one or more subgroups to a new group, it might be helpful to think in terms of hierarchy. For example, suppose you want to create a group that includes the entire sales force. The Entire Sales Force email group might consist of groups for the southern, northern, eastern, central, and western regions. However, there might be times when you want to send emails only to the western and northern sales regions, so you would still need to maintain those smaller email groups in addition to the group that includes the whole sales force.

Note. Before you create email groups you must create records in the Who's Who table (F0111) for the individuals that you want to include in the group. You can only include individuals or groups who have a record in the F0111 with a line type greater than zero (0). You can create these records by entering a contact in the CRM system, or by entering a who's who record directly into the Address Book system.

Additionally, an electronic address (email address) must exist in the F0111) for any individual that you include in an email group. You can set up the email address when you enter the contact information in the CRM system or when you enter the who's who information in the Address Book system.

See Also

Entering Contact Information

Adding Who's Who Information to Address Book Records

Click to jump to top of pageClick to jump to parent topicForms Used To Manage Email Groups

Form Name

FormID

Navigation

Usage

Search for Email Groups

W90CA510C

Sales Force Automation Setup (G90CA03), Email Group

Select an existing email group, or access forms to create a new group.

Add Email Group

W90CA510I

Click Add on the Search for Email Groups form.

Create an email group.

Email Group - Manage <Group Name>

W90CA510B

Select an email group on the Search for Email Groups form.

Maintain an email group.

Click to jump to top of pageClick to jump to parent topicCreating Email Groups

Access the Add Email Group form.

To create an email group:

  1. Enter the group name and type, and enter any comments for the group.

  2. Click the button corresponding to the action that you want to take:

Click to jump to top of pageClick to jump to parent topicMaintaining Email Groups

Access the Search For Email Groups form.

To add or remove a person from a group:

  1. Find and select the group to which you want to add subgroups or individuals.

  2. On the Email Group - Manage <Group Name> form, click Add Email Group to add a subgroup to the new group.

  3. On Search for Email Groups, find and select the subgroups that you want to add to the new group.

  4. On Email Group - Manage <Group Name>, click Add Person to add individuals to the new group.

  5. On Search For Individuals, find and select individuals to add to the new group.

  6. If you want to remove a subgroup or person from the new group, select the groups or persons and then click Remove Email Group or Remove Person.

Click to jump to parent topicManaging Emails

This section provides an overview of the email application and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding the Email Application

You can use the email application to view previously created email messages, or to create new email messages, which you can send when you choose. You can create a variety of template messages for notification or information, and then create distribution lists according to timing or product interest.

Distribution lists can consist of groups or individuals, and you can easily remove a group or individual that is currently on the distribution list for a particular message.

If the email requires an attachment, you can easily add additional text on the email record's Attachment tab. You can also attach an image, spreadsheet, video clip, or other media object.

After you have created an email, you determine when the message is sent to the server for distribution to the groups or individuals that you specified. After you submit the email for distribution, you can check delivery status periodically.

Click to jump to top of pageClick to jump to parent topicForms Used to Use the Email Application

Form Name

FormID

Navigation

Usage

Search for Emails

W90CA500E

  • Daily Sales Force Automation Processing (G90CA01), Email

  • Daily Support Processing (G90CE01), Email

Find and select existing email messages.

Add Email

W90CA500C

  • On the Search for Emails form, click Add.

  • Click Create Email on the Email Group - Manage <Group Name> form.

Add a new email.

Email - Manage <Email Name>

W90CA500A

On the Search for Emails form, select a previously created email message.

View or modify email information, and add or remove an email group or person.

Member For <Email Group Name>

W90CA510E

Click the link for an email group record on the Email - Manage <Email Name> form's Email Group List grid.

View email group detail information.

Individual Summary

W90CA510H

Click the link for an individual record on the Email - Manage <Email Name> form's Person List grid.

View individual email recipient detail information.

Click to jump to top of pageClick to jump to parent topicViewing and Modifying Existing Email Information

Access the Email - Manage <Email Name> form.

  1. On the Email - Manage <Email Name> form's Detail tab, view or modify the email subject and message body on the top portion of the form.

  2. In the Email Group List and Person List grids, view or modify email groups and individual email recipients already added to the email message.

  3. To view or modify information about a specific email group or person, click the link for the group or person in the Email Group List and Person List grids.

  4. To view or modify attachment information for the email message, select the Attachments tab.

  5. If you want to send separate emails to individual recipients, select Send individual email to recipients.

    If you do not select this option, the system sends one email message containing a list of all recipients in the To field, and all recipients can see the other recipient names.

  6. If you want to create an activity for each person in the Person List grid, select the option Create activity for contacts.

  7. When you are finished viewing email information, save or undo any changes that you made, and then click Close.

Click to jump to top of pageClick to jump to parent topicCreating Email Messages

Access the Add Email form.

  1. Complete the Subject and Body fields for the message.

  2. Click the button corresponding to the action that you want to take:

  3. If you plan to use the Email Merge feature, you must select the option Send individual emails to recipients.

    If you do not select this option, the Email Merge feature may not function correctly.

Click to jump to top of pageClick to jump to parent topicCreating Email Attachments

Access the Email - Manage <Email Name> form.

  1. Find and select the email to which you want to add an attachment.

  2. Select the Attachments tab.

  3. To add supplemental text to the attachment, enter the text in the text box on the form.

  4. To attach a document, image, URL, or other media object, click the media object button (the magnifying glass and document) to launch the Media Objects application.

  5. Click Save Changes or Undo Changes, and when you are finished, click Close.

See JD Edwards EnterpriseOne Tools 8.98 Foundation Guide

Click to jump to top of pageClick to jump to parent topicAdding or Removing Distribution Groups and Individuals

Access the Email - Search For Emails form.

  1. Select the email for which you want to create a distribution.

  2. On Email - Manage <Email Name>, click Add Email Group to add a group of email recipients.

  3. On Search for Email Groups, find and select the groups that you want to add to the email.

  4. On Email - Manage <Email Name>, click Add Person to add individual email recipients for the email.

  5. On Search For Individuals, find and select individuals to receive the email.

  6. If you want to remove an email group or person from the distribution list, select the groups or persons and then click Remove Email Group or Remove Person.

Click to jump to top of pageClick to jump to parent topicSending Emails

Access the Search For Emails form.

  1. Find and select the email that you want to send.

  2. On Email - Manage <Email Name>, make any final modifications to the subject, email message, or distribution list.

  3. Click Send Email to send the email message.

Click to jump to top of pageClick to jump to parent topicTracking Sent Emails

Access the Search For Emails form.

  1. Find the email message for which you want to check a status.

  2. In the grid area, scroll to the right until you reach the Status column, which displays the current status for all emails that you found.

Click to jump to parent topicUsing the Email Merge Feature

This section provides an overview of the Email Merge feature and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding Email Merges

You access the Email Merge feature from the Contact or Employee applications. This feature is integrated into the email application, so you set up an email merge on the same form where you enter or modify email messages.

When you set up an email merge, you insert tokens into the email body. These tokens are replaced by the system with information from the Address Book and Who's Who tables. When used in conjunction with the Email Group application, the Email Merge feature enables you to create a single email message that is sent to the individuals and subgroups in the email distribution list. However, if you include a token in the salutation, when the recipient receives the email message it contains the recipient's name instead of “Dear Sir or Madame.” You use other tokens for addresses, telephone numbers, or any other information in the Address Book or Who's Who tables.

Click to jump to top of pageClick to jump to parent topicForms Used to Use the Email Merge Feature

Form Name

FormID

Navigation

Usage

Contact - Email and Mail Merge Utility

W90CA070D

Daily Sales Force Automation Processing (G90CA01), Contact

CRM Foundation Daily Processing (G90C01), Contact

Daily Support Processing (G90CE01), Contact

On the Search For Contacts form (W90CA070C), click the Email and Mail Merge Utility link.

Locate contacts and access the Email Merge feature.

Email - Manage <Email Name>

W90CA500A

On the Contact - Email and Mail Merge Utility form or the Employee - Email and Mail Merge Utility form, click Email Merge.

Create a new email.

Employee - Email Merge

W90CA040E

Periodic Sales Force Automation Processing (G90CA02), Employee

CRM Foundation Daily Processing (G90C01), Employee

On the Search For Employees form (W90CA040F), click the Email Merge Utility link.

Locate employees and access the Email Merge feature.

Employee - Email - Manage

W90CA500A

On the Employee - Email Merge form, find and select an employee, and then click Email Merge.

Select an employee and launch the email application.

Click to jump to top of pageClick to jump to parent topicSetting Up an Email Merge for Contacts or Employees

For contacts, access the Contact - Email and Mail Merge Utility form.

For employees, access the Employee - Email Merge form.

8

  1. Find and select the contacts or employees for whom you want to create the email merge, and then click Email Merge.

  2. On Contact - Email - Manage (or Employee - Email - Manage for employees), enter the email subject, body, and other fields on the upper half of the form as you would for a normal email message.

  3. Add or remove subgroups or individuals from the distribution list.

  4. Insert the tokens that you want to include in the body of the email.

    See Inserting Tokens in the Email Body.

  5. Click Send Email to send the message immediately, or to save the message for sending at a later time or date, click Save Changes.

Note. Before you run the email merge, verify on the Email - Manage <Email Name> form that you selected the option Send individual emails to recipients. If you did not select this option, the Email Merge feature may not operate correctly.

Click to jump to top of pageClick to jump to parent topicInserting Tokens in the Email Body

You can insert fields from the Address Book (F0101) or Who's Who (F0111) tables in the email body as a token, and the token will appear as entered when email recipients open the email. When you insert a token, be sure to surround the token with brackets on both sides, as in {token}.

Currently, all fields in the F0101 and F0111 tables support the Email Merge feature. Fields added to these tables after the general availability date may not support email merge. If you insert an unsupported token, the token will not be substituted with information from the Address Book or Contact tables.

The table lists the most commonly used tokens that you can insert into the body of an email message.

Token Name

Token Description

Token Source

Address Number

ABAN8

Address Book table (F0101)

Address Number

WWAN8

Who's Who table (F0111)

Alpha Name

ABALPH

Address Book table (F0101)

Title

WWATTL

Who's Who table (F0111)

Alpha Name

WWALPH

Who's Who table (F0111)

Click to jump to parent topicUsing the Mail Merge Wizard

This section provides an overview of mail merges and discusses how to:

Click to jump to top of pageClick to jump to parent topicUnderstanding Mail Merges

The Mail Merge feature enables you to create documents, envelopes, and labels in PDF format that can be used to do a mail merge. Mail Merge uses a wizard that guides you through the mail merge process, from selecting a template, generating envelopes or labels, viewing a preview of the generated mail merge document, and finalizing the process.

Mail Merge is template-driven, and you assemble the merge document by using only the template components that you need.

Mail Merge templates can reside on a local machine or on a server. Templates created by the template creation program are saved on the server, but you can maintain local copies of the template.

Templates stored on the server are kept in the same location, which means that when you do a mail merge there is no distinction between a template created as a Mail Merge document, envelope, or label. Consequently, when you create Mail Merge templates you should assign names that will help you remember the template's purpose when you do a mail merge.

You use data sets and simple templates to set up mail merge and envelope templates. You use the same programs and processes to create templates for mail merges as you do for proposal generation. The only difference in the setup for mail merge or envelope/label templates is the template type. You use these template types for mail merge and envelope/label templates:

After you set up mail merge templates, you can run a mail merge. You access the Mail Merge feature from the Contact application. Before you launch the Mail Merge wizard, you must first select the contacts for whom you want to produce the Mail Merge document or envelope. Each of the contacts selected must have an address that has been flagged as the main address.

The Mail Merge wizard validates all of the data against the document and envelope templates. If data is missing, those rows are displayed but not included in the mail merge. (For example, the surname might be included in the template, but there is no system data for the surname.) The only exception for missing data is address lines 2, 3, and 4. In this case, the rows that are missing the address line data are not displayed, but are included in the mail merge.

See Also

Generating Sales Proposals

Click to jump to top of pageClick to jump to parent topicForms Used to Use the Mail Merge Wizard

Form Name

FormID

Navigation

Usage

Mail Merge Setup

W90CA242B

Sales Force Automation Setup (G90CA03), Mail Merge Setup

Access forms to set up mail merge templates.

Envelope/Label Setup

W90CA242B

Sales Force Automation Setup (G90CA03), Envelope/Label Setup

Access forms to set up envelope and label templates.

Search For Contacts

W90CA070C

Daily Sales Force Automation Processing (G90CA01), Contact

CRM Foundation Daily Processing (G90C01), Contact

Locate and view contacts, and access the Email and Mail Merge Utility form.

Contact - Email and Mail Merge Utility

W90CA070D

On the Search For Contacts form, click the Email and Mail Merge Utility link.

Search for the contacts and launch the Mail Merge wizard.

Contact - Mail Merge Wizard - Select Template

W90CA23BA

On the Contact - Email and Mail Merge Utility form, click Mail Merge.

Specify whether you are using local or central templates for the mail merge.

Mail Merge Wizard - Select Central Template

W90CA23BB

Click Next on the Contact - Mail Merge Wizard - Select Template form.

Select a centrally located template.

Mail Merge Wizard - Select Local Template

W90CA23BC

Click Next on the Contact - Mail Merge Wizard - Select Template form.

Select a local template.

Mail Merge Wizard - Select Envelope Template

W90CA23BD

Click Next on the Mail Merge Wizard - Select Central Template or Mail Merge Wizard - Select Local Template form.

Select an envelope or label template.

Generating Mail Merge

W90CA23BJ

Click Next on the Mail Merge Wizard - Select Envelope Template form.

Finalize the mail merge process.

Click to jump to top of pageClick to jump to parent topicCreating Mail Merge and Envelope Templates

Access the Mail Merge Setup form.

To create Mail Merge templates, you use the same processes and programs that are used to create proposal generation templates. The process for creating Mail Merge templates is nearly identical to creating proposal generation templates. The only difference is that Mail Merge templates use the template type MM for Mail Merge and EN for envelopes.

The table lists the fields that can be inserted into a Microsoft Word RTF document when you create a Mail Merge or envelope and label template. During the mail merge process the token is replaced with information from the system:

Token Name

Token Description

Source

PMMAddressLine1

WLADD1

F01161

PMMAddressLine2

WLADD2

F01161

PMMAddressLine3

WLADD3

F01161

PMMAddressLine4

WLADD4

F01161

PMMCountry

WLCTR

F01161

PMMState

WLADDS

F01161

PMMCity

WLCTY1

F01161

PMMZipCodePostal

WLADDZ

F01161

PMMCountyAddress

WLCOUN

F01161

PMMCompanyName

WWALPH

F0111

PMMMailingName

WWMLNM

F0111

PMMContactTitle

WWATTL

F0111

PMMSalutationName

WWSLNM

F0111

PMMGivenName

WWGNNM

F0111

PMMMiddleName

WWMDNM

F0111

PMMSurname

WWSRNM

F0111

PMMSecondaryMailingName

WWMLN1

F0111

PMMNickName

WWNICK

F0111

Required System Setup

To process mail merge templates and view the generated PDF documents, you must first set up information in the JD Edwards EnterpriseOne system. Typically, the system administrator is responsible for setting up this information. Contact your system administrator or customer support for assistance with these setup tasks.

System setup includes:

Setup Step

Description

Enter the mail merge file location in the JDE.ini file.

To generate mail merge documents, set this setting in the jde.ini file:

[MAILMEGE] File Location=C:\WINNT\TEMP

After you add this setting to the jde.ini file, you must restart JD Edwards EnterpriseOne services to generate mail merge documents.

Create a folder called MailMerge under the webclient.war directory.

To view generated PDF documents, you must create this folder within the JAS server instance. For example:

x:\WebSphere\AppServer\installedApps\[machine_name]\EA_JS_[99]_[machine_name].ear\webclient.war\MailMerge

Specify the location of the mail merge folder in the jas.ini file.

After you create the MailMerge folder, you must specify the location of the folder in the jas.ini folder using this setting:

[MAIL MERGE AND DOC GEN] MailMergeLocation= x:\WebSphere\AppServer\installedApps\[machine_name]\EA_JS_[99]_[machine_name].ear\webclient.war\MailMerge

See Also

Generating Sales Proposals

Click to jump to top of pageClick to jump to parent topicProcessing a Mail Merge

Access the Contact - Email and Mail Merge Utility form.

  1. Find and select the contacts for whom you want to do the mail merge.

    Note. All of the contacts listed in the grid on the Contact - Email and Mail Merge Utility form are included in the mail merge, so before continuing make sure the appropriate contacts are listed.

  2. On the Contact - Mail Merge Wizard - Select Template form, specify whether the template you want to use is located on the local machine or on a central server.

  3. If you are using a template located on a central server, On the Mail Merge Wizard - Select Central Template form, find and select the template that you want to use.

    If you are using a local template, specify the template name and then click Upload Template on the Mail Merge Wizard - Select Local Template form.

  4. If you want to produce an envelope or label, select Mail Merge Generate Envelopes/Labels on the Mail Merge Wizard - Select Envelope Template form, and then specify whether the envelope template is on a central server or the local machine.

  5. If you are using an envelope template located on a central server, find and select the template that you want to use on the Mail Merge Wizard - Select Central Envelope or Label Template form.

    If you are using a local envelope template, specify the template name and then click Upload Template on the Mail Merge Wizard - Select Local Envelope or Label Template form.

  6. While the letters and envelopes are generating, the Generating Mail Merge form appears; click Next to continue.

  7. On the Mail Merge Wizard - View form, click View Letters or View Envelopes/Labels to view the generated mail merge letters or envelopes respectively.

    To view letters and envelopes, you must have Adobe Acrobat Reader or some other application capable of displaying PDF files.

  8. To make modifications to either letters or envelopes, click Previous until you reach the appropriate form where you can make changes.

  9. When you are satisfied with the generated letters and envelopes, save them in the Adobe Acrobat Reader application.

    After saving, click Finish on the Mail Merge Wizard - View form.

    Warning! Be sure to save the merged letters and envelopes or labels before you click Finish. If you click Finish before saving in the Adobe Acrobat Reader application, the information that you entered to create the generated letters and envelopes will not be saved, and you must create them again.