Extract html from word document using vba script
Posted on 2013-02-05
I am developing a little email database in msaccess 2010. I want the users to be able to create their formatted message using word. The rich text formatted memo type is not powerful enough for the users who want to be able to insert tables etc.
I then want to get the text from the word document and place that into a memo field in my mail table that will form the html part of an email. I am using Ostrosoft SMTP Component to create the messages.
The little database that I have been using so far has worked OK, but the users are getting sick of not having the full formatting capability of Word.
I have inserted an OLE field and linked that field onto my email form. Now I just want to get the actual data out of that word document form.
Any suggestions / pointers would be gratefully received.