View Single Post
  #2  
Old May 23rd, 2010, 03:29 PM posted to microsoft.public.access.reports
Douglas J. Steele[_3_]
external usenet poster
 
Posts: 3,143
Default email recipient address shows twice

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