Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
email as attachment in code
Hi, all!
I have a program that inserts data into excel worksheet. Now I want to email it. I need your help to find the code equivalent of manually select menu File/SendTo/Mail Recipient(As Attachment), then type in a recipient address and send. I have this line of code: Call ", "ACD", "") I got runtime error 1004. Method 'SendMail' of object '_workbook' failed. I am not sure I am using the right object. I have app, workbook and worksheet, and I used workbook to save it. Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sending a Spreadsheet as an Email Attachment vs. Imbedded in Email | Excel Discussion (Misc queries) | |||
Email Attachment | Excel Discussion (Misc queries) | |||
send wkbk as an email attachment with an email address copied from | Excel Discussion (Misc queries) | |||
email as attachment | Excel Discussion (Misc queries) | |||
email as attachment | New Users to Excel |