Excel VBA to open new outlook message with signature and preferred body text format

Hi,

I use an excellent VBA macro from Ron de Bruin to copy and paste a range of cells into the body of an outlook email. It works a breeze, and i'm very happy with it. However, the new mail window this macro opens has Time New Roman as the default font and i would like Calibri, size 11. This new mail woindow also doesnt have my new message signature, and im having to follow the steps in outlook to insert the signature every time i send the mail. Is there a way to tweaqk the code below so that:

1. Text format of the new mail message is Calibri, size 11.
2. The new mail widow contains my signature as it would if i opened a new mail widow from within Outlook



Currently, the excel range goes into the email and i manually change everything, but i have to send many of these mails a day so i was hoping it could have it programmed to my preferences to make life a little easier..!

Here is the macro I use. Appreciate any help! Thanks

-----

Please Login or Register  to view this content.

Hi, morayman,

you can have a look at Insert Outlook Signature in mail for checking the availability of the wanted signature. If you follow the shown sample you will be able to add a wanted signature into the mail.

Regarding the font: as the body is formatted as HTNL you would need to add a command that will change the font accordingly. Maybe try

Please Login or Register  to view this content.

where Signature is the variable set according to the link I provided before.

AFAIK you will not be able to assign the font-size as 11 as HTML doesn´t support that (might be outdated on that information but I only know of size to be accepted between 1 and 7 for small to large but not as being the same you might use in Office).

Ciao,
Holger

Hi, morayman,

you may try to repeat the first command regarding the font after the RangetoHTML.

Ciao,
Holger