Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Signature Block in Automatic email sent from Word Macro

Status
Not open for further replies.

grannyM

Programmer
Nov 26, 2002
39
US
We use a word macro to send an automatic email to an internal email group. Does anyone know how to have the signature block set up by the user included in the email created by the macro? Here is the code we're using to create the email:

Code:
Dim olapp As Outlook.Application
Dim nspNamespace As Outlook.NameSpace
Dim objNewMail As Outlook.MailItem

Set olapp = New Outlook.Application
Set nspNamespace = olapp.GetNamespace("Mapi")
Set objNewMail = olapp.CreateItem(olMailItem)

    With objNewMail
        .Recipients.Add ("email address")
        .Subject = "email subject line"
        .Body = "body text"
        .Send
    End With

Thanks!
 
Did you ever get an answer to this? I need to do exactly the same thing, and it doesn't appear that Outlook will automatically use my default signature when I call it from Access.

Thanks,
Michael
 
No, Sorry, no one replied, so I ended up using variables and pulling the info into the body.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top