Results 1 to 2 of 2
  1. #1
    trevor40's Avatar
    trevor40 is offline Advanced db Manager
    Windows XP Access 2003
    Join Date
    Feb 2014
    Location
    Australia
    Posts
    402

    can you change the font for an email body sent with access as shown


    [code]

    myItem.To = mail_to_list
    myItem.Subject = "Incoming Logistics Movement C/N # - " & Me.Consignment_Note_Number
    myItem.Body = "Please find below, details for the incoming consignment." & vbCrLf & _
    "Including any attachments if available" & "." & vbCrLf & vbCrLf & _
    "This report is for Consignment # - " & Me.Consignment_Note_Number & "." & vbCrLf & vbCrLf & _
    "Received On - " & Me.Date_Received & "." & " From " & Me.Courier & "." & vbCrLf & _
    "Description - " & Me.Description_of_Goods & "." & vbCrLf & _
    "Number of Items - " & Me.Number_of_Items & "." & " Total Weight - " & Me.Weight & "." & vbCrLf & vbCrLf & vbCrLf & vbCrLf & vbCrLf & _
    "Addressed To - " & Me.addressed_to & "." & vbCrLf & _
    "P/O or Invoice # Reference - " & Me.po_ref & "." & vbCrLf & vbCrLf & _
    "Other Notes - " & Me.comments & "." & vbCrLf & vbCrLf & vbCrLf & vbCrLf & _
    "Thank you." & vbCrLf & _
    "Logistics Department."
    myItem.Display
    ' SendKeys "%{s}", True

  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    I am not aware of a way. You could format the body as HTML and use HTML tags within a VBA string to change the font within HTML format....maybe

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 03-25-2013, 11:01 PM
  2. Replies: 1
    Last Post: 02-25-2013, 03:16 PM
  3. Replies: 2
    Last Post: 09-18-2012, 11:52 AM
  4. Email report as body of email
    By chrish20202 in forum Programming
    Replies: 6
    Last Post: 01-15-2012, 07:23 PM
  5. FORMATTING Outlook Email in BODY of Access code
    By taimysho0 in forum Programming
    Replies: 7
    Last Post: 11-28-2011, 11:04 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums