Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel and Email
I am using this code to send emails from an excel workbook.
Is there a way to add the "From" information. 'Sub Mail_ActiveSheet_Body() Dim OutApp As Outlook.Application Dim OutMail As Outlook.MailItem Application.ScreenUpdating = False Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(olMailItem) With OutMail .To = "ABC.com" .CC = "EFG.com" .BCC = "" .Subject = Sheets("trading").Range("A9").Value .HTMLBody = SheetToHTML(ActiveSheet) .Send 'or use .Display Thank you in advance. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel and Email
Hi Carl
With CDO it is possible but not with Outlook as far as i know. See http://www.rondebruin.nl/cdo.htm -- Regards Ron de Bruin http://www.rondebruin.nl "carl" wrote in message ... I am using this code to send emails from an excel workbook. Is there a way to add the "From" information. 'Sub Mail_ActiveSheet_Body() Dim OutApp As Outlook.Application Dim OutMail As Outlook.MailItem Application.ScreenUpdating = False Set OutApp = CreateObject("Outlook.Application") Set OutMail = OutApp.CreateItem(olMailItem) With OutMail .To = "ABC.com" .CC = "EFG.com" .BCC = "" .Subject = Sheets("trading").Range("A9").Value .HTMLBody = SheetToHTML(ActiveSheet) .Send 'or use .Display Thank you in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel email address routing | Excel Discussion (Misc queries) | |||
sending email from excel not working | Excel Discussion (Misc queries) | |||
how to open email from opt on line to excel | New Users to Excel | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Problem opening excel files from email | Excel Discussion (Misc queries) |