Microsoft Office Forums Mail merge result in separate world files instead of one file containing all the data

Go Back   Microsoft Office Forums > >

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 online now 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: 2,952
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
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: 19,577
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
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
[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

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 10:51 PM.


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