Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Word > Mail Merge

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 03-15-2011, 08:18 AM
samndi samndi is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Mar 2011
Posts: 4
samndi is on a distinguished road
Default Hyperlink in MailMerge

Good morning all,

I posted this question at Mr. Excel as well since I am getting the link from Excel.

I am creating a Template to use with mail merge and need to add a hyperlink to the template. Currently I get the link from Excel and add it to the Template, that works like a charm....what I have an issue with is that the link is very long and VERY ugly so I want to display something like 'Click Here' rather than the actual link.

How do I change the display text in my template? (the link for each email is different and there could be over 200 e-mails at a time).

Thanks in advance for your help.
Reply With Quote
  #2  
Old 03-15-2011, 03:27 PM
samndi samndi is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Mar 2011
Posts: 4
samndi is on a distinguished road
Default

Just curious, is there a way in the mailmerge to do something like this?

Code:
 
"< a href=""" My Big Link""">Click here< /a>"
Thanks again.

Sam
Reply With Quote
  #3  
Old 03-15-2011, 08:11 PM
macropod macropod is online now Windows 7 32bit Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 9,543
macropod is a jewel in the roughmacropod is a jewel in the roughmacropod is a jewel in the roughmacropod is a jewel in the rough
Default

Hi Sam,

What you could do is to insert a Hyperlink into the Word document in the normal way and set the display text to whatever you want. Having done that, select the Hyperlink and press Shift-F9 to expose the field code. It'll look something like:
{HYPERLINK "C:\\Users\\Sam\\Documents\\Sourcefile.doc"}
You can then delete the 'C:\\Users\\Sam\\Documents\\Sourcefile.doc' and replace it with your mergefield, thus:
{HYPERLINK "«H_Link_Path»"}
where 'H_Link_Path' is your mergefield's name.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #4  
Old 03-17-2011, 06:31 AM
samndi samndi is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Mar 2011
Posts: 4
samndi is on a distinguished road
Default

Thanks Paul. I'll give it try today and let you know. BTW - These forums are the BEST!
Reply With Quote
  #5  
Old 03-17-2011, 07:28 AM
samndi samndi is offline Windows 7 32bit Office 2007
Novice
 
Join Date: Mar 2011
Posts: 4
samndi is on a distinguished road
Default

PERFECT!!!! Thanks do much, this is going to make life much better for my admins
Reply With Quote
  #6  
Old 03-20-2011, 10:33 PM
macropod macropod is online now Windows 7 32bit Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 9,543
macropod is a jewel in the roughmacropod is a jewel in the roughmacropod is a jewel in the roughmacropod is a jewel in the rough
Default

Hi Sam,

You're welcome. Thanks for the feedback.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #7  
Old 04-29-2011, 07:47 AM
FunkyDuck FunkyDuck is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Apr 2011
Posts: 2
FunkyDuck is on a distinguished road
Default

I followed the above example and it works, but what if you have a unique URL for each recipient and you want to mask it with text such as CLICK HERE? I've been having issues with this and MS Support hasn't been helpful. I'm hoping you can be.
Reply With Quote
  #8  
Old 04-29-2011, 01:35 PM
macropod macropod is online now Windows 7 32bit Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 9,543
macropod is a jewel in the roughmacropod is a jewel in the roughmacropod is a jewel in the roughmacropod is a jewel in the rough
Default

That's what the example provides for - a common 'click here' prompt and a unique URL.

You cannot have a tailored 'click here' prompt for each recipient in a mailmerge hyperlink field. However, if you're happy to have the url itself as the tailored 'click here' prompt for each recipient, simply merge it as ordinary text and, when the mailmerge has executed, let Word apply autoformatting to the document.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #9  
Old 04-29-2011, 01:43 PM
FunkyDuck FunkyDuck is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Apr 2011
Posts: 2
FunkyDuck is on a distinguished road
Default

Thanks for the quick reply, but I can't have the URL itself be clickable as it's for a quote generator and is over 200 characters due to the amount of variables being passed through the system. The email will end up being over 1000 pixels wide. Not good.

I did finally get a hold of a Senior Engineer at MicroSoft and the version their workin on is going to have this functionality, but as of yet it's not available. Why must MS make things so difficult? Oie!

Anyway, thanks for the help.
Reply With Quote
  #10  
Old 04-29-2011, 03:40 PM
macropod macropod is online now Windows 7 32bit Office 2000
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 9,543
macropod is a jewel in the roughmacropod is a jewel in the roughmacropod is a jewel in the roughmacropod is a jewel in the rough
Default

Well, if you want the 'click here' instead of individual URLs, I've already described how to do that.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
  #11  
Old 12-14-2011, 08:24 AM
b8b b8b is offline Windows 7 64bit Office 2010 32bit
Novice
 
Join Date: Dec 2011
Posts: 1
b8b is on a distinguished road
Default

I'm trying to do this in Office 2010 and hitting SHift-F9 does nothing for me. I also can't see it if I toggle field codes (doing a mail merge), though I am not sure if this is related. What am I missing?

TIA.
Reply With Quote
  #12  
Old 12-14-2011, 12:59 PM
macropod macropod is online now Windows 7 64bit Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 9,543
macropod is a jewel in the roughmacropod is a jewel in the roughmacropod is a jewel in the roughmacropod is a jewel in the rough
Default

Quote:
Originally Posted by b8b View Post
I'm trying to do this in Office 2010 and hitting SHift-F9 does nothing for me. I also can't see it if I toggle field codes (doing a mail merge), though I am not sure if this is related. What am I missing?
It's really hard to answer that without knowing rather more than what you've said so far. Perhaps you could descibe the process you've gone through to create the hyperlink.
__________________
Cheers,
Paul Edstein
[MS MVP - Word]
Reply With Quote
Reply
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with mailmerge??? foxtrot1981 Mail Merge 0 12-03-2010 07:21 AM
Mailmerge heading problem PALouise Outlook 0 11-07-2010 09:05 AM
MailMerge Labels Question trims30 Mail Merge 0 08-04-2010 05:21 PM
MailMerge fax not e-mail? JDCarb Mail Merge 3 04-02-2010 04:10 PM
Mailmerge Formula mridley Mail Merge 0 07-27-2006 03:16 AM


All times are GMT -7. The time now is 03:41 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft