Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Seattle, Washington, USA
    Posts
    179
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access and Outlook

    I have a challenge for y'all...An end-user wants our database to automatically add Email address that she types into the form to her Outlook 2000 distribution list.

    We are using Access 2000.

    Thanks! [img]/w3timages/icons/beep.gif[/img]

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Access and Outlook

    Hi,
    Does she want them added to a particular distribution list (new or existing) or just added to her contacts folder?
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Seattle, Washington, USA
    Posts
    179
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access and Outlook

    My end-user wants to add it to a specific distribution list. I believe she already has a distribution list set up.

    Oh, it would be nice if I could make sure that Access will NOT add duplicate addresses. This database is for a camp and people apply annually for it.

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Access and Outlook

    Brent,
    Sorry I should have asked all this last time but anyway:
    1. Where is the distribution list - Contacts folder, global address list?
    2. The application will need to create a contact before it can add the recipient to the distribution list - is this going to be OK? If the mailing is to be done from Access, it might be easier to store the names and email addresses in the database and add them programmatically when the mail is created. That would save maintenance on the distribution list (i.e. adding/deleting members each year)
    If you do still want the distribution list (e.g. you might want to use it for other things) please repost with the answers to those questions and we will see what we can come up with.
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Seattle, Washington, USA
    Posts
    179
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access and Outlook

    Rory, here's my answers to your questions.

    1. The distribution list will be located in the Contacts folder.

    2. I didn't realize that I could store names and Email addresses in the database and programatically add them to the distribution list. This would be great in terms of maintenance like you said. We already are storing names and Email addresses.

    By "programatically adding" email addresses, I'm assuming that it would require VBA programming? I don't have slightest clue in regards with VBA, although, I'm planning to take a course in March.

  6. #6
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Seattle, Washington, USA
    Posts
    179
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access and Outlook

    I missed a question of yours...It is perfectly fine to create new contact before adding it to the distribution list. I believe that's the only way to get the distribution list set up anyway?

  7. #7
    Star Lounger
    Join Date
    Jan 2001
    Location
    Bethel, CT, USA
    Posts
    58
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access and Outlook

    Rory,
    I'd like to do the same thing as Brent. So I'm looking forward to seeing your response.

    Brent,
    Don't worry about code. Make a copy of your database to play in, and then have fun. The worst that can happen is you go back to your original and wait til the end of class. But I think there are plenty of people here who will be happy to guide you through it.

  8. #8
    2 Star Lounger
    Join Date
    Feb 2001
    Location
    Seattle, Washington, USA
    Posts
    179
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access and Outlook

    Thanks to you all for your help! I really appreciate it.

  9. #9
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    The Netherlands
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access and Outlook

    [URL Markup added to link - Rory.]

    Hi,

    Yes, it will take some VBA programming.
    Take a look at Feddema's pages, she has the solution for you.
    You can download the code you need from there.
    Oops, I forgot, the download page of Helen is over here: <A target="_blank" HREF=http://www.helenfeddema.com/CodeSamples.htm>http://www.helenfeddema.com/CodeSamples.htm</A>

Posting Permissions

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