View Single Post
 
Old 12-05-2018, 10:46 PM
trevorc trevorc is offline Windows 7 32bit Office 2013
Competent Performer
 
Join Date: Jan 2017
Posts: 173
trevorc will become famous soon enoughtrevorc will become famous soon enough
Default

Heres a little snippet from an Access DB i made 5 years ago. you can format lots using html. look iy up online it's a world of it's own.

Code:
        myItem.Subject = "Outgoing Consignment Notification for C/N # - " & Me.Consignment_Note_Number
        myItem.HTMLBody = "<b>" & "<font size=+2>" & "Outgoing Consignment Notification     C/N #    " & "</font>" & "<font color= FF0000 >" & "<font size=+3>" & Me.Consignment_Note_Number & "</font>" & "</font>" & "</b>" & "<br>" & "<br>" & _
                          "Delivery To - " & "<b>" & "<font size=+2>" & Me.Consignment_For & "</font>" & "</b>" & "<br>" & "Via - " & "<b>" & "<font size=+2>" & Me.Courier & "</font>" & "</b>" & _
                          "&nbsp" & " on " & "&nbsp" & "<b>" & "<font size=+2>" & Format(Me.Date_Dispatched, "dd mmm yyyy") & "</font>" & "</b>" & "<br>" & "<hr width= 500 align= left>" & _
                          "Consignment Type " & "<b>" & "<font size=+2>" & Forms![consignment note tracking Outgoing].Consignment_Type & "</font>" & "</b>" & _
                          " Description " & "<b>" & "<font size=+2>" & Me.Description_of_Goods & "</font>" & "</b>" & "<br>" & _
                          "Number of items Dispatched " & "<font size=+2>" & "<b>" & Me.Number_of_items_listed & "</b>" & "</font>" & _
                          "     Total Weight " & "<b>" & "<font size=+2>" & Me.Weight & "</font>" & "</b>" & " Kg." & "<br>" & "<br>" & _
                          "Attention to - " & "<b>" & "<font size=+2>" & Me.Attention_to & "</font>" & "</b>" & "<br>" & _
                          "P/O or Invoice # Reference - " & "<b>" & "<font size=+2>" & Me.po_or_invoive_reference & "</font>" & "</b>" & "<br>" & "<br>" & _
                          "Notes - " & "<b>" & "<font size=+2>" & Me.Notes & "</font>" & "</b>" & "<br>" & "<br>" & _
                          "Thank you." & "<br>" & "Logistics department. " & "<hr width= 500 align= left>" & _
                          "<img src='" & email_logo & "'>" & "<br>" & "<br>" & _
                          "<font color= " & logo_color & ">" & "Any views expressed in this Communication are those of the individual sender and do not necessarily reflect the views of  " & _
                          Me.Delivery_From & ". This e-mail is confidential and the copyright of " & Me.Delivery_From & _
                          ". If you are not the intended recipient of this communication please delete and destroy it immediately. " & _
                          "So far as is permitted by law " & Me.Delivery_From & " makes no guarantee regarding the integrity of this communication." & "</font>"
Reply With Quote