Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / May 2007

Tip: Looking for answers? Try searching our database.

Email Merge: sends documents, but eliminates all hyperlinks!

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Nadine - 17 May 2007 04:01 GMT
Okay, after struggling to get mail-merge working at all, finally got it to
work, but when I send an email merge, it converts all the hyperlinks to just
formatted text.

In other words, the Text to Display for each link is there, but the
hyperlink is gone. I'm using Office XP (Word & Outlook 2002, SP3).  

If I go to File>Send>Mail Recipient, then it sends the email and the links
are still in the email, it only eliminates hyperlinks when I do a mail merge.

I have 3 types of hyperlinks in the document: Web Page links, email links,
and links to different parts of the page.

The document is saved both as a word document and as an HTML page, I have
this mail-merge issue with both files.
Signature

Thanks for any help & advice you can give me!

Nadine

Peter Jamieson - 17 May 2007 08:58 GMT
There are certainly problems in this area. I would start with

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

I would also experiment with unchecking

Microsoft Office Button|Word Options|Advanced|Web Options...Files"Update
links on save"

although I have no evidence to suggest that will make a difference in this
case.

However, what happens may well depend on whether your hyperlink is inserted
dynamically or is a "static" link.

Peter Jamieson

> Okay, after struggling to get mail-merge working at all, finally got it to
> work, but when I send an email merge, it converts all the hyperlinks to
[quoted text clipped - 13 lines]
> The document is saved both as a word document and as an HTML page, I have
> this mail-merge issue with both files.
Nadine - 17 May 2007 10:28 GMT
Thank you for your response, but I'm not sure how to use it. The article
seems to imply that the hyperlinks are merge fields, but they're not. What
I'm trying to do is create a template that has all my contact info and links
to my web sites in it, then send it as a mail-merge to my subscribers. So the
hyperlinks are created in the Word Document, then the only thing I'm merging
is the Subscribers Name from my Contacts in Outlook.

I could try doing this, but then what data source do I use, and then
wouldn't I have to do two merges, one for the hyperlinks and one for the
email merge? I'm not real clear on what the article is trying to tell me to
do...

2 - What is dynamic and static links? I put the hyperlinks in my document
using File Menu>Insert>Hyperlink.

Hope you can help some more!

> There are certainly problems in this area. I would start with
>
[quoted text clipped - 30 lines]
> > The document is saved both as a word document and as an HTML page, I have
> > this mail-merge issue with both files.
Peter Jamieson - 17 May 2007 10:45 GMT
> 2 - What is dynamic and static links? I put the hyperlinks in my document
> using File Menu>Insert>Hyperlink.

That's what I meant by "static" links, i.e. the ones that the article does
/not/ talk about.

However, there's an another article at

http://support.microsoft.com/kb/287004/en-us

that discusses mmerge to email with Word XP which /might/ shed some light on
this. What it says is that
a. when you merge a "web page" to email, the hyperlinks disappear (as you
describe)
b. to work around, you have to save as a single-page microsoft .mht format
"web page" and merge it as an attachment
c. the "problem" (and I have to assume the specific one they describe)  is
fixed in Word XP SP3

There is also an article at

http://support.microsoft.com/kb/813673/en-us

which might have to be applied as well.

So what I'm wondering is whether trhe merge would actually work if you saved
your mail merge main document as a web page (i.e. .htm, not .mht) rather
than a .doc, then do the merge as normal. (The article also assumes you are
trying to merge using HTML format). The thing is that none of the stuff that
Word can do in .doc format, such as headers and footers, will get through an
e-mail merge anyway, so you probably would not lose by saving as .htm first.

I can't check this right now, but if that doesn't work, my only other
suggestion is that if merging using the technique described in the article I
previously mentioned actually works, then perhaps it is worth trying to
create your static links as if they wer dynamic links, e.g., instead of
their example

{ HYPERLINK { MERGEFIELD "Address1" } \*Mergeformat }

you could try

{ HYPERLINK { QUOTE "your hyperlink text" } \*Mergeformat }

or maybe

{ SET myhl "your hyperlink text" }{ HYPERLINK { REF mylt } \*Mergeformat }

If any of the above do work, please post back.

Peter Jamieson

> Thank you for your response, but I'm not sure how to use it. The article
> seems to imply that the hyperlinks are merge fields, but they're not. What
[quoted text clipped - 57 lines]
>> > have
>> > this mail-merge issue with both files.
Peter Jamieson - 17 May 2007 11:17 GMT
> The thing is that none of the stuff that Word can do in .doc format, such
> as headers and footers, will get through an e-mail merge anyway

Unless, of course, you merge to an attachment.

>> 2 - What is dynamic and static links? I put the hyperlinks in my document
>> using File Menu>Insert>Hyperlink.
[quoted text clipped - 112 lines]
>>> > have
>>> > this mail-merge issue with both files.
Nadine - 23 May 2007 10:41 GMT
Actually didn't have to do anything else but update. Now I can email-merge
from the .doc file, and all the 3 different kinds of hyperlinks in my letter
still go through. The http://support.microsoft.com/kb/813673 was the answer
to the problem I was having.
Signature

Thanks again!

Nadine

> > The thing is that none of the stuff that Word can do in .doc format, such
> > as headers and footers, will get through an e-mail merge anyway
[quoted text clipped - 117 lines]
> >>> > have
> >>> > this mail-merge issue with both files.
Peter Jamieson - 23 May 2007 12:29 GMT
Thanks, useful feedback.

Peter Jamieson
> Actually didn't have to do anything else but update. Now I can email-merge
> from the .doc file, and all the 3 different kinds of hyperlinks in my
[quoted text clipped - 148 lines]
>> >>> > have
>> >>> > this mail-merge issue with both files.
Nadine - 23 May 2007 10:28 GMT
Thanks for all the advice. Sorry it took me so long to get back to you. I was
on a business trip, and didn't have time to try any of this stuff until
yesterday. I thought that I had the latest Updates, because in
Word>Help>About Word it said version/SP3, but when I clicked on find updates
that was there. So after updating pretty much all day, my mail merge finally
works like it should! Yay!!!! Hyperlinks included ;-)
Signature

Thanks for your help!
Nadine

> > 2 - What is dynamic and static links? I put the hyperlinks in my document
> > using File Menu>Insert>Hyperlink.
[quoted text clipped - 109 lines]
> >> > have
> >> > this mail-merge issue with both files.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.