creating HTML code for email

trevorc · #1 05-17-2021, 06:09 PM

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"

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Using VBA to find html img code, and insert images dynamically	noslenwerd	Word VBA	3	01-02-2020 02:14 PM
how to add voting buttons in email content html code	nikyc	Outlook	1	11-21-2019 11:50 PM
Macro Help Swapping HTML Code	pclark2	Word VBA	2	02-11-2019 03:25 PM
Search and replace/insert HTML code into Master File using tags	dave8555	Excel	2	02-23-2014 03:51 PM
Strange HTML code inside an e-mail	Joostdegrote	Outlook	0	09-13-2010 07:57 AM