Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jun 2002
    Location
    Nottingham, Nottinghamshire, United Kingdom
    Posts
    257
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Merging emails from Access (2003)

    Hi

    I am writing Access code to send multiple emails from a query in an Access database. I'm going to use the CreateItem method in VBA and am reasonably clear how to code this.

    The problem is that at work my Outlook has several different accounts (for different related companies) and I want to be able to send the emails from a specific account (not the default). Is there code that can tell Outlook to create the emails using a nominated account, similar to my selecting the account through the accounts button on the toolbar?

    Many thanks

    David

  2. #2
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Merging emails from Access (2003)

    I don't recall a clean way to do this. My past "solutions" have involved code to manipulate the Accounts toolbar button. <img src=/S/sad.gif border=0 alt=sad width=15 height=15> This won't work very well if you don't have an Inspector window open on the screen...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •