Thread: [Solved] Mail Merge - Create seperate Mail merge pdf for each sheets of an excel file
View Single Post
 
Old 03-12-2021, 05:42 AM
macropod's Avatar
macropod macropod is offline Windows 10 Office 2016
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,962
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