Microsoft Office Forums Mailmerge help needed - external links

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-11-2016, 04:30 PM
mrhk mrhk is offline Mailmerge help needed - external links Windows 10 Mailmerge help needed - external links Office 2013
Novice
Mailmerge help needed - external links
 
Join Date: Jul 2016
Posts: 2
mrhk is on a distinguished road
Default Mailmerge help needed - external links

Hi everyone. I'm using the mailmerge feature for the first time as I will need to invite 600 clients to complete an online survey. My company does not allow client contact details to be uploaded to the vendor's system, which would make life much easier.

What I need to include is a unique client name, unique URL for each client (display the link and/or hyperlink to text) and the corresponding sales person's email address in the CC field.

I have tested this quickly and found that i) it does not seem possible to include a CC field, ii) URLs merge and display properly, but are not clickable when received (is this more to do with my email client settings? a lot of people will probably just not bother to copy and paste the link).

Many thanks!
Reply With Quote
  #2  
Old 07-12-2016, 05:15 AM
gmayor's Avatar
gmayor gmayor is offline Mailmerge help needed - external links Windows 10 Mailmerge help needed - external links Office 2016
Expert
 
Join Date: Aug 2014
Posts: 2,802
gmayor is just really nicegmayor is just really nicegmayor is just really nicegmayor is just really nice
Default

Hyperlink fields for mail merge are a tad tricky, but see http://www.gmayor.com/hyperlink_merge_fields.htm
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 07-18-2016, 06:23 AM
macropod's Avatar
macropod macropod is offline Mailmerge help needed - external links Windows 7 64bit Mailmerge help needed - external links 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

Cross-posted at: http://www.mrexcel.com/forum/general...ique-urls.html
For the cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Mailmerge help needed - external links Merging Word docs / PDFs while keeping external links Daedalus Word 1 05-11-2015 07:37 AM
Mailmerge help needed - external links Crashing with external links jenlook Word 1 09-18-2014 12:58 AM
Help with external links using Web query/Add-in/VBA Macro tmaster81 Excel Programming 0 07-27-2014 11:24 PM
External/Embedded links to excel lucas Word 3 03-30-2012 01:47 PM
Mailmerge help needed - external links mailmerge from external software dnscs Mail Merge 1 10-22-2011 10:19 PM


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