Sending to yourself using sendmail

[Guest]

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.

 

[Ron de Bruin]

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