Thread: [Solved] creating HTML code for email
View Single Post
Old 05-17-2021, 06:09 PM
trevorc trevorc is offline Windows 7 32bit Office 2013
Competent Performer
Join Date: Jan 2017
Posts: 157
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default creating HTML code for email

Hi all,
I am trying to create some HTML code that does the following in the body of the email

Name of person

Here is your invoice # 123456 PAID more text and end of email

The code below does this but won't let me put the mixed color,size,bold on the same line as normal text, it does do all the other things i need it to do.

Any help would be appreciated
the email is automated to attached 2 files and then display it
On a side note how do i attache an image at the bottom of the email body?

See code below

            .HTMLBody = .HTMLBody & "Hi " & Intersect(acrow, tblColumns("Contact Name").Range) & ", <br/> Please find attached a copy of your invoice and a copy of the online banking receipt,<br>for the repair of your Unit RMA Number - " & Intersect(acrow, tblColumns("RMA Number").Range) & " <span style=""color:#FF0000""><p style='font-family:calibri;font-size:20'><b>(PAID with provided credit card details)</b></p></span style=""color:#FF0000"">"
            .HTMLBody = .HTMLBody & "<br/>Dispatched on " & Date & " via Post<br/><br/>Regards,<br/>Trevor<br/>Workshop Manager<br/>Mobile 0404 123 456  <br/>E-mail <br/> company Pty Ltd<br/>Any views expressed in this Communication are those of the individual sender and do not necessarily reflect the views of"
Reply With Quote