HTML in VBA - faster way?

**Ruegen** · 12-11-2013, 08:09 PM

I would like to place html in the body of each email

however I have to go through and make sure for every " that would be used in say style="" in html requires 2 " so that vba works

Then I have to keep joining & to bring in fields and so on so that it works

I am hoping there is a quicker way to do this so that I can have fields within my html and make that
e.g.
emMessage = "<html><body><table><p style=""color=red;"">Dear " & Person Name & "</p></table></body></html>"

It gets very confusing writing both VBA and html and there might be a better way?

**June7** · 12-11-2013, 08:44 PM

Try apostrophe. Maybe that will be easier to follow.

style='color=red;'>

**Ruegen** · 12-11-2013, 08:52 PM

Originally Posted by June7

Try apostrophe. Maybe that will be easier to follow.

style='color=red;'>

Thanks

I also found pasting the html into an editor and then doing a find replace to replace all " with "" also works

I simplified things a bit and it works better now.

HTML in VBA - faster way?

Thread Tools

HTML in VBA - faster way?

Similar Threads

Make my DB go faster

Improving a querry for faster result

Report Opens Faster on 2nd try

Faster code? Which one?

A Faster Search??

Posting Permissions