• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 198
  • Last Modified:

Add Several Lines to Email body VB

Currently using:
                  .To = cell
                .Subject = "Mosaic Files for Testing"
                .Body = "Hi, see attached file."
 

How do I change the .Body so I can add more text over several lines?
And also put certain text in bold....
Say i want to write:.....

Hi, see attached file
XXXXXX [BOLD]

Please get back to me if you have any issues

Regards
Imran Siddiq [BOLD]
Public Health [BOLD]
Leicestershire
0
flickimp1717
Asked:
flickimp1717
  • 2
1 Solution
 
Ardhendu SarangiSr. Project ManagerCommented:
hi,

Instead of just Body use HTMLBody. See sample below:

- Ardhendu
.HTMLBody = vbCrLf & _ 
"Hi, see attached file <b>XXXXX& vbCrLf & "</b><p> Please get back to me if you have any issues " & b

Open in new window

0
 
flickimp1717Author Commented:
Could I be so rude to ask you to rewrtie ....for me?
-------------------------------------------------------------------
Hi, see attached file
XXXXXX [BOLD]

Please get back to me if you have any issues

Regards
Imran Siddiq [BOLD]
Public Health [BOLD]
Leicestershire
-------------------------------------------------------------------
Cheers
0
 
Chris BottomleyCommented:
Hello flickimp1717,

Try:

Regards,

chris_bottomley
.To = cell 
.Subject = "Mosaic Files for Testing" 
.Body = "Hi, see attached file." .HTMLBody = "Hi, see attached file <b> XXXXX" & _
    "</b><p>Please get back to me if you have any issues" & _
    "<br><b>Imran Siddiq</b>" & _
    "<br><b>Public Health</b>" & _
    "<br>Leicestershire" & _
    "<br>-------------------------------------------------------------------"

Open in new window

0
 
flickimp1717Author Commented:
Many thanks
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now