Hi,

I am using Ron de Bruin's send mail code automatically send an email from
excel based on a trigger value.

Everytime I send out a mail, it is cc'd to myself, but rather than
hard-coding my email address, is there a pre-defining name that picks up the
default email address in outlook?

Thanks

Pinda.

Hi Bhupinder Rayat

There is code to get this information but it is not so easy.
Maybe you can use a cell in the workbook if you want with the address

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


"Bhupinder Rayat" wrote in message
...
Hi,

I am using Ron de Bruin's send mail code automatically send an email from
excel based on a trigger value.

Everytime I send out a mail, it is cc'd to myself, but rather than
hard-coding my email address, is there a pre-defining name that picks up the
default email address in outlook?

Thanks

Pinda.