Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-19-2018, 09:58 PM
macropod's Avatar
macropod macropod is offline Merging multiple items to a table, Formatting Windows 7 64bit Merging multiple items to a table, Formatting Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default


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]
Reply With Quote
  #2  
Old 07-20-2018, 04:54 AM
orion23 orion23 is offline Merging multiple items to a table, Formatting Windows 10 Merging multiple items to a table, Formatting Office 2016
Novice
Merging multiple items to a table, Formatting
 
Join Date: Jul 2018
Posts: 5
orion23 is on a distinguished road
Default

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!
Reply With Quote
  #3  
Old 07-21-2018, 03:33 PM
orion23 orion23 is offline Merging multiple items to a table, Formatting Windows 10 Merging multiple items to a table, Formatting Office 2016
Novice
Merging multiple items to a table, Formatting
 
Join Date: Jul 2018
Posts: 5
orion23 is on a distinguished road
Default

I believe I finally understand the alignment part
(will confirm once back in the office)
Reply With Quote
  #4  
Old 07-21-2018, 11:41 PM
macropod's Avatar
macropod macropod is offline Merging multiple items to a table, Formatting Windows 7 64bit Merging multiple items to a table, Formatting Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by orion23 View Post
when I click on "Finish & Merge" "Edit individual documents"
That suggests you added it to something other than your mailmerge main document...
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging multiple items to a table, Formatting Pivot Table: Show Data For Multiple Items 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
Merging multiple items to a table, Formatting Copy table cell formatting across multiple cells / tables pakistanray Word Tables 2 10-31-2011 08:07 AM
Merging multiple items to a table, Formatting Merging multiple .txt's Bartestokles Word 5 12-29-2010 01:42 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:54 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft