I am trying to create a macro that will automatically
send an excel file (as an atttachment) to an address on
sheet 1.
If I used FileSendToMailRecipent As Attachment, it
works great in setting up the open file to be e-mailed.
But, I have not come up with a way to get e-mail address
in the open workbook into the "To:" box/line. If I click
on the e-mail address in the open workbook it brings up a
dialog box that has the "To:" correct with the e-mail
address, but I have to manually enter the file name. Any
ideas are very much appreciated.

Hi RONBO

Try one of the examples on my site
http://www.rondebruin.nl/sendmail.htm

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


"RONBO" wrote in message ...
I am trying to create a macro that will automatically
send an excel file (as an atttachment) to an address on
sheet 1.
If I used FileSendToMailRecipent As Attachment, it
works great in setting up the open file to be e-mailed.
But, I have not come up with a way to get e-mail address
in the open workbook into the "To:" box/line. If I click
on the e-mail address in the open workbook it brings up a
dialog box that has the "To:" correct with the e-mail
address, but I have to manually enter the file name. Any
ideas are very much appreciated.