Using Outlook from Excel

[BillCPA]

I have a subroutine in Excel that sends out e-mails in Outlook. Works
perfectly, except that it doesn't use my standard layout (style) nor does it
insert a signature. Can anyone help me get that to work?

 

[Michael Bauer [MVP - Outlook]]

Calling Getinspector on the MailItem inserts the sig.

--
Best regards
Michael Bauer - MVP Outlook
Manage and share your categories:
<http://www.vboffice.net/product.html?pub=6&lang=en>


Am Wed, 20 Jan 2010 15:56:01 -0800 schrieb BillCPA:

 

[Sue Mosher [MVP]]

Just make sure you don't overwrite it when you set the Body or HTMLBody
property

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54