I cannot view hyperlinks in mail merged document in Word

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Savio Fernandes - 08 Mar 2005 16:23 GMT

I have a data source created in Excel 2003. I am using Word 2003. I am trying
to do a mail merge. The data source in Excel has a field; as email, this
particular field has some websites name. When i complete the mail merge in
Word it appears as normal text.

Please help me on this.
Regards,
Savio Fernandes.

Reply to this Message

Cindy M -WordMVP- - 22 Mar 2005 22:00 GMT

Hi =?Utf-8?B?U2F2aW8gRmVybmFuZGVz?=,

> I have a data source created in Excel 2003. I am using Word 2003. I am trying
> to do a mail merge. The data source in Excel has a field; as email, this
> particular field has some websites name. When i complete the mail merge in
> Word it appears as normal text.

You'd need to insert the field into a Word HYPERLINK field, Word won't pick up
the actual Excel hyperlink, only the text. However, you may find you need to
merge to a new Word document, then split the result up and send it to email.
Merge to email has a nasty habit of losing hyperlinks; you'd just have to try
it.

In order to put the mergefield with the URL into a Hyperlink field in Word:

1. Create the main merge document with everything else, first

2. Ctrl+F9 to insert a pair of field brackets

3. Type: Hyperlink

4. Type a space, then press Ctrl+F9 again.

5. Type in the name of the field containing the URL

6. Execute the mail merge

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

Reply to this Message