Word merge to outlook breaks clickable links

[Amy Beltaine]

I'm merging a link into word for sending out through
outlook. Because the link is a merge field, not something
typed in, word never gets a chance to format it as a
clickable link before the merged document is placed in
Outlook's outbox.

I can manually edit the resulting e-mails sitting in the
outbox (when my computer is off the network) so that I
trigger the format event that turns the URL into a
clickable link. But I don't want to click into each of
2000 e-mails and do this manually.

Can you think of a command in outlook (or vb?) that would
go through all the e-mails in outlook and trigger the
formatting event that turns URLs into links?

THANK YOU!
Amy Beltaine
Technology Learning Center
Cornell's School of Hotel Administration

 

[Sue Mosher [MVP]]

Office version? This was fixed in an Office XP service pack.
--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers

 

[Sue Mosher [MVP]]

Ah, it's a merged field. I missed that. You can do a fair amount of automation with Word's merge objects but not if you're using Outlook data directly as a source. One possible approach would be to include code to build the data source from Outlook as a table, then do a programmatic merge from that table. I don't know if it's possible to force an autoformat but perhaps someone in the Word mail merge newsgroup would know.

The newsgroup interface at Developersdex (http://www.developersdex.com) does not automatically quote the text of the original message when you post a reply. Please take the time to quote the original message manually so that people reading your current response can understand what you're talking about. Otherwise, you may not receive the answer you're looking for.

--
Sue Mosher, Outlook MVP
Outlook and Exchange solutions at http://www.slipstick.com
Author of
Microsoft Outlook Programming: Jumpstart
for Administrators, Power Users, and Developers