#1
|
|||
|
|||
Mail Merge Many URLs in one email by common email address
I have a spreadsheet of many URLs in one column and a list of email addresses in an adjacent column. I've been googling and reading tutorials and I haven't been able to figure out what it is that I'm trying to do.
What I would like to do is mail merge to my inbox a single email per email address which contains all of the URLs associated with the email address. For example, consider the following spreadsheet: Code:
URL email http://www.example.com/1 owner@example.com http://www.example.com/2 owner@example.com http://www.example.com/3 owner@example.com http://www.otherexample.com/1 owner@otherexample.com http://www.otherexample.com/2 owner@otherexample.com http://www.example.com/1 http://www.example.com/2 http://www.example.com/3 as well as an email to owner@otherexample.com with the following: http://www.otherexample.com/1 http://www.otherexample.com/2 I'm having the hardest time understanding the syntax of mail merge logic statements. Can anyone help me out with this? Thanks! |
#2
|
||||
|
||||
You can't do this with Word's standard mailmerge tools. However, you can do so using the approach detailed in my Microsoft Word Catalogue/Directory Mailmerge Tutorial, available at:
http://windowssecrets.com/forums/sho...ngs-(2000-2010) or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip The tutorial covers everything from list creation to the insertion & calculation of values in multi-record tables in letters. Do read the tutorial before trying to use the mailmerge document included with it.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
Quote:
|
#4
|
||||
|
||||
As mentioned in the tutorial, it is sometimes easier to do the data manipulation at the source. For a recent macro implementation of this in Excel, similar to what you appear to have done by hand, see: http://windowssecrets.com/forums/sho...l=1#post902661
The biggest issue you're going to have using Office 2008 for any of these approaches is that it has no macro support.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mail Merge won't email | QEDDave | Mail Merge | 11 | 10-29-2014 09:44 PM |
Mail Merge to email, changing images on email layout | ginelli | Mail Merge | 18 | 02-23-2013 09:47 AM |
Outlook won't reply/forward email from one email address | rluna68 | Outlook | 2 | 01-07-2013 12:42 PM |
Convert mail merge to PDF then email | TeriJean | Mail Merge | 0 | 10-04-2011 03:52 PM |
Mail Merge via Proxy Email? | ghillie30 | Mail Merge | 0 | 07-08-2011 06:26 AM |