Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
email spreadsheet with text in subject & body to multple recipient
Hi
I hope that someone can help me. I want to use a macro to send a form (using Outlook 2007) created in Excel 2007 (which has the save/save as function disabled and is read only) once a user has completed it. I would like:- The email subject line to include text and also to pick up information within a cell in the spreadsheet. The email body to include text and also to pick up information in cells from within the spreadsheet. The message with the form attached to be sent to an unchanging e-mail address together with two other email addresses that are picked up from cells within the form. Also to CC another user with the email address picked up from a cell within the form. I do not want to use a routing slip as this automatically inserts text into the message which will confuse some of my users(!). I hope that this makes sense. iansmigger |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
email spreadsheet with text in subject & body to multplerecipient
On Nov 3, 5:03*am, iansmigger
wrote: Hi I hope that someone can help me. I want to use a macro to send a form (using Outlook 2007) created in Excel 2007 (which has the save/save as function disabled and is read only) once a user has completed it. I would like:- The email subject line to include text and also to pick up information within a cell in the spreadsheet. The email body to include text and also to pick up information in cells from within the spreadsheet. The message with the form attached to be sent to an unchanging e-mail address together with two other email addresses that are picked up from cells within the form. Also to CC another user with the email address picked up from a cell within the form. I do not want to use a routing slip as this automatically inserts text into the message which will confuse some of my users(!). I hope that this makes sense. iansmigger Hi, Start by searching Ron DeBruin on Google Ron has extensive code samples posted on how to send email from Excel Post your code back and we can tweak to pick up specific cell values Regards, goss |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
email spreadsheet with text in subject & body to multple recip
Excellent, I have managed to get it working as I wanted.
Thanks iansmigger "-goss" wrote: On Nov 3, 5:03 am, iansmigger wrote: Hi I hope that someone can help me. I want to use a macro to send a form (using Outlook 2007) created in Excel 2007 (which has the save/save as function disabled and is read only) once a user has completed it. I would like:- The email subject line to include text and also to pick up information within a cell in the spreadsheet. The email body to include text and also to pick up information in cells from within the spreadsheet. The message with the form attached to be sent to an unchanging e-mail address together with two other email addresses that are picked up from cells within the form. Also to CC another user with the email address picked up from a cell within the form. I do not want to use a routing slip as this automatically inserts text into the message which will confuse some of my users(!). I hope that this makes sense. iansmigger Hi, Start by searching Ron DeBruin on Google Ron has extensive code samples posted on how to send email from Excel Post your code back and we can tweak to pick up specific cell values Regards, goss |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
email excel spreadsheet as body of message, not as attachment | Excel Discussion (Misc queries) | |||
Create an e-mail with recipient, subject and text | Excel Programming | |||
Email Range of Cell Content to create subject and body from link | Excel Programming | |||
Excel 2003 / Send To / Mail Recipient / body text is removed | Excel Discussion (Misc queries) | |||
Macro to email excel workbook with static recipient and auto subject | Excel Programming |