Hyperlink & #-sign

[MarkB]

I have created a Word merge doc to use an Access query as a data source. The merge works fine with one exception. Hyperlink fields on the DB come out with leading and trailing #-signs. Is there a way to stop the #-signs?

 

[John Nurick]

Hi Mark,

Try changing the query. Use calculated fields for the hyperlink fields,
e.g.
fXXX: HyperlinkPart([XXX], 2)
where XXX is the name of the field. The argument 2 causes
HyperlinkPart() to return the hyperlink address; if you want the
hyperlink as it's displayed, use 0 instead. See VBA Help for more
information on the HyperlinkPart() function.