Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
setting address in "mail as attachment" macro
I'm trying to write a simple macro that will email a completed Excel-based
form to a designated email address. The macro as it sits so far - Sub MailFile() ' ' MailFile Macro ' Application.Dialogs(xlDialogSendMail).Show End Sub opens the mail form with the file attached just fine, but does not input the designated email address. Can someone help me fill in the blank, as it were. Thanks! Alan D. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel hangs after using "Send to mail recipient (as attachment) " | Excel Discussion (Misc queries) | |||
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),QuoteNotes, | Excel Worksheet Functions | |||
=HYPERLINK("#"&CELL("address", ADDRESS(MATCH(VALUE(B3),Range ... ? | Excel Worksheet Functions | |||
Default format for "mail recipient as attachment" emails | Excel Discussion (Misc queries) | |||
Excel: "De-activating" an e-mail address cell? | Excel Discussion (Misc queries) |