Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-04-2017, 01:43 PM
Kokiri Kokiri is offline Mail Merge: Converting Text to Table Windows 8 Mail Merge: Converting Text to Table Office 2016
Novice
Mail Merge: Converting Text to Table
 
Join Date: Apr 2017
Posts: 4
Kokiri is on a distinguished road
Default


Okay, so I have made some modifications to my process so that the macro runs after clicking "Edit individual Letters." Thanks for pointing that out!

In a Macro, how can I loop through the records on this document? I've looked at your "Sub Merge_To_Individual_Files()", but I can't even get that to work. Is that run from the "Edit Individual Letters" Document?
Reply With Quote
  #2  
Old 04-04-2017, 06:38 PM
macropod's Avatar
macropod macropod is offline Mail Merge: Converting Text to Table Windows 7 64bit Mail Merge: Converting Text to Table Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,343
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 Kokiri View Post
I've looked at the Microsoft Word Catalogue/Directory Mailmerge Tutorial already. I'm not sure that I can go that way, though, because I have two records that I am working out of then. My database only pulls out one at a time, although I can reference other records that have a parental relationship to the record I'm working out of, too. I would have to pull out the person records and then the award records, and then somehow match them back up, right?
The tutorial describes how you can group multiple records. Did you experiment with the included data file & field coding? Did you note how there are multiple records for most groups? Did you look at the link I posted re the use of DATABASE fields?

There should be no need for all your circumlocution. The only reason you'd need a macro for the merge is if you're merging to an actual table and you need to delete the intervening paragraphs afterwards.
Quote:
Originally Posted by Kokiri View Post
I've looked at your "Sub Merge_To_Individual_Files()", but I can't even get that to work. Is that run from the "Edit Individual Letters" Document?
That's not even related to the tutorial and won't work with the tutorial's processes.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
macro, mail merge, table



Similar Threads
Thread Thread Starter Forum Replies Last Post
Losing table alt text when converting to PDF purpledwarf Word 0 01-11-2017 03:23 PM
Mail Merge problem when converting to PDF roflzor Mail Merge 7 09-30-2013 06:50 AM
converting a word document to a data file for mail merge drsuis Mail Merge 4 02-21-2013 03:34 PM
Mail Merge: Converting Text to Table mail merge with table nadja Mail Merge 5 03-06-2012 05:41 PM
Mail Merge: Converting Text to Table Converting data-table into coding text niuri_cigarete Excel 2 12-10-2011 02:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:06 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