Create Hyperlink by query

I

ian s

I am trying to create a hyperlink within a query by
concatenating the text part(fixed) and the file name
(variable) part as below

File: "file://G:\Scanned Invoices\" & [HIGH_REF] & ".pdf"
High_Ref is the field where the file name is held

I am then using Word mail merge to create a different
email message for each file on record.
Problem is that the email interprets only the part of the
text up to the space between Scanned and Invoices as the
Hyperlink and the rest as text.

Is there a way around this.

Thanks in advance for any help

ian
 
Top