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/