+ Post New Thread
Results 1 to 12 of 12
Windows Thread, Export multiple email from sql database into Outlook 2010 in Technical; Is this possible? Ok, I will give some background info... The office want the email addresses of selected parents, data ...
  1. #1

    NikChillin's Avatar
    Join Date
    Nov 2007
    Location
    on the sofa
    Posts
    958
    Thank Post
    63
    Thanked 128 Times in 91 Posts
    Rep Power
    125

    Export multiple email from sql database into Outlook 2010

    Is this possible? Ok, I will give some background info...
    The office want the email addresses of selected parents, data in excel at present, to be inserted into one email. Currently this is done through copy and paste, one at a time. I have been racking my brain, thinking of linking Access database....... Visual studio.. Excel import.. Outlook import...

    Anyone with sugestions?

  2. #2

    NikChillin's Avatar
    Join Date
    Nov 2007
    Location
    on the sofa
    Posts
    958
    Thank Post
    63
    Thanked 128 Times in 91 Posts
    Rep Power
    125
    It sems possible if I get them into a grid in VB then multiple select from grid, copy and paste into Outlook....

  3. #3

    SYNACK's Avatar
    Join Date
    Oct 2007
    Posts
    11,239
    Thank Post
    882
    Thanked 2,742 Times in 2,316 Posts
    Blog Entries
    11
    Rep Power
    784
    Umm, there are plenty of ways to get this done, you can use macros through an access ADP
    Automated Email Macros; Access>Word>Outlook - Access World Forums
    Using Automation to Send a Microsoft Outlook Message

    you could also use something in VS to just access the APIs
    How to: Create a Mail Item, Attach a Report, and Send the Mail Item to the User's Manager
    C# Programming for beginners: How to use MS Outlook API to send mails
    http://www.codeproject.com/Tips/1655...-attachment-fr

    or you could export to CSV then import this into the address book

    You can automate Office massivly, it is part of the reason it is so popular.
    Last edited by SYNACK; 17th August 2012 at 12:03 PM.

  4. Thanks to SYNACK from:

    NikChillin (17th August 2012)

  5. #4

    NikChillin's Avatar
    Join Date
    Nov 2007
    Location
    on the sofa
    Posts
    958
    Thank Post
    63
    Thanked 128 Times in 91 Posts
    Rep Power
    125
    Interesting... there are quite a few options! Thanks Synack.

  6. #5

    Join Date
    Dec 2008
    Location
    Essex
    Posts
    2,144
    Thank Post
    1
    Thanked 326 Times in 316 Posts
    Rep Power
    77
    If you have exch then it would be nice to import as contacts and maybr add to a dl fir future usse and it will be avaliable to everyone to use and you can put in restrictoons etc...

  7. #6

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    16,212
    Thank Post
    893
    Thanked 1,773 Times in 1,529 Posts
    Blog Entries
    12
    Rep Power
    461
    Quote Originally Posted by sukh View Post
    If you have exch then it would be nice to import as contacts and maybr add to a dl fir future usse and it will be avaliable to everyone to use and you can put in restrictoons etc...
    Even without exchange you can do this, just do it in the local contacts. I would do this personally.

  8. #7

    Join Date
    Dec 2008
    Location
    Essex
    Posts
    2,144
    Thank Post
    1
    Thanked 326 Times in 316 Posts
    Rep Power
    77
    true but if you have exch its managed centrally and dont need to deploy on severals users machine.

  9. #8

    FN-GM's Avatar
    Join Date
    Jun 2007
    Location
    UK
    Posts
    16,212
    Thank Post
    893
    Thanked 1,773 Times in 1,529 Posts
    Blog Entries
    12
    Rep Power
    461
    Quote Originally Posted by sukh View Post
    true but if you have exch its managed centrally and dont need to deploy on severals users machine.
    Exactly

  10. #9

    NikChillin's Avatar
    Join Date
    Nov 2007
    Location
    on the sofa
    Posts
    958
    Thank Post
    63
    Thanked 128 Times in 91 Posts
    Rep Power
    125
    The problem with importing the emails into contacts is that they get out of date, we need them to be taken from the database at the last moment.

  11. #10

    Join Date
    Dec 2008
    Location
    Essex
    Posts
    2,144
    Thank Post
    1
    Thanked 326 Times in 316 Posts
    Rep Power
    77
    Cant the contacts be exported from the DB & then you can scriptt Md schedule a import to AD/Exch.

  12. Thanks to sukh from:

    NikChillin (20th August 2012)

  13. #11

    NikChillin's Avatar
    Join Date
    Nov 2007
    Location
    on the sofa
    Posts
    958
    Thank Post
    63
    Thanked 128 Times in 91 Posts
    Rep Power
    125
    Quote Originally Posted by sukh View Post
    Cant the contacts be exported from the DB & then you can scriptt Md schedule a import to AD/Exch.
    These email addresses are private so we don't want them put in the system. All we wan't to do is give a admin staff member an easier way to add the adresses into a bcc box on an email rather than adding them one at a time.

  14. #12

    Join Date
    Dec 2008
    Location
    Essex
    Posts
    2,144
    Thank Post
    1
    Thanked 326 Times in 316 Posts
    Rep Power
    77
    Depending on how far you want to go with this, you can hide the contacts from those who shouldn't need access. Or a simple cut/copy & paste may be the answer.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 0
    Last Post: 11th April 2011, 03:18 PM
  2. Replies: 21
    Last Post: 18th January 2011, 12:20 PM
  3. Replies: 10
    Last Post: 14th December 2010, 11:17 PM
  4. Exporting email from AOL
    By richard_s in forum Windows
    Replies: 0
    Last Post: 11th March 2009, 09:55 AM
  5. Multiple Email Accounts Outlook 2003
    By richard in forum How do you do....it?
    Replies: 3
    Last Post: 8th June 2007, 10:04 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
  •