Up front - thank you to those more proficient than I in this subject matter.



I have spent the last several days researching this. I have browsed most of the pertinent questions asked within the Mail Merge Forum. Because of apparent differences between Email and Mail Merge, it may be of benefit to have two forums. Maybe there is and I missed it for I've have not used this site much, but am at wits end to solve the following dilemma.

First, yes, I've read many of Mayors stuff along with Macropod's, in addition to a gazillion other references and sites

Second: This has to do with emailing, and not land locked mailings of hard copied documents. However, after reading below, it may be that a hard document be generated in Word, and attached to an email going to the intended recipient. If than can in fact be done.

The Issue: Each record, that is to be emailed to a recipient, contains information that is found on multiple rows in Excel. Example: A facility may have 2-3-4-X number of chemicals I am interested in, along with other information associated with each of those chemicals. So, it is not feasible to combine all the chemicals into a single cell separated by commas.

Is it possible to do this using Directory and emailing? According to one document I read by Macropod, this cannot be done. This may be the reason that if one uses Directory, then there is no way of telling Word, that I've seen, the document is to be emailed and not mailed.

If in fact it is not possible to email merge multiple lines of information into a single record, then might someone direct me to step by step instructions for inserting "field codes" in Word and basing the If test on a facility identification number. If the facility identification number is the same for say, all 3 chemicals, include all 3 of those in a single document. When the facility identification number changes, then go to a new document.

Am especially interested in sites that explain & instruct about Field Codes and how to use them.

If I must attach a Word document to my email, the instructions how to do so would also be most, most beneficial, and to save what lil hair I have left on my head - smile.

Thanks in advance for those in sharing their knowledge.
Mort