I'm creating an email using VBA in Excel. I have a couple of questions that
I'm sure have very simple answers.

1. How do I format an ordered list <ol? I want it to be in Arial, not
Times New Roman, and I just can't make it work.
2. How do I control paragraph spacing? I want to set the before and after
space to zero because I keep getting funky extra space.

<ol style="font:arial;"
....
</ol

<p style="line-height: 100%"
....
</p

Tim.



"Corissa Bowman" <Corissa wrote in message
...
I'm creating an email using VBA in Excel. I have a couple of questions
that
I'm sure have very simple answers.

1. How do I format an ordered list <ol? I want it to be in Arial, not
Times New Roman, and I just can't make it work.
2. How do I control paragraph spacing? I want to set the before and
after
space to zero because I keep getting funky extra space.

I think that would work except the quotes in VB are a problem. Is there a
way to quote the quotes? Hasn't worked for me yet ...

"Tim Williams" wrote:

<ol style="font:arial;"
....
</ol

<p style="line-height: 100%"
....
</p

Tim.



"Corissa Bowman" <Corissa wrote in message
...
I'm creating an email using VBA in Excel. I have a couple of questions
that
I'm sure have very simple answers.

1. How do I format an ordered list <ol? I want it to be in Arial, not
Times New Roman, and I just can't make it work.
2. How do I control paragraph spacing? I want to set the before and
after
space to zero because I keep getting funky extra space.