I have MS Access Database clients database. When client places an order – I have developed VBA code to create an email confirming the details of the order.
Everything is coded, but the body text is concatenation of multiple notepad files and fields from the database.
I need to improve the code to be able to send html format email based on a template – it can be Word Template, or Outlook Template… something like Mail Merge in Word, but there will some details taken from the database to be populated on the email. Details like:
Clients name, address, order number, schedule date, type of order, estimated price, etc.