|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Mail Merge - Create seperate Mail merge pdf for each sheets of an excel file
Hi all, I create a Mail Merge in WORD, using the database of excel. I have around 100+ sheets in that excel file . I need to generate seperate Mail Merge pdf for each sheets. Can anyone help to create VBA for the same? Regards Suresh Babu |
#2
|
||||
|
||||
Mailmerge only works with one worksheet as the data source. Any macro that does what you want would have to connect to each sheet in turn, process that sheet, then disconnect from it before moving to the next.
Depending on your data, it may be a whole lot simpler to employ a worksheet that consolidates the data from all the rest, then just use a single mailmerge for that worksheet.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
mail merge code, vba code, word 2007 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge: Using One Excel File with Multiple Sheets | Townshend | Mail Merge | 19 | 06-25-2021 12:39 AM |
Insert slip sheets during a mail merge | mcboats2 | Mail Merge | 1 | 12-07-2015 05:01 PM |
Mail merge from excel - need to create sheets and create a table | bluenosebex | Mail Merge | 5 | 08-02-2015 05:34 PM |
Would like to mail merge excel spreadsheet with word doc and create new page when a catagory changes | esherwood | Mail Merge | 1 | 07-21-2014 09:55 PM |
Code for mail merge to reference saved excel file | jtemp57 | Word VBA | 10 | 12-16-2013 11:02 PM |