Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-25-2013, 12:15 PM
instantaphex instantaphex is offline Mail Merge Many URLs in one email by common email address Mac OS X Mail Merge Many URLs in one email by common email address Office 2008 for Mac
Novice
Mail Merge Many URLs in one email by common email address
 
Join Date: Apr 2013
Posts: 2
instantaphex is on a distinguished road
Default 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
I would like to send a single email to owner@example.com with the following info:
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!
Reply With Quote
  #2  
Old 04-25-2013, 07:38 PM
macropod's Avatar
macropod macropod is online now Mail Merge Many URLs in one email by common email address Windows 7 64bit Mail Merge Many URLs in one email by common email address Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

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]
Reply With Quote
  #3  
Old 04-29-2013, 11:28 AM
instantaphex instantaphex is offline Mail Merge Many URLs in one email by common email address Mac OS X Mail Merge Many URLs in one email by common email address Office 2008 for Mac
Novice
Mail Merge Many URLs in one email by common email address
 
Join Date: Apr 2013
Posts: 2
instantaphex is on a distinguished road
Default

Quote:
Originally Posted by macropod View Post
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.
Thanks for the response. I've looked at your tutorial, however, I had non stop problems. I must say, I really dislike mail merge logic syntax. At this point I went ahead and created new spreadsheets with all of the cells combined by hand. I will mark this thread solved since this tutorial may very well help someone else.
Reply With Quote
  #4  
Old 04-29-2013, 05:46 PM
macropod's Avatar
macropod macropod is online now Mail Merge Many URLs in one email by common email address Windows 7 64bit Mail Merge Many URLs in one email by common email address Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
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

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]
Reply With Quote
Reply

Thread Tools
Display Modes


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
Mail Merge Many URLs in one email by common email address 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

Other Forums: Access Forums

All times are GMT -7. The time now is 06:40 AM.


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