Link to home
Start Free TrialLog in
Avatar of uad
uadFlag for United States of America

asked on

Table not in designated font

I am using Excel VBA to generate a mass email distribution.  Everything is working fine with both the basic email and distribution except for a table inserted into the email.  Despite setting the font to Arial the table is placed in the email in Times Roman.

I am trying to have the table, like the email, be in Arial.  Attached is the extract of the VBA specific to the table.
Sub-TableBody.docx
ASKER CERTIFIED SOLUTION
Avatar of Norie
Norie

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of uad

ASKER

OK - it worked - but can you explain the "style" information used.  I guess I'm thrown off by the use of  "san-serif"
Avatar of Norie
Norie

Ignore that, it's part of the font name but isn't really needed and I meant to remove it before posting.

By the way, the concatenation operator in VBA is & not +.

Using + shouldn't cause any problems though, unless you were dealing with numeric data.
Avatar of uad

ASKER

Thank you