I have VBA programs in an Excel workbook which send an email using Outlook. The email contains 2 hyperlinks,
and some instructions, all of which are generated inside the VBA program (the links are variable and are constructed on the fly). I'd like to be able to highlight certain sections of the email using colour, emboldenining and underlining. At the moment this is only possible if I first place the email in draft. However, this is not possible
on a day to day basis because of the volume of emails (maybe 120 to 180 a day) Is there a way to do
this programmatically using some inbuilt feature of VB/VBA or maybe using ascii codes? All the senders and receivers of the emails have MS Word as their email editor (this is the only way to guarantee correct settings in outlook so that the links work when clicked.
and some instructions, all of which are generated inside the VBA program (the links are variable and are constructed on the fly). I'd like to be able to highlight certain sections of the email using colour, emboldenining and underlining. At the moment this is only possible if I first place the email in draft. However, this is not possible
on a day to day basis because of the volume of emails (maybe 120 to 180 a day) Is there a way to do
this programmatically using some inbuilt feature of VB/VBA or maybe using ascii codes? All the senders and receivers of the emails have MS Word as their email editor (this is the only way to guarantee correct settings in outlook so that the links work when clicked.
