Mail Merge - Create seperate Mail merge pdf for each sheets of an excel file

sureshbvs · #1 03-12-2021, 05:11 AM

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

macropod · #2 03-12-2021, 05:42 AM

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.

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