Hi -
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.
Nadine
Hi Nadine
You can try looking here http://www.rondebruin.nl/win/s1/outlook/mail.htm
It contains lots of examples on MS Outlook.
Cheers
Sunny
You can also try the code and sample workbook from our website: https://www.myonlinetraininghub.com/error-creating-relationship-in-vba-userform-code-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.
Cheers,
Catalin
