Formatting a path name in Access for Outlook

[TonyS1952]

I am sending an 'automatic' email to users that indicates that an important file has been loaded into a particular folder. These files can be very large so I wanted to wanted to insert a link to the file.

So I placed this 'code' in the body of the outlook message

strmessage = "file:\\datcora0s\ph_staging$\\Transformation Folder\Formatted data for export\aa01CORE.xls"
it appears as a link but as soon as it encounters a space in the path name it becomes normal text so is useless.

does anyone know how to format this string correctly so that it is surrounded by quotes and will take the entire path. I've tried chr(34) and "'" but it makes no difference.

Thanks

 

[Remou]

How about:

strMessage = """file:\\datcora0s\ph_staging$\Transformation Folder\Formatted data for export\aa01CORE.xls"""

 

[PHV]

Typed, untested:
strmessage = Replace("file:\\datcora0s\ph_staging$\\Transformation Folder\Formatted data for export\aa01CORE.xls", " ", "%20")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TonyS1952]

Merci PHV
that replace worked fine, excellent

Tony