Prev: Updating Form==>Query==>Report
Next: new crosstab option?
From: aussiebob on 23 May 2010 00:54
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.
bobwarden(a)bigpond.com.au#mailto:bobwarden(a)bigpond.com.au#
Any help appreciated
From: Douglas J. Steele on 23 May 2010 10:29
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" <aussiebob(a)discussions.microsoft.com> wrote in message
news:92B2524B-3234-4F5A-8C59-676661598EF4(a)microsoft.com...
>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.
> bobwarden(a)bigpond.com.au#mailto:bobwarden(a)bigpond.com.au#
> Any help appreciated


From: aussiebob on 24 May 2010 08:04
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" <aussiebob(a)discussions.microsoft.com> wrote in message
> news:92B2524B-3234-4F5A-8C59-676661598EF4(a)microsoft.com...
> >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.
> > bobwarden(a)bigpond.com.au#mailto:bobwarden(a)bigpond.com.au#
> > Any help appreciated
>
>
> .
>
 | 
Pages: 1
Prev: Updating Form==>Query==>Report
Next: new crosstab option?