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

		Microsoft Office Forums > Microsoft Word > Word VBA
Mail Merge - Create seperate Mail merge pdf for each sheets of an excel file

FAQ

Thread Tools

Display Modes

03-12-2021, 05:42 AM

macropod

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

Office 2016

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,521

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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:40 AM.