Send automated email from spreadsheet

[azjfrankl]

I am trying to send a simple email from a spreadsheet. After looking at Mail from Excel and make/mail PDF files (Windows), I am still at a loss about where to start. I am new to this. The spreadsheets are arranged such that row A has an email address and row AM, Z, O, etc. has an outstanding balance. I would like to send emails with the text "You currently owe $X.XX for your purchases..." to each person in the spreadsheets with balances due.

Any help automating this would be very appreciated!

Thanks

 

[onlyadrafter]

Hello,

look in here:

Mail from Excel with Outlook (VBA)