Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-31-2013, 02:03 AM
macropod's Avatar
macropod macropod is online now How to send several rows of data from one column to each recipient in one go Windows 7 32bit How to send several rows of data from one column to each recipient in one go 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

The merge to email process actually executes two mailmerges - a Catalogue/Directory one from whatever data source you're using and an 'normal' one from the macro-reworked table created by the first one. So, yes, it actually uses two mailmerge main documents. The reason for doing it this way is that it can be made to work with any data source Word can use for mailmerges. The Addins I referred to only word with Excel data sources. The approach I've taken is perhaps also easier to implement (once you get your head around it!!).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #2  
Old 05-31-2013, 02:28 AM
mikustykus mikustykus is offline How to send several rows of data from one column to each recipient in one go Windows XP How to send several rows of data from one column to each recipient in one go Office 2003
Novice
How to send several rows of data from one column to each recipient in one go
 
Join Date: May 2013
Posts: 7
mikustykus is on a distinguished road
Default

Ah, I get you. And I don't actually run the mailmerge for the first part, that is done as part of the macro?

And what about the use of tables in catalogue / directory? Is that essential for the first part to 'hold' the data for the email merge? I don't really need them otherwise as all I'm after is a short 'personalised' list at the end of each email (including the recipients name in the email would be nice, but 'Dear colleague' will do.)
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Using Outlook 2007 & Office 2013 - Send To Mail Recipient. Mattycee Outlook 0 04-07-2013 05:38 PM
Concatenated data in subsequent rows doorsgirl Excel 4 09-15-2011 10:37 PM
Word 2010 setting defaults for send to mail recipient yancyxc Word 0 06-28-2011 05:07 AM
"Send to" mail recipient forlino Mail Merge 0 03-17-2010 10:26 AM
Office 2003 cannot 'Send To' Recipient as Attachment (for Review works fine) chrisgatguis Outlook 0 08-07-2009 06:08 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:42 PM.


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