Controlling MS Outlook via Excel & VBA

**Kim1974** · 08-26-2011, 02:46 PM

Hello forum

I'd like to control MS Outlook via Excel & VBA.

I've been asked to help an animal welfare association with a way to automate emails to their members.

When the membership of each member is about to run out they want an automated emailnotification to be sent to the specific member (each member may have different dates for their membership expiration date)

The list of members can be controlled via Excel and when members have paid it can be 'checked' in the excelsheet

Is this possible?

**jaslake** · 08-28-2011, 11:53 PM

Hi Kim1974

Yes it's possible. Please post a sample file that has the same structure as your actual file and I'll demonstrate the code.

**MarvinP** · 08-29-2011, 12:06 AM

Hi Kim,

Do any of these help?
http://www.codeforexcelandoutlook.co...il-from-excel/
http://www.rondebruin.nl/sendmail.htm
http://www.exceltip.com/st/Control_O...Excel/464.html
http://www.*****-clicks.com/excel/olAutomating.htm

**Kim1974** · 08-29-2011, 12:06 PM

Hello jaslake

Thank you for your response

I've attached a spreadsheets showing how the members list could look (i haven't got the actual members list yet)

MarvinP:
Thank you for your response too

I'll have a look at your links

**jaslake** · 08-29-2011, 02:27 PM

Hi Kim

This code is in the attached

Please Login or Register  to view this content.

It will send a rather simple message to any member whose expiration date is within 30 days or more than today's date. Play with it...if you need help let me know.