Microsoft Office Forums Activating Unique Links in Email Messages Using a Mail Merge

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-18-2016, 06:57 AM
User02182016 User02182016 is offline Activating Unique Links in Email Messages Using a Mail Merge Windows 7 64bit Activating Unique Links in Email Messages Using a Mail Merge Office 2013
Novice
Activating Unique Links in Email Messages Using a Mail Merge
 
Join Date: Feb 2016
Posts: 1
User02182016 is on a distinguished road
Default Activating Unique Links in Email Messages Using a Mail Merge

I'm wondering if there is a way to ensure merge field links are hyperlinks when sent via email using a mail merge?

I use Word, Excel and Outlook 2013 to conduct these mail merges. The troublesome part of my process is the unique link from my Excel file. Each of the 500+ people I need to email has their own unique link.

When I finish the merge and view the messages in Outlook the unique links are not hyperlinks. What I've had to do is turn off the 'Send immediately' setting in Outlook, and then manually activate each link (by putting my cursor after the link and clicking the space bar) in each email in my outbox before sending the emails out.

I've had some success with the Mail Merge Toolkit add-on in the past, but not recently. (https://www.mapilab.com/outlook/mail_merge/) Recipients of these emails often reply that they cannot click on their link. It is easy enough to activate their link in my reply, but that tells me there are likely hundreds of people that do not tell me they have that issue.

I've tried these steps, well 1-8... 1. Disregarding mergefield issues for the moment, insert a hyperlink into the document in the normal way, choosing whatever 'Click Here' text you want in the 'Text to display' box.
2. Select the inserted hyperlink and press Shift-F9 to expose its field code.
3. Replace everything in the field after 'HYPERLINK' with your mergefield.
4. Select the field and press F9 to update the display.

In Word 2007 & later, you can make the display text variable also, by following these additional steps:


5. Position the cursor anywhere within the display text.
6. Insert a mergefield pointing to whatever data field you want to use for the display text (this could even be the same field as used at step 3 above).
7. Delete all of the previous display text either side of your last-inserted mergefield (note that this field will likely have updated already).
8. Execute the merge.
9. After merging to a new document, use Ctrl-A, F9 to update all fields. Without this, the mergefield hover text won’t update to the correct targets.

But the first link is the link that is pulled into each email. I assume because I cannot do step 9? Thank you in advance for any guidance.
Reply With Quote
  #2  
Old 02-23-2016, 06:02 PM
macropod's Avatar
macropod macropod is offline Activating Unique Links in Email Messages Using a Mail Merge Windows 7 64bit Activating Unique Links in Email Messages Using a Mail Merge Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 19,525
macropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to beholdmacropod is a splendid one to behold
Default

The instructions to which you refer are for creating individual hyperlinks in mailmerge documents, not emails. As mailing direct to email doesn't use Word's hyperlink fields, that approach won't work.

I have no experience with the MapiLab Mail Merge Toolkit add-on, so I can't give any advice in that regard.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Office for Mac 2011 mail merge messages will not send from Outlook scorpionis Mail Merge 0 01-15-2014 12:34 PM
Activating Unique Links in Email Messages Using a Mail Merge Mail Merge URL - a unique question kitefrantic Mail Merge 1 12-31-2013 07:34 PM
Mail Merge Many URLs in one email by common email address instantaphex Mail Merge 3 04-29-2013 05:46 PM
Mail Merge to email, changing images on email layout ginelli Mail Merge 18 02-23-2013 09:47 AM
Activating Unique Links in Email Messages Using a Mail Merge mail merge stops midway and then generates messages with no recipient or subject VivaceTS Mail Merge 1 08-09-2012 05:31 PM


All times are GMT -7. The time now is 10:38 PM.


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