 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / May 2004Hyperlinks with mailmerge
I'm using Access 2000 as the source for my Word mailmerge document. One of the fields in Access contains a hyperlink to a website. This hyperlink becomes text in Word. I'll really appreciate your help. Hi Erik, > I'm using Access 2000 as the source for my Word mailmerge > document. One of the fields in Access contains a hyperlink > to a website. This hyperlink becomes text in Word. there's really no reliable way to handle this. Word only accepts text via its link to a mail merge datasource; but no graphics, charts, hyperlinks, etc. The one thing you can TRY (but no guarantees) would be 1. Press Ctrl+F9 to insert a pair of field brackets 2. Type: Hyperlink 3. Insert the merge field that will bring across the text for the hyperlink 4. IMMEDIATELY execute the mail merge *to a new document* 5. In the merge result document: - Ctrl+A, F9 to force field updates - Alt+F9 to hide the field codes If you're very lucky, the hyperlink fields will hyperlink correctly to the URL that came across for each record during the merge, and the display text will be that URL. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003) 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 :-) Cind Your work around is great for creating a new merged document but is there any way to send the working URL in an email Cheer Elliott You need Word XP SP2  SignaturePlease post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP > Cindy > Your work around is great for creating a new merged document but is there any way to send the working URL in an email? > > Cheers > > Elliott |
Reply to this Message |
 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.