macros to email the recipients list on excel

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...

natedfarm, Sorry for the delayed in response.

Am I understanding correctly that you want the code to create 25-50 new email messages, allowing you to edit before you send them, then repeat the process 500-1000 times until all are created?

Yes you got that perfectly right.. after I open 25-50 new messages i can reply to all of them one by one.

What about the body of the message? Is that to be filled in?

No, i prefer to keep the body of the email as a signature saved on my outlook.

Thank you so much.

works perfectly...

Appreciate it much...