Is it possible to populate a HTML document from an Excel sheet ?
Posted on 2014-01-13
I have an HTML document (index.html) which I use as a mailshot template. I create an email from the document as follows:
1. In Internet Explorer, Select All, Copy and Paste the web page into an Outlook message.
2. Change the name of the recipient (Dear xxxxx) in the body of the text.
3. Add the recipient's email address.
4. Send message
I now want to automate this process from my Mailshot Excel VBA application on the click of a button.
My question is, how can I create a form field or control in my HTML document (similar to a label control in a Word document) which I can populate from my Excel application ?