VBA Code to enter bullet points into VBA Outlook Message

Hi,

I have a code that sends a message to outlook recipients, in this code it contains what I want the message to say, i.e.

Msg = Msg & Cells(20,2) & "Please ensure you pay for the event before Friday."

But what I want to include in the message is a bullet point, so that the message looks like this:

• (Name) Please ensure you pay for the event before Friday
• (Name) Please ensure you pay for the event before Friday
• (Name) Please ensure you pay for the event before Friday
• (Name) Please ensure you pay for the event before Friday

As far as I know you cannot enter a bullet point into the VBA code. So is there a bit of code that enters it? Similar to & vbCrLf for 'Enter' or 'Return'

Thanks,

Archie

bump to get reply

I know this is an old thread, but if you are still looking for answer use Chr(149) in your code.

Please Login or Register  to view this content.

This actually really helps/was something I was looking for.

Thanks!