Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Email: Address and portion of body in cell
I am using Ron De Brun's code for emailing a single sheet from workbook using Outlook. I want to have a cell that the macro will rea from and make that where the email is sent. I found this portion of the code on his website .SendMail Sheets("mysheet").Range("a1").Value, _ "This is the Subject line" Where would I add it, and would I have to delete a portion of this are of the code? With OutMail .To = "" .CC = "" etc etc. Also, I would like to have a cell that has an order number in it tha would be changeable from the excel sheet. I then want the order numbe to appear in the email in the subject or Body of the email. Fo example, " Your order number is "$A$1" or something of the like, but doubt it would be that simple -- pete358 ----------------------------------------------------------------------- pete3589's Profile: http://www.excelforum.com/member.php...fo&userid=2840 View this thread: http://www.excelforum.com/showthread.php?threadid=48429 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Email: Address and portion of body in cell
Hi
SendMail Sheets("mysheet").Range("a1").Value, _ "This is the Subject line" This is a tip if you use SendMail but you use the Outlook object model See http://www.rondebruin.nl/mail/tips2.htm You can do the same for the subject ..Subject = "Your order number is " & ThisWorkbook.Sheets("Sheet1").Range("A1").Value -- Regards Ron de Bruin http://www.rondebruin.nl "pete3589" wrote in message ... I am using Ron De Brun's code for emailing a single sheet from a workbook using Outlook. I want to have a cell that the macro will read from and make that where the email is sent. I found this portion of the code on his website SendMail Sheets("mysheet").Range("a1").Value, _ "This is the Subject line" Where would I add it, and would I have to delete a portion of this area of the code? With OutMail To = "" CC = "" etc etc. Also, I would like to have a cell that has an order number in it that would be changeable from the excel sheet. I then want the order number to appear in the email in the subject or Body of the email. For example, " Your order number is "$A$1" or something of the like, but I doubt it would be that simple. -- pete3589 ------------------------------------------------------------------------ pete3589's Profile: http://www.excelforum.com/member.php...o&userid=28402 View this thread: http://www.excelforum.com/showthread...hreadid=484294 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 body of email | Excel Discussion (Misc queries) | |||
Sort a column of email addresses by end portion of address | Excel Discussion (Misc queries) | |||
Email Range of Cell Content to create subject and body from link | Excel Programming | |||
body of email disappears when I send an email from Excel | Excel Discussion (Misc queries) | |||
Excel within the body of an email | Excel Programming |