Xtreme Pivot Tables
February 19, 2016
Every month, I need to send out an Outlook email to 2000 students. I have the email addresses in an Excel workbook and would like to customize the text body each month to reflect the latest announcements. The email addresses will be somewhat dynamic, in that there will be adds/deletes to the student list. I have seen applications where Excel VBA code is used to send messages via Outlook but the instructions are confusing to me. Are there tutorials or big clues on how to get started on this?
Any help would be appreciated.
June 25, 2016
You can try looking here http://www.rondebruin.nl/win/s.....k/mail.htm
It contains lots of examples on MS Outlook.
November 8, 2013
You can also try the code and sample workbook from our website: https://www.myonlinetraininghub.com/vba-to-create-pdf-from-excel-worksheet-then-email-it-with-outlook
You can remove the PDF attachment part, and improve the message.
If you want more complex messages to be sent from excel, entire ranges can be sent. Let us know exactly what you need, we'll try to help you.
Most Users Ever Online: 57
Currently Online: Ali Bokhari
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas