[Peter Jamieson]

You were looking at the list of fields in the table design? Not just the
field properties in a form?

Just checking...

Peter Jamieson

"Andrew R" wrote in message
...
Thanks for your reply.

I have checked the Access database field properties for the e-mail address
and it is not marked as a hyperlink.
The e-mail address displays OK in Access, it is only when it is imported
into Word (or Excel) that the #http//address)# gets added after the
address.

Andrew R

"Peter Jamieson" wrote:

It sounds as if your e-mail address is stored in an Access hyperlink
field.
If so,
a. does it need to be? Can you change it to be a text field? Or add a
text
field that just contains the address?
b. you can always create a queryin Access to strip off everything after
the
"#"

Peter Jamieson

"Andrew R" Andrew wrote in message
...
I am trying to mailmerge a Word document with data from an Access
database.
All imports OK except e-mail (and web) addresses.
I get the actual e-mail address from the database but Word (and Excel)
also
adds on the email address within # marks with http:// prefixing it (ie
#a href="http://n...pany.co.uk/a#).
When it comes to send the merged document it will not send as Outlook
does
not recognise the e-mail address.
How do I remove the # marks and the address between them?