By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,190 Members | 1,653 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,190 IT Pros & Developers. It's quick & easy.

Mail merge with a functional hyperlink

P: 11
I have a simple table named "Profile" that includes a field called [Web]. The field [Web] is set as a text data type. The records in the field are basic website addresess like http://www.raymondjames.com/boiseid. From this table I am using the Tools - Office Links - Merge IT with Microsoft Word to format an email message. In the Word document I add the merge fields of which [Web] is included.

When I view the merged data the [Web] field does not format as a hyperlink. I have tried going back to the Access table and setting the format there but when I view the merged data in Word it prints as #http://www.raymondjames.com/boiseid# and still does not display as a hyperlink.

How can I merge the data in that field into Word as a hyperlink so that the recipients will get a working hyperlink they can click on?

I know almost no VB. Thanks!
Sep 25 '07 #1
Share this Question
Share on Google+
1 Reply


nico5038
Expert 2.5K+
P: 3,072
Did you try to change the tablefield into a hyperlink datatype ?

Nic;o)
Oct 5 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.