Results 1 to 3 of 3

Adding bullet point to email body using VBA from excel

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-18-2014
    Location
    England
    MS-Off Ver
    365
    Posts
    137

    Adding bullet point to email body using VBA from excel

    HI, I have a send email macro that works fine I just want to know how to enter bullet points into the body of the email, I am guessing something to do with CHR149 but I am not sure on the syntax of how to use this? can anyone help? I would like Points A-C to be a bullet pointed list

    [Sub booking()

    Dim olApp As Outlook.Application
    Dim olEmail As Outlook.MailItem


    Set olApp = New Outlook.Application
    Set olEmail = olApp.CreateItem(olMailItem)


    With olEmail
    .BodyFormat = olFormatHTML
    .Display
    .HTMLBody = "Dear XXXXX," & " <br>" & " " & " <br>" & " Thank you for your email." & " <br>" & " " & " <br>" & " As requested, we have arranged the Service for XXXXX on XXXX XXXXX XXXX at XXXXX at XXXXXXX ." & " <br>" & " " & " <br>" & "Please arrive at least 10 minutes before the Service is due to start." & vbNewLine _
    & " <br>" & " " & " <br>" & "Please confirm:" & vbNewLine _
    & " <br>" & " " & " <br>" & "Chr(149)" & "Point A" & vbNewLine _
    & " <br>" & " " & " <br>" & "Point B" & vbNewLine _
    & " <br>" & " " & " <br>" & "Point C" & vbNewLine _
    & " <br>" & " " & " <br>" & "We request that all choices are confirmed two working days before the date of the Service." & vbNewLine _
    & " <br>" & " " & " <br>" & "If convenient, I will telephone on XXXXX to confirm these details with you. If you have any further queries in the meantime or in the future, you may contact myself or my colleagues at any time." & vbNewLine _ "<br>" & .HTMLBody
    .To = ""
    .CC = "[email protected] "
    .Subject = "Enter Subject text here"


    End With
    End Sub]
    Last edited by moneypennie21; 04-26-2022 at 06:19 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA to remove last bullet point (just a bullet point no text following it) in a text box
    By lynnsong986 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-30-2021, 11:23 PM
  2. [SOLVED] Macro to email -Part of body of email not displaying in body
    By Howardc1001 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-10-2020, 09:10 AM
  3. Word VBA_find string against bullet point
    By Maheshp in forum Word Formatting & General
    Replies: 4
    Last Post: 01-12-2018, 05:20 PM
  4. [SOLVED] Email format with bullet point along with table range and attachment
    By Rajkumar_h in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-20-2017, 03:07 PM
  5. Addig a timechart in excel
    By shadowknight in forum Excel General
    Replies: 2
    Last Post: 11-14-2015, 11:00 AM
  6. How to add bullet point in msgbox in vba code
    By sspreyer in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-05-2014, 04:07 PM
  7. Bullet point and sub bullet points with numbers
    By trumpetman in forum Word Formatting & General
    Replies: 3
    Last Post: 12-17-2012, 12:23 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1