Find User Default Email Address in Outlook

Hi group

I am now using CDO to send a single sheet as an attachment and this all works. What I can’t do is insert the email address of the sender in the ‘.From = ‘ in Outlook 2000. Any suggestion please.

Andrew

See
http://vbnet.mvps.org/

Search for smtp

--
Regards Ron de Bruin
http://www.rondebruin.nl


"aph" <aph.202ptm_1134636901.5082@excelforum-nospam.com> wrote in message news:aph.202ptm_1134636901.5082@excelforum-nospam.com...
>
> Hi group
>
> I am now using CDO to send a single sheet as an attachment and this all
> works. What I can't do is insert the email address of the sender in the
> '.From = ' in Outlook 2000. Any suggestion please.
>
> Andrew
>
>
> --
> aph
> ------------------------------------------------------------------------
> aph's Profile: http://www.excelforum.com/member.php...o&userid=17175
> View this thread: http://www.excelforum.com/showthread...hreadid=493725
>

Ron, Hi

I did try this link but couldn't get either of the 2 samples to run. I am still a novice so can only get simple things to work.

Why is this infromation so dificult to obtain in CDO?

Andrew

Hi aph

Try one of the Outlook newsgroups for this then.
Maybe there is a easier way

--
Regards Ron de Bruin
http://www.rondebruin.nl


"aph" <aph.204hhb_1134719402.4058@excelforum-nospam.com> wrote in message news:aph.204hhb_1134719402.4058@excelforum-nospam.com...
>
> Ron, Hi
>
> I did try this link but couldn't get either of the 2 samples to run. I
> am still a novice so can only get simple things to work.
>
> Why is this infromation so dificult to obtain in CDO?
>
> Andrew
>
>
> --
> aph
> ------------------------------------------------------------------------
> aph's Profile: http://www.excelforum.com/member.php...o&userid=17175
> View this thread: http://www.excelforum.com/showthread...hreadid=493725
>

I have searched and searched but still can't find a way to add the email address of the Sender when using Outlook 2000 with the CDO method.

Any more suggestions please?

Andrew