Macro to insert signature

[Guest]

I am running a macro in Excel that prints and sends an email based on content
in my spreadsheet. The only problem I have now is finding out how to include
a signature in the email. I tried to familiarize myself with the
SignatureSet and Signatures objects in Outlook VBA, but haven't been able to
successfully insert a signature. Could somebody please reply with the
necessary code to include a signature on an outlook MailItem.

 

[Sue Mosher [MVP-Outlook]]

The Outlook object model has no objects for signatures. See http://www.outlookcode.com/codedetail.aspx?id=615 for sample code to insert a particular signature.

FYI, there is a newsgroup specifically for general Outlook programming issues "down the hall" at microsoft.public.outlook.program_vba or, via web interface, at http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.outlook.program_vba


--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers