Thankyou Douglas
I am new to Access and was not aware of Hyperlink features, having followed
through on your suggestion i looked at the how i had designed the database
and i changed the field format to Text instead of Hyperlink. After a few
minor adjustments to the data entered into the field everything works fine.
(it is a new database so the changes were not so difficult.) i will study
Hyperlinks in more detail but thanks very much for your information. (Aust
for World Cup)
"Douglas J. Steele" wrote:
Looks as though you've set the email address up as a hyperlink field. Take a
look at the HyperlinkPart function for how to extract only that part of a
hyperlink field in which you're interested.
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)
"aussiebob" wrote in message
...
I have managed to use sendobject to email a report as an attachement and
populate the "email to" address however on the email to address shows
twice-
once as a normal email address and then as that email address enclosed in
the
hash signs.
#
Any help appreciated
.