htmlbody in outlook email  vba access

Fordraiders
Fordraiders used Ask the Experts™
on
access 2010  vba
outlook 2010

I have an email generating in vba access:

I'm hacing trouble creating a seperate line for tables in the htmlbody

MAILBODY is a table
strhtml = "<HTML><Body><table border='1' width='50%'><tr><th>Sku</th><th>PRODUCT_DESCRIPTION</th><th>QTY</th>" & _
"<th>TARGET_PRICE</th><th>COMPETITOR_PRICE</th><th>TARGET_PRICE_PROFITABILITY</th><th>CURRENT_PRICE</th></tr>"


MAILBODY = "<tr><td>" & rst("SKU") & "</td><td>" & rst("PRODUCT_DESCRIPTION") & "</td><td>" & _
                  rst("QTY") & "</td><td>" & Format(rst("TARGET_PRICE"), "Currency") & "</td><td>" & Format(rst("COMPETITOR_PRICE"), "Currency") & _
                  "</td><td bgcolor=""red"">" & "Not Profitable" & "</td><td>" & Format(rst("CURRENT_PRICE"), "Currency") & "</td></tr>"


and

MAILBODY_NO  is a table
' Skus not being sent
strhtml_no = "<HTML><Body><table border='1' width='50%'><tr><th>Sku</th><th>PRODUCT_DESCRIPTION</th><th>QTY</th>" & _
"<th>TARGET_PRICE</th><th>COMPETITOR_PRICE</th></tr>"



MAILBODY_NO = "<tr><td>" & rst("SKU") & "</td><td>" & rst("PRODUCT_DESCRIPTION") & "</td><td>" & _
                  rst("QTY") & "</td><td>" & Format(rst("TARGET_PRICE"), "Currency") & "</td><td>" & Format(rst("COMPETITOR_PRICE"), "Currency") & "</td></tr>"




       .HTMLBody = mybody & MAILBODY & mybody_split & MAILBODY_NO & mybody3 & user_link_to_approve & user_link_to_reject & mybody2


Problem:
They are meshing together.
I tried doing this adding  <br> but did not work.

       .HTMLBody = mybody & MAILBODY & mybody_split & "<br>  & MAILBODY_NO & "<br>" &   mybody3 & user_link_to_approve & user_link_to_reject & mybody2

Thanks
fordraiders
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Figured it out..
              .HTMLBody = mybody & "<table>" & MAILBODY & "</table>" & "<br><br>"
              .HTMLBody = .HTMLBody & mybody_split & "<table>" & MAILBODY_NO & "</table>" & mybody3 & user_link_to_approve & user_link_to_reject & "<br>" & mybody2


fordraiders

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial