0

I'm doing a mail merge from a Access database and I'd like to make many documents from the mail merge, instead of just one. I found a macro that lets me split the merged document after it's made, that but it names the documents 1, 2, 3 etc. I have hundreds of documents I need to make, and renaming them manually is not workable.

3
  • Have you tried this add-in: gmayor.com/individual_merge_letters.htm
    – heavyd
    Nov 19, 2014 at 17:35
  • Please update your question to clarify your requirements. You have not specified what the output file should look like. You don't want numbers... now you say you want the name based on content. What content would this be?
    – Sun
    Nov 20, 2014 at 17:25
  • I want the filename to be based on a field name called posting title in the document. The field is filled from the mail merge process. Nov 20, 2014 at 17:29

1 Answer 1

1

You can use a VBA script to separate the document into individual files.

There are also various PDF print drivers such as PDF Creator that can either print individual PDF files automatically, or split them into individual files after they are printed to one giant file.

1
  • That code works, but it still outputs the files with numbers as the filenames. I need to be able to name the files based on their content. Nov 20, 2014 at 15:33

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .