#1
|
|||
|
|||
Filename and seperating docs
I am using a excel sheet to export rows of data. I have created a template with all the fields and it works as a 'letter'! When I go to preview - I have one doc shown correctly, then I go to merge docs of about 20 in the excel sheet and it creates the first doc then adds all the other 20 docs within the same output doc?
I want obviously for it to seperate each by line and secondly, how do i save it with the reference from within the excel as the file name? I have searched and cannot find a clear explanation of what is going wrong. Any help is appriciated. |
#2
|
||||
|
||||
See:
• Send Mailmerge Output to Individual Files; and • Run a Mailmerge from Excel, Sending the Output to Individual Files, 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] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
filename field not displaying correct filename when that name starts with # | plrsmith | Word | 1 | 07-06-2018 03:10 AM |
Filename | UnlimitedPower | Word VBA | 1 | 08-19-2016 12:22 AM |
Seperating Excel from Pivot | KevinD | Excel | 3 | 11-12-2014 08:13 AM |
Seperating Microsoft Word documents into seperate documents | nanders8 | Word VBA | 2 | 08-28-2014 09:37 PM |
Seperating text data | philb | Excel | 4 | 10-31-2013 10:37 AM |