Email from Excel Headache

[TC-Fireman]

Hi guys

First off, Merry Christmas, Happy Holidays to everyone

I have searched Google flat, and also this forum, and I still cannot find a very basic solution to my problem.

If I have email addresses in the range from A1:A100, what is the easiest was to "One Click" either a Macro or hyperlink to open up a new email and populate all the email addresses in my range above, as recipients.

I may also have to insert this macro in "Sheet 3", but pull the information from A1:A100 in "Sheet One"

Please can anyone assist, I have looked everywhere, but I just find very confusing and long VBA code.

Any help would be hugely appreciated

Regards

TC

 

[TC-Fireman]

Hi again

Just a quick question

Based on the same request, is it possible for you to tweak this coding to open the outlook calendar instead of the email program

That way, instead of just sending an email, one can also open the calendar to make a reminder for oneself?