Register
Log In
Unanswered
Home
New Member
Dashboards
Power Query
Power Pivot
Xtreme Pivot Tables
February 19, 2016
Offline
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
Dashboards
June 25, 2016
Offline
Hi Nadine
You can try looking here http://www.rondebruin.nl/win/s.....k/mail.htm
It contains lots of examples on MS Outlook.
Cheers
Sunny
November 8, 2013
Offline
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.
Cheers,
Catalin
Most Users Ever Online: 57
Currently Online: Ali Bokhari
1 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Ali raza
Susan Booze
Rita Hrez
David Innes
preeti bhulabhai
Charles Klasek
Patrick Isedu
Emma Hayward
Vamseedhar G
NA NA
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
