Advertisement

07.23.2008 at 06:25AM PDT, ID: 23588370 | Points: 125
[x]
Attachment Details

How do i Switch signatures in Outlook 2007 using VBA

Asked by Bcook1950 in Outlook Groupware Software, Microsoft Access Database, Access Coding/Macros

Tags: Microsoft, Outlook 2007, vba

We use several different automatically generated email messages during the day to send quotations and material situation updates to clients.  MS Access drives Outlook in these cases.  Attached is the code for one of these. I would like to vary the signatures attached.  Does anyone know how?Start Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:

With olMailItem
        .Subject = strSubject '& Me.OrderNumber
        .To = strEmail
        .Body = strBodyText
        '.Attachments.Add strAttach
        .Importance = olImportanceHigh
        .FlagStatus = olFlagMarked
        '.FlagDueBy = Date + 2
        .Display
        '.Send
    End With
[+][-]07.23.2008 at 07:44AM PDT, ID: 22069834

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628