Results 1 to 2 of 2
  1. #1
    aguynamedcj is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2015
    Posts
    1

    expanding cmd:addfromoutlook to import additional columns from contacts

    I am an Access noob! Using Access 2010 on a Windows 7-64bit machine.



    I am trying to begin an employee database using the faculty template. It would be exceptionally helpful if the "Add from Outlook" command that is built into the "Faculty list" form would fill more than just the name, email address, and phone number fields. There are fields on the form for Department which match available info from the Outlook address book, but isn't imported.

    How can I tweak the command to fill the additional fields?

    I realize I'm a simpleton, no coding or programming experience. Detailed help would be greatly appreciated.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,643
    As far as I can tell, can't. The AddFromOutlook command does not have any arguments - it does what its programmed to do and that's all.

    Would have to use custom code that manipulates Outlook object. The following shows exporting from Access but the import code should be similar http://support.microsoft.com/kb/290658

    Can also set a link to Outlook.

    http://www.outlookcode.com/article.aspx?id=25
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Dynamic Columns - Import new columns?
    By memaxt in forum Import/Export Data
    Replies: 2
    Last Post: 06-24-2014, 06:02 AM
  2. Replies: 3
    Last Post: 10-19-2013, 10:21 AM
  3. Replies: 1
    Last Post: 04-09-2013, 06:59 AM
  4. VBA - Import Outlook contacts to access 2010
    By snoopy2003 in forum Programming
    Replies: 2
    Last Post: 11-12-2011, 12:33 PM
  5. How to import specific Outlook contacts into Access?
    By Chevalier in forum Import/Export Data
    Replies: 1
    Last Post: 12-05-2010, 02:41 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums