Problme when running MailMerge - Please help!

[allen_jr]

Hello,

I am trying to run a mail merge that will insert the web address for each recipient... When I insert the fieldin Word, the address comes out as:
www.urlhere.com#http://www.urlhere.com#

when what I want is just:
www.urlhere.com


I'm guessing this has something to do with the fact that I have the "Website" field column set up in Access as a hyperlink field (because I also run reports from the same table that I export to html and I want the links to function at that time)


So what i am wondering, is there a way to "cheat" this, or maybe some code to put into word that won't make my url address repeat as shown?


Please please help, thanks!


allen

 

[HiTechCoach]

I would use the HyperlinkPart() to extract the part you need.


From the Access Help file:

When you use the HyperlinkPart method in a query, the part argument is required. For example, the following SQL statement uses the HyperlinkPart method to return information about data stored as a Hyperlink data type in the URL field of the Links table:

SELECT Links.URL, HyperlinkPart([URL],0)
    AS Display, HyperlinkPart([URL],1)
    AS Name, HyperlinkPart([URL],2)
    AS Addr, HyperlinkPart([URL],3)
    AS SubAddr, HyperlinkPart([URL],4)
    AS ScreenTip
    FROM Links