Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Email help
Hi
I am experimenting with Ron de Bruin's "Sending mail from Excel with CDO" and so far it has worked. With iMsg Set .Configuration = iConf .To = " .CC = "" .BCC = "" .From = """Andrew"" " .Subject = "Progress Report" .TextBody = strbody "The line below caused an error" .addattachment ThisWorkbook.Sheets(2) "The line below worked" '.addattachment "C:\Users\Andrew\Desktop\Email example that works.xls" .Send End With I would like to be able to email a worksheet from the current active workbook and I tried the line below ..addattachment ThisWorkbook.Sheets(2) but it gave a type mismatch error. Help on this greatly appreciated please. Andrew B |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using Macro how to create email link for the email addresses in aRange or Selection | Excel Worksheet Functions | |||
Prompt the start of an email...user fills in email address | Excel Programming | |||
Excel VBA macro to send email attachment from default email client | Excel Programming | |||
how do you email a portion of a worksheet (range) as an insert into the body of an email? | Excel Programming | |||
Transfer Email addresses from spreadsheet to email address book | Excel Discussion (Misc queries) |