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.

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

http://homepage.swissonline.ch/cindy...ergfaq2.htm#Hy

--
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

"Frank" wrote in message
news
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.

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



"Doug Robbins - Word MVP" wrote:

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

http://homepage.swissonline.ch/cindy...ergfaq2.htm#Hy

--
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

"Frank" wrote in message
news
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.