LinkBack URL
About LinkBacks
I have a mail merge document that has about 40 pages I need to individually export and name them in a specific manner. Is it posisble to create a Micro that will export each page and then name the file based on specific merge fields?
I have a mail merge document that has about 40 pages I need to individually export and name them in a specific manner. Is it posisble to create a Micro that will export each page and then name the file based on specific merge fields?
Once you've completed a merge, there are no mergefields for a macro to query. Instead, see Send Mailmerge Output to Individual Files and Split Merged Output to Separate Documents in the Mailmerge Tips and Tricks thread at:
http://www.msofficeforums.com/mail-m...ps-tricks.html
or:
http://windowssecrets.com/forums/sho...ips-amp-Tricks
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
i'm sorry, I must have done a terrible job explaining, because I can export and name based on a merge field. I was able to find code online and modify it do it kinda. I just don't know how to make it repeat, or ideally let me tell it to do the first 30 records or something like that.
Please Login or Register to view this content.
The code you posted isn't for what your first post described. You really should look at the Send Mailmerge Output to Individual Files topic in the link I provided.
No. It is what I described. Or as close as I could get since I didn’t know how. The macro exports the mail merge document and names it based on merge fields. Not sure how that isn’t as described.Originally Posted by macropod
Your first post says:So, unless you're saying the mailmerge main document is 40 pages long, the clear implication is that the 40-page document is the output document. Regardless, I've twice referred you to an article that says how to achieve what you want via a macro that runs from the mailmerge main document.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks