TC-Fireman
Board Regular
- Joined
- Oct 14, 2009
- Messages
- 79
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
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