Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-12-2021, 05:11 AM
sureshbvs sureshbvs is offline Mail Merge - Create seperate Mail merge pdf for each sheets of an excel file Windows 10 Mail Merge - Create seperate Mail merge pdf for each sheets of an excel file Office 2007
Novice
Mail Merge - Create seperate Mail merge pdf for each sheets of an excel file
 
Join Date: Mar 2021
Posts: 1
sureshbvs is on a distinguished road
Question 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
Reply With Quote
  #2  
Old 03-12-2021, 05:42 AM
macropod's Avatar
macropod macropod is online now Mail Merge - Create seperate Mail merge pdf for each sheets of an excel file 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: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

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]
Reply With Quote
Reply

Tags
mail merge code, vba code, word 2007

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge - Create seperate Mail merge pdf for each sheets of an excel file Mail Merge: Using One Excel File with Multiple Sheets Townshend Mail Merge 19 06-25-2021 12:39 AM
Mail Merge - Create seperate Mail merge pdf for each sheets of an excel file Insert slip sheets during a mail merge mcboats2 Mail Merge 1 12-07-2015 05:01 PM
Mail Merge - Create seperate Mail merge pdf for each sheets of an excel file Mail merge from excel - need to create sheets and create a table bluenosebex Mail Merge 5 08-02-2015 05:34 PM
Mail Merge - Create seperate Mail merge pdf for each sheets of an excel file 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
Mail Merge - Create seperate Mail merge pdf for each sheets of an excel file 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 06:41 AM.


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