View Single Post
 
Old 12-02-2011, 08:24 AM
SaneMan SaneMan is offline Windows 98/ME Office 2003
Novice
 
Join Date: Jan 2011
Posts: 20
SaneMan is on a distinguished road
Default Automatically split Mail Merge based on number of pages

Hello

I'm working on a project and wondered if one of you could help with a query I have.

I'm issuing a number of licences (10,000 in total) via a mail merge. Each licence will have 7 pages. I'm trying to figure out how, after I complete the mail merge, I can run a macro to split the document into individual licences and save the licences with a filename based on the licence number (I assume assigning this licence number field a particular style would be the way to do this).

I've attached a mock up example to this post which shows the correct amount of pages and the licence number field (this will be two letters followed by some numbers and two more letters, i.e. 'AB1234CD').

Does anybody know of a Macro which can carry out this task? I've found a variety of them but none of them seem to satisfy the specific one I need. Any help would be greatly appreciated.

Many thanks.
Attached Files
File Type: doc Example_MM.doc (147.0 KB, 8 views)
Reply With Quote