Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cells values included in personalized e-mails
Dear Friends,
I have spreadsheet where each row follows this pattern: Name, dollar amount, number_x, number_y, e-mail address. I have a variable that holds the exact number of names on this list: RngRow and can be used in a for/next cycle if needed. I would like some help creating a macro that would do the following: 1) "Grab" the Name, dollar amount and e-mail address found in row 1. These would be found in columns, A, B & E. 2) Open an e-mail in the default pop3 e-mail software of the user, using the e-mail address "grabbed" from the current row. 3) Place the Name and dollar amount in the following e-mail message: Dear (Name), This is a quick e-mail to let you know that you have been sent the amount of (amount). 4) Save the current e-mail (CTRL+S) so it can be viewed before manually sending. 5) Goto step 1 above repeating this process until all of the individuals on the list have a "personalized" e-mail created for them. Just for your information I use the Eudora Pro e-mail program and have never had a problem getting it to open when I click "Mailto" links. Thank you very much! Mike --- Message posted from http://www.ExcelForum.com/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Avoiding cells being included in a chart | Charts and Charting in Excel | |||
Cells not included in formulas | Excel Discussion (Misc queries) | |||
pivot table with selection values not included in the base data | Charts and Charting in Excel | |||
How to display the "values" included in a formula vs. the cells? | Excel Worksheet Functions | |||
How do I "turn off" cells so they are not included in autosum | Excel Worksheet Functions |