Hi,



I need some help with Mail Merge please. I have a standard document with header and footer. I am trying to merge the document with an Excel file containing names and usernames.

At the end of it, I would like the output files to be in SEPARATE documents prefixed with "Participant - Letter - Team Member" then first name last name of the participant - based on the fields from the Excel file. Example: Participant Letter - Team Member - Angelo Agujo.

I tried the individual merge software from gmayor, http://www.gmayor.com/individual_merge_letters.htm, but the output files created results in 3 pages instead of just 1 page.

Any help with this much appreciated.

Attached Files

myTSA Knowledge Sample MailMerge Output.docx (39.6 KB, 11 views)

Hi agujoa,

That suggests your mailmerge would ordinarily produce three pages per recipient. Have you checked that, aside from all letters being in the same document, the output is formatted correctly when you don't use the addin?

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

When I dont use the add-in, the output is one page per recipient, and the output is formatted correctly.

Hi agujoa,

In that case, it seems the issue has to do with how you're using the addin. It's not something I've used, so I can't give any specific advice. You could, of course, ask Mr Mayor, from whose site you obtained the addin. There's an email feedback link on this page: http://www.gmayor.com/index.htm

I did notice that your attachment had a Section break at the bottom of the page. If that's indicative of your mailmerge main document's content, that might be part of the issue.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]