Access to Word merged hypertext field problem

[Lu An De]

Hi all,

I've merged several fields from a few tables into a bookmarked word document
using an SQL select
statement in a bas module (the main gist of which I learned from the Desktop
Dev Handbook).

The populating of the bookmarks and tables with merged fields works
beautifully accept that the
email address values appear twice one after the other and the second
instance of the email address
is surrounded in hash symbols.

Any ideas on why?

Regards, Lu An De

 

[G. Vaught]

It may have to do with the @ symbol. It is also possible that you may need
to enclose the email address field in Word with quotes.

 

[Lu An De]

Thanks for the tips G.Vaught,

I'll see what I can do with it.

Cheers,

Lu An De