Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 12-05-2018, 10:46 PM
trevorc trevorc is offline A little color please Windows 7 32bit A little color please 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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
A little color please VBA change font color to background color donaldadams1951 Word VBA 6 05-31-2018 04:36 PM
Macro to change an RGB table cell shading color to another RGB color David Matthews Word VBA 4 05-29-2018 02:45 PM
Advanced Font Color Manipulation In Word: Inserting another color than the surrounding text stuartg Word 1 02-20-2017 12:38 AM
A little color please Remove white text background (keeping the font color and page color intact cc3125 Word 1 10-26-2015 06:44 PM
A little color please I created a custom XML color scheme. How do I add that to the Built-in Color? Cassik PowerPoint 5 11-04-2013 02:08 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:50 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft