It's probably easier to work with if you go down the road of formatting in Excel, however there's an 'excel'lent website by one Ron de Bruin that has lots of tips on various VBA routines, including emailing. Have a look here, an excellent read:
https://www.rondebruin.nl/win/section1.htm
In principle,- Create an Outlook object
- then create a new mail item
- Set the "string" to be used as HTML text; here from predefined text on the worksheet, or
- Define subject, recipient etc
- either send without user intervention, or display so user can cancel if necessary
You could get really fancy and set up dropdown boxes with text variants to suit different situations, but something like this could be a starting point for you to play with.
As ever, others will probably come up with better and more efficient ideas but see my sig!
Tim
Bookmarks