Results 1 to 2 of 2

HTML formatting me.field in VBA email

  1. #1
    jjake88 is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2019
    Posts
    1

    HTML formatting me.field in VBA email

    Hello,



    I'm currently using the following code to send an email update

    Code:
    strSubject = "Work Order Update Alert, WO#" & [Forms]![frmWorkOrderUpdate]![WorkOrderID]strEmail = "<b>This is an automatic email notifying of a work order update</b>" & "<br>" _
                & "<br>" _
                & "WO#" & Me.WorkOrderID & "<br>" _
                & "Equipment ID: " & Me.txtEquipmentName & "<br>" _
                & "<br>" _
                & "<u>Scope of Work</U>" & "<br>" _
                & Me.WorkScope & "<br>" _
                & "<br>" _
                & Me.StatusUpdate1Date & "<br>" _
                & Me.StatusUpdate1 & "<br>" _
                & "<br>" _
                & Me.StatusUpdate2Date & "<br>" _
                & Me.StatusUpdate2 & "<br>" _
                & "<br>" _
                & Me.StatusUpdate3Date & "<br>" _
                & Me.StatusUpdate3 & "<br>"

    How would i underline a me.field in this code?

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    20,141
    Try

    Code:
                & "<u>Scope of Work</U>" & "<br><U>" _
                & Me.WorkScope & "</U><br>" _
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Send email as HTML template
    By fletcjas in forum Programming
    Replies: 5
    Last Post: 12-03-2018, 08:31 AM
  2. email body using html format
    By baronqueefington in forum Programming
    Replies: 5
    Last Post: 02-03-2015, 03:44 PM
  3. SendObject Email HTML Text
    By abodi in forum Programming
    Replies: 1
    Last Post: 09-10-2014, 12:03 AM
  4. Email HTML using Access
    By Ruegen in forum Access
    Replies: 2
    Last Post: 08-24-2014, 11:52 PM
  5. New line in html email form field
    By srk999 in forum Forms
    Replies: 3
    Last Post: 02-18-2014, 06:34 PM

Posting Permissions

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