Jump to content


 


Register a free account to unlock additional features at BleepingComputer.com
Welcome to BleepingComputer, a free community where people like yourself come together to discuss and learn how to use their computers. Using the site is easy and fun. As a guest, you can browse and view the various discussions in the forums, but can not create a new topic or reply to an existing one unless you are logged in. Other benefits of registering an account are subscribing to topics and forums, creating a blog, and having no ads shown anywhere on the site.


Click here to Register a free account now! or read our Welcome Guide to learn how to use this site.

Photo

Access VBA to create emails in Outlook using default signature


  • Please log in to reply
No replies to this topic

#1 etech0

etech0

  • Members
  • 56 posts
  • OFFLINE
  •  
  • Local time:07:29 PM

Posted 20 September 2012 - 01:26 PM

Hi!

I have an Access question that I'm hoping you can help me with.

I'm using some code in Access VBA to generate some emails in Outlook. The emails get created fine, except that I would like them to include the default Outlook signature. Is that possible?

Here is my code:

    Dim appOutLook As Object
    Dim MailOutLook As Object
    Dim mess_body as string
    Set appOutLook = CreateObject("Outlook.Application")
    Set MailOutLook = appOutLook.CreateItem(0)
    mess_body = "here's where I put the body of the email"

    With MailOutLook
        .To = DLookup("email", "CatWebWork2PrimaryContactQ")
        .Subject = "Catalog Page Proofs"
        .Body = mess_body & .Body
        .Save
   
    End With


Thanks!

BC AdBot (Login to Remove)

 





0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users