![]() |
|
#1
|
||||
|
||||
![]() Yes. FWIW, if you: 1. save it in your mailmerge main document (which means using the .doc or .docm format) 2. rename the macro to MailMergeToDoc 3. insert the line: ThisDocument.MailMerge.Execute Pause:=False after: Dim oPara As Paragraph the macro will run automatically when you click on the 'Edit Individual Documents' button. PS: When posting code, please use the code tags, indicated by the # button on the posting menu. Without them, your code loses much of whatever structure it had.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#2
|
|||
|
|||
![]()
Good morning*
Just tried the original macro and it pauses to process for about 3 seconds but nothing happens (No errors) I also tried as you suggested (rename + ThisDocument.MailMerge.Execute Pause:=False) but a receive the following error when I click on "Finish & Merge" "Edit individual documents" This method or property is not available because the document is not a mail merge main document Any ideas ? Honestly, I don't have to use a table, but it helps me with the alignment of the merged data, which I cannot align otherwise (I've tried...) If you could, can I ask you to please help me alight the column headers (Date, Time and Location) with the corresponding mergefields just below ? Date and time vary in lenght Thanks for your help! |
#3
|
|||
|
|||
![]()
I believe I finally understand the alignment part
(will confirm once back in the office) |
#4
|
||||
|
||||
![]()
That suggests you added it to something other than your mailmerge main document...
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
jhato160 | Excel | 14 | 08-01-2016 11:24 AM |
VBA Pivot Table CubeField Enable multiple items | Wries | Excel Programming | 0 | 03-13-2014 09:56 AM |
After merging a reviewer's changes, formatting is lost | cassidyjames | Word | 0 | 03-27-2012 01:48 PM |
![]() |
pakistanray | Word Tables | 2 | 10-31-2011 08:07 AM |
![]() |
Bartestokles | Word | 5 | 12-29-2010 01:42 PM |