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

Hi,
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
regards
Trevor
On a side note how do i attache an image at the bottom of the email body?

See code below


Code:
            .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 trevor@here.com <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