#1
|
|||
|
|||
Mail Merge Existing Form Letters
Hello,
I have MS Word form letters that I would like to mail merge. The form letters are all in the same format: email address multiple lines of a form letter new page next email address next multiple lines of a form letter new page etc. Presume this can be done with a macro, but not sure how to structure it. Appreciate any help. Warren |
#2
|
||||
|
||||
See: Mail merge using an Excel spreadsheet - Office Support. Mailmerges generally don't require macros.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Hi Paul,
Thanks for your reply and I understand. This question actually dovetails off of your fantastic macro code to create form letter output with multiple table lines that differ for each recipient. I want to mail merge this output. My thought is to append some additional code to your original macro that: 1) creates a temp output file 2) mail merges the temp output file to each individual recipient 3) deletes the temp output file. I envision this as a workaround to the ongoing challenge of mail merging multiple table lines. Again, I appreciate your response. Warren |
#4
|
||||
|
||||
In that case, see the topic Send Mailmerge Output to Individual Files or the topic Split Merged Output to Separate Documents in the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum: Mailmerge Tips & Tricks
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge - generating multiple letters | myspoonistoobig | Mail Merge | 8 | 10-16-2015 12:03 AM |
Mail Merge pop up to Add Date is ruining my life. 12000 letters = 12000 enters. Help! | MSFlowers | Mail Merge | 4 | 09-01-2015 09:37 PM |
Macro to keep formatted form fields after mail merge or replace text with formatted form fields | jer85 | Word VBA | 2 | 04-05-2015 10:00 PM |
Mail Merge a Protected Form Maintaining Form Fills | t/korean85 | Word | 1 | 04-07-2013 05:34 PM |
Restrict Editing with Mail Merge Form | MEDGE07 | Mail Merge | 2 | 05-03-2012 06:14 AM |