Results 1 to 3 of 3
  1. #1
    MartinStreat is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2016
    Location
    mid wales
    Posts
    2

    add contacts from outlook fail

    Hi
    I have an outlook contacts folder with 127 people. They were carefully added to enable me to do an email and posted monthly newsletter. Due to problems of updating addresses etc on both laptop and desktop I feel I need an access database. I am using the 'contact management template' in access 2016. nice neat database just what I need. (I have used access for many years)


    My problem is when I use the 'Add from Outlook' button all I get is 70 people who have email addresses. the ones with no email and a postal address only do not appear.
    I cannot type the rest in by hand, error prone to say the least.
    why does the system not see the people with no email. when I print labels it sees all my people and I can select blanks only.
    any body like to help me before Aprils newsletter. thanks
    Mart

  2. #2
    NTC is offline VIP
    Windows 7 64bit Access 2013
    Join Date
    Nov 2009
    Posts
    2,392
    well first I have not inspected the specifics of that template so I can only answer with generalities.... the button triggers actions which in turn are based on queries which define the record set. The designer must have felt that records with no email should be excluded. So your choice is to dig into which query that is, and modify it...... or..... enter a dummy email address for those 70 so they get included.....

  3. #3
    MartinStreat is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2016
    Location
    mid wales
    Posts
    2
    Thanks for your reply. I did try the false email and it does bring the other 57 in but without the postal address. I have been searching for a while now and just now found a old answer from ms. It appears the address boxes in outlook store the enter key stroke, to move to next line, weirdly so it screws up the csv file which is used to tranfer the data.
    I had thought I made a good decision to use outlook but now I'm not so sure.
    Thanks again

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

Similar Threads

  1. Linking to an MS Outlook Contacts Folder
    By rjgriffin46 in forum Access
    Replies: 3
    Last Post: 10-28-2014, 04:00 PM
  2. VBA - Import Outlook contacts to access 2010
    By snoopy2003 in forum Programming
    Replies: 2
    Last Post: 11-12-2011, 12:33 PM
  3. Linking accdb to Outlook Contacts folder
    By Craig in forum Import/Export Data
    Replies: 1
    Last Post: 02-14-2011, 05:51 PM
  4. 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
  5. Outlook contacts
    By noidea in forum Access
    Replies: 0
    Last Post: 07-31-2009, 07:44 AM

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