Email Directory Mail Merge Code

Question

I have an Access query as data source for mail merge from Word to Outlook. My data source like this:

Full_Name        Course       NPDD       CENDATE     LDTD     Email

John Doe          ART 001    1/1/2015   2/2/2015     3/3/2015 ******@hotmail.com

John Doe          ART 002    1/1/2015   2/2/2015     3/3/2015 ******@hotmail.com

Jane Doe          MGMT 001 1/1/2015  2/2/2015     3/3/2015 ******@hotmail.com

Jane Doe          ACCT 001   1/1/2015  2/2/2015     3/3/2015 ******@hotmail.com

I looked at and tried to figure out how to do it: https://support.microsoft.com/en-us/kb/294686 

Dear John Doe:

Below is your class, bla bla

Course       NPDD       CENDATE     LDTD    

ART 001    1/1/2015   2/2/2015     3/3/2015 

ART 002    1/1/2015   2/2/2015     3/3/2015

So John Doe would only receive one email with courses listed. Then, next email send to Jane Doe.

I opened Outlook, then Word and tried to Ctrl+F9 to insert fields in Word following above Microsoft example but could not do it. Can someone provide Word code? Thank you very much.

Answer 1

Do you mean {chemical 1} etc code in your tutorial? I could not understand the code.

There is no "{chemical 1} etc code" in my tutorial to understand. You should download the tutorial (and read, specifically, the topic 'Merging by Catalog/Directory to E-Mail'), for which I provided links in my first post, not the entirely unrelated field codes in the other link.

Answer 2

Hi, Paul:

Do you mean {chemical 1} etc code in your tutorial? I could not understand the code.

I put my file link Merge which has Access data source and Word email doc. Can you take a look?

Thanks.

Answer 3

A working sample set of Word field codes is included in my tutorial.

As for Doug's addin, he's given some installation instructions in this thread: http://answers.microsoft.com/en-us/office/forum/office_2013_release-word/email-merge-varying-amounts-of-information-in/e26aed84-4031-4546-b01f-ec3e4f407af9

Do note that you can't use the field codes from my tutorial with Doug's addin.

Answer 4

Thank you for quick reply. I tried those sites. I also tried to download that add in before I post the question. I follow those add-in instruction and cannot figure out how to get it to work. I've tried for 2 days already and cannot figure out. Can you provide Word field codes in my situation?

Answer 5

You can use Word's Catalogue/Directory Mailmerge facility for this (the terminology depends on the Word version). To see how to do so with any mailmerge data source supported by Word, check out my Microsoft Word Catalogue/Directory Mailmerge Tutorial at:

http://windowssecrets.com/forums/showthread.php/154370-Microsoft-Word-Catalogue-Directory-Mailmerge-Tutorial

or:

http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip

The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it.

Alternatively, you may want to try the Many-to-One Mail Merge add-in, from Doug Robbins at:

http://bit.ly/1hduSCB

In addition to a 'Many to One' merge, the latter handles:

• Merge with Charts

• Duplex Merge

• Merge with FormFields

• Merge to email with Attachments

• Merge to Individual Documents

• Merge, Print and Staple