Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
E-MAIL
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I do an e-mail mail merge using an Excel spreadsheet? | Excel Worksheet Functions | |||
E-Mail attachment to same e-mail address in Outlook | Excel Discussion (Misc queries) | |||
E-mail to every e-mail address in an Excel column? | Excel Discussion (Misc queries) | |||
Error: cannot load the mail service. Check your mail installation. | Excel Discussion (Misc queries) | |||
General mail failure when sending e-mail from Excel | Excel Discussion (Misc queries) |