Unable to send user-editable text to Outlook email body based on active cell.

I'm attempting to send an email template from Excel to Outlook based on the active cell on which the user is selected when clicking the Control button. I've been around and around Ron de Bruin's website testing different scenarios and none seem to fit what I'm looking for.

Let's say I have columns A, B, and C; each column has its own associated email template/text. No matter what row is active in those 3 columns, I want the associated email to be displayed in Outlook when clicking a single Control button. The kicker is that the VBA-ignorant user needs to be able to edit the email template. The closest I've come so far is to do a series of Active Cell and Offset commands to refer to a hidden column containing the email text that I've previously pasted. The problem is that the code is pretty messy (see below), the user needs to delete unnecessary carriage returns before sending the email, and worst of all - the text loses its formatting when sent to Outlook.

I'm thinking all these problems might be solved if I could send an embedded Word doc (Insert >Object) as the body of the email. Is this possible? Thanks!

Please Login or Register  to view this content.

workbook is now attached.

Much thanks for your work, Leith. Don't spend too much time on it!! I know someone out there has to have successfully completed something similar.

Leith,

It'd be nice to allow the user to change anything about it, but changing the actual email text is the most important thing to allow user to change. If we can get that far, that'd be awesome.

For those referencing this thread for future use, I've given up on the email text buried in the excel document and gone to outlook templates (.oft). It will be a little more work on the front end for the user but will keep all HTML formatting.