wb.SendMail

[happyhungarian]

Hi,

I am currently using the following code to auto send an email to specified recipients when the workbook user hits a macro button. Is there a way to set the code to also automatically send an email to the user itself without having to hardcode the users email address? Basically have it be dynamic?

wb.SendMail Array("recipient1@mail.com", "recipient2@mail.com", "recipient3@mail.com"), _
Range("s4") & Format(Date, "mm/dd/yyyy")

Regards,

Jesse

 

[BrianExcel]

http://www.rondebruin.nl/tips.htm