+ Post New Thread
Results 1 to 4 of 4
How do you do....it? Thread, send emails from contact list in access in Technical; Our SBM has created a list in access of all her contacts that she has, she wants to be able ...
  1. #1
    dezt's Avatar
    Join Date
    Dec 2005
    Location
    Lancs
    Posts
    1,009
    Thank Post
    153
    Thanked 55 Times in 43 Posts
    Rep Power
    28

    send emails from contact list in access

    Our SBM has created a list in access of all her contacts that she has, she wants to be able to have something like a form with all the contacts listed with check boxes next to them, so that she can check the ones she wants to send a certain email to and click a button so they will all go into outlook ready for her to type her message and press send.

    Does anyone know if this is possible and if so how would i go about setting this up for her?

  2. #2
    DrPerceptron's Avatar
    Join Date
    Dec 2008
    Location
    In a house
    Posts
    850
    Thank Post
    32
    Thanked 121 Times in 103 Posts
    Rep Power
    37
    I know it's petty of moi... but... why can't she add the contacts to Outlook and use Outlook to achieve this?

    you can search your own local contact list for contacts and choose which ones to add using the "Address Book" when you compose a new email...

    As for using Access, it may be possible to tell Outlook about the accounts you want to send to using VBA etc... but at the hassle it may cause, you could set Access up to either send the emails itself or send the emails through Outlook.

  3. Thanks to DrPerceptron from:

    dezt (1st September 2009)

  4. #3
    SteveBentley's Avatar
    Join Date
    Jun 2007
    Location
    Yorkshire
    Posts
    1,415
    Thank Post
    116
    Thanked 261 Times in 187 Posts
    Rep Power
    72
    I guess forming a mailto: link on the fly is probably your best bet, but it's a long time since I did anything serious with Access!

    Export it as CSV and import that into Outlook does sound like a good option, as DrPerceptron says!

  5. Thanks to SteveBentley from:

    dezt (1st September 2009)

  6. #4
    dezt's Avatar
    Join Date
    Dec 2005
    Location
    Lancs
    Posts
    1,009
    Thank Post
    153
    Thanked 55 Times in 43 Posts
    Rep Power
    28
    she decided to just put them all in outlook. Thanks for all your help though.

SHARE:
+ Post New Thread

Similar Threads

  1. Importing a Sharepoint Contact List/Calendar
    By Mintsoft in forum How do you do....it?
    Replies: 0
    Last Post: 6th October 2008, 12:07 PM
  2. Access into a list box
    By TornUp in forum Coding
    Replies: 1
    Last Post: 29th May 2008, 04:05 PM
  3. Trying to send hotmail emails over embc - problem
    By Zebadee in forum General Chat
    Replies: 3
    Last Post: 9th May 2008, 09:34 PM
  4. Contact Address List Using Outlook 2003
    By hayjo86 in forum Windows
    Replies: 0
    Last Post: 17th December 2007, 11:00 AM
  5. Cannot send mail to SMTP contact
    By meastaugh1 in forum Windows
    Replies: 1
    Last Post: 22nd January 2007, 09:26 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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