Using Excel to send automated emails in Outlook

[billyheanue]

Hi all,

I've tried searching for how to do this online, and all I have seen is that sending automated emails to various email addresses, given a list of qualifying data to sort out which email address it is sent to - they all say they require MS access.

Can I set this up in Excel instead? Company broke and cant afford Access. Can't I have the same tables in Excel rather than access?

 

[DaveBlakeMAAT]

YouTube Wise Owl Tutorials, they have an excellent video on this subject that worked for me.

 

[billyheanue]

Thanks Dave!!

 

[DaveBlakeMAAT]

You are welcome, using that video I managed to get the basics working in about an hour. I then incorporated tips from some of their other videos to generate various log files and apply error trapping to skip over any records that fail logical tests by multiple IF statements to populate the log files.

Best of luck

Regards

Dave