Guys I have an excel sheet with 25,000+ emails in column A with hyperlinked emails addresses,
Column B has different Subject lines based on the category the clients belongs to but on the same sheet,
Column C has the following hyperlink =HYPERLINK("mailto:"&A2&"?subject="&B2,"Email") to create a hyperlink of the email address with the desired subject line.


Can anybody help me out with macros that i could use to open about 25/50 outlook message with the email ids in column A of the sheet and the subject lines in column B.

I don't want the messages to be sent automatically but i want to have the option to change the body of the email if necessary.

Please help...