Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-02-2011, 08:24 AM
SaneMan SaneMan is offline Automatically split Mail Merge based on number of pages Windows 98/ME Automatically split Mail Merge based on number of pages Office 2003
Novice
Automatically split Mail Merge based on number of pages
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
dynamic charts based on mail merge fields jwajehee Mail Merge 0 10-05-2011 09:47 AM
Automatically split Mail Merge based on number of pages Mail Merge, Number to 2 Decimal Places Vampy99 Mail Merge 7 09-25-2011 05:41 AM
Automatically split Mail Merge based on number of pages Inserting pages at the end of a mail merge morten_lysgaard Mail Merge 3 07-25-2011 11:19 PM
Automatically split Mail Merge based on number of pages Mail merge number fields outputting inconsistently rekcots Mail Merge 2 05-18-2011 06:32 AM
delete blank pages from mail merge document blusea Word 0 12-17-2010 06:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:34 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft