Can I control the spacing generated by <br> when generating emails from vba?

The following is email text generated from the vba code below. Using 2 <br> gives me the large space between paragraphs. Using 1 <br> gives too small of a space. Is there any way to get an equivalent of 1 1/2 <b> to create a spacing size in between these 2?

This is a follow-up email regarding the upcoming ... A paper copy of these documents is also being sent to you. This ...will be held at .... Attached, please find a copy of the ... for your review, and an electronic version ... A paper copy of these documents is also being sent to you.

The Letter identifies the materials that will be required .... Please take a moment to review ... ensure that these materials are available to the team.
The following information should be submitted to our office at least one week prior to the start ...is preferred.
• Balances for the ... (listed on the first page of the attached letter) as of th...
• A list of .. as of the test month cutoff date incl....

strBody = strBody & "This is a follow-up email regarding the upcoming ...  A paper copy of these documents is also being sent to you. " & _
"This ...will be held at .... Attached, please find a copy of the ... for your review, and an electronic version ... A paper copy of these " & _
"documents is also being sent to you." & "<br>" & "<br>" & _
"The Letter identifies the materials that will be required .... Please take a moment to review ... ensure that these materials are available to " & _
"the team." & "<br>" & _
"The following information should be submitted to our office at least one week prior to the start ...is preferred." & "<br>" & _
Chr(149) & "   Balances for the ... (listed on the first page of the attached letter) as of th..." & "<br>" & _
Chr(149) & "   A list of .. as of the test month cutoff date incl...."
newbie46Asked:
Who is Participating?
 
käµfm³d 👽Connect With a Mentor Commented:
It's up to each individual HTML renderer as to how they want to display a <br /> tag. You might try adding CSS to the tag. You'll just have to test it to see if it works or not.

For the CSS, you can try:

<br style="line-height: 1.5;" />

Open in new window

0
 
Nick67Connect With a Mentor Commented:
As noted, the fact that it is vba-generated isn't important.
It's html, and whatever is rendering that html is what is ruining your esthetic.

Given the plethora of mail programs, this may not be worth obsessing over.
How it will look has too many variables for you to control completely.
Either give up on html and send a document--which you can control--or give up on micro-managing format.
0
 
Jeffrey CoachmanConnect With a Mentor MIS LiasonCommented:
Yeah,

I'll do HTML if I need hyperlinks, ...etc

But for fonts, character/line spacing, ...etc, ...I don't bother...

<How it will look has too many variables for you to control completely.>
True.
Certain HTML syntax is now deprecated, different web browsers, different web browser versions, User Zoom levels, ...etc


Also, remember that there are still some email systems where users are told set the reader to "Plain Text".

Finally note that HTML in the message body will trigger most email scanning programs that the email is spam.
Thus either send it to the junk folder, or delete it outright...

Not worth the trouble IMHO...


JeffCoachman
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.