How to hyperlink URLs in a merged doc, with URL from Excel doc

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Frank - 09 May 2006 15:53 GMT

I am trying to do a mail merge in an email, pulling unique, generated URLs
from a spreadsheet. Once merged, however, the URL is hot hyperlinked.

I don't want to ask the respondent to "copy and paste."

How do I hyperlink the URL? It is hyperlinked in the original spreadsheet,
but not after it is merged into the email.

Reply to this Message

Doug Robbins - Word MVP - 09 May 2006 19:09 GMT

See the following page on fellow MVP Cindy Meister's website:

http://homepage.swissonline.ch/cindymeister/mergfaq2.htm#Hy

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I am trying to do a mail merge in an email, pulling unique, generated URLs
> from a spreadsheet. Once merged, however, the URL is hot hyperlinked.
[quoted text clipped - 3 lines]
> How do I hyperlink the URL? It is hyperlinked in the original spreadsheet,
> but not after it is merged into the email.

Reply to this Message

Frank - 09 May 2006 23:06 GMT

Actually, I couldn't get that to work as a solution for email, though it did
work for word documents.

Here's how I got email to work:

http://support.microsoft.com/default.aspx/kb/912679

> See the following page on fellow MVP Cindy Meister's website:
>
[quoted text clipped - 7 lines]
> > How do I hyperlink the URL? It is hyperlinked in the original spreadsheet,
> > but not after it is merged into the email.

Reply to this Message

Rate this thread: