Microsoft Office Forums

Go Back   Microsoft Office Forums > >
Reload this Page Mail merge result in separate world files instead of one file containing all the data Mail merge result in separate world files instead of one file containing all the data
Register FAQ Mark Forums Read

Reply
 
Thread Tools Display Modes
  #1  
Old 12-23-2015, 07:01 AM
xdhbsh xdhbsh is offline Mail merge result in separate world files instead of one file containing all the data Windows 7 32bit Mail merge result in separate world files instead of one file containing all the data Office 2010 32bit
Novice
Mail merge result in separate world files instead of one file containing all the data 		 
Join Date: Dec 2015
Posts: 2
xdhbsh is on a distinguished road
Default Mail merge result in separate world files instead of one file containing all the data

hi,
I regularly make mail merges from an excel list.
I then convert the result into one pdf file to which I give a name.
I then extract each page of this pdf file into as much files as there are pages.
The result is several pages with always the same name + one number beside.
I then have to see the content of each page to give it a more appropriate name.

I am looking for a method that could generate the mail merge in as much files as there are page or lines in the data (xlsx file) instead of one file containing all the records.

is this possible ?

thank you.

kind regards.
Reply With Quote
  #2  
Old 12-23-2015, 08:16 AM
gmayor's Avatar
gmayor gmayor is offline Mail merge result in separate world files instead of one file containing all the data Windows 10 Mail merge result in separate world files instead of one file containing all the data Office 2016
Expert
  
Join Date: Aug 2014
Posts: 4,142
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default
Do you mean like - http://www.gmayor.com/individual_merge_letters.htm
or http://www.gmayor.com/MergeAndSplit.htm ?
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 12-23-2015, 06:08 PM
macropod's Avatar
macropod macropod is offline Mail merge result in separate world files instead of one file containing all the data Windows 7 64bit Mail merge result in separate world files instead of one file containing all the data Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
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
Quote:
Originally Posted by xdhbsh View Post
I regularly make mail merges from an excel list.
I then convert the result into one pdf file to which I give a name.
I then extract each page of this pdf file into as much files as there are pages.
...
I am looking for a method that could generate the mail merge in as much files as there are page or lines in the data (xlsx file) instead of one file containing all the records.

is this possible ?
Did you look at the Send Mailmerge Output to Individual Files topic in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum???
https://www.msofficeforums.com/mail-...ps-tricks.html
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 12-24-2015, 12:23 AM
xdhbsh xdhbsh is offline Mail merge result in separate world files instead of one file containing all the data Windows 7 32bit Mail merge result in separate world files instead of one file containing all the data Office 2010 32bit
Novice
Mail merge result in separate world files instead of one file containing all the data 		 
Join Date: Dec 2015
Posts: 2
xdhbsh is on a distinguished road
Default
looks like it, many thanks. I'll try it and revert.
thank you
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools
Display Modes
Linear Mode Linear Mode


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge result in separate world files instead of one file containing all the data Word 2010 - directory mail merge - two separate group of data in one document htsu Mail Merge 2 03-07-2016 03:10 PM
Mail merge result in separate world files instead of one file containing all the data Mail Merge Drops Data File Office 2013 ottman88 Mail Merge 4 06-05-2015 03:16 AM
Mail merge result in separate world files instead of one file containing all the data Checking data in separate files ksigcajun Excel Programming 7 05-22-2014 08:54 AM
Mail merge result in separate world files instead of one file containing all the data Creating separate file for each mail merge doshshirl Mail Merge 3 02-15-2014 08:49 PM
converting a word document to a data file for mail merge drsuis Mail Merge 4 02-21-2013 03:34 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:11 PM.

Contact Us - Privacy Statement - Top

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft