#1
|
|||
|
|||
Mail Merge while retaining Macro Button
I'm mail merging documents (using a macro to save as individually named files) - this part is working fine, but the document has an email submit button so that the user can automatically sent the document back to a defined email address. When merging the files down they only save as .doc or .pdf and therefore loose the macro that allows the user to email the document back. Any ideas? |
#2
|
||||
|
||||
Macros in a mailmerge main document are never transferred to the mailmerge output files. Consequently, you would need to add the macros to those files post-merge. PDFs cannot contain Word macros.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
||||
|
||||
Cross-posted at: http://www.excelforum.com/word-progr...ro-button.html
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
Tags |
email, macro, merge |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge keeping VBA Macro | Piney | Word VBA | 5 | 08-03-2015 04:12 PM |
Mail Merge Macro | ch1325 | Word VBA | 2 | 06-08-2015 06:18 AM |
Mail Merge Macro | spc94 | Word VBA | 2 | 06-04-2015 07:06 AM |
Macro to loop through all cells in a table produced by a mail merge | elh52 | Word VBA | 4 | 08-31-2014 10:50 PM |
Word Doc Macro (mail Merge) | ajolson1964 | Word VBA | 1 | 05-10-2011 10:15 PM |