Hi,

I would like to know if I can have each mail merge saved in one Word file instead of copying and pasting each of them into a separate file. I have 1,000 mail merges of transactions so i need to have 1,000 Word files.

You can do this with a macro. See: http://www.gmayor.com/individual_merge_letters.htm. The code there is for a PC, though, and would probably need modification to work on a Mac.

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

Thanks a lot! May I know if I can save the individual files as a Word file instead of PDF

The link shows how you can save to a variety of formats, PDF being only one of them. See, for example, the 'Split the single merged document into separate letters' example. See also the discussion at: http://www.mrexcel.com/forum/general...ml#post3694494. With the specific post linked to, you can generate PDFs or docx files - or both at the same time - using the same basic code.

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