Solved

Save as Outlook Contact cmd

Posted on 2008-06-18
8
2,393 Views
Last Modified: 2013-11-28
Can someone please explain to me how to use the built in command SaveasOutlookContact? How does it know which Access fields are mapped to which contact fields? I can get some to map, but not others.

Thank you!
Bret
0
Comment
Question by:bfarris7581
  • 3
  • 3
  • 2
8 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 21814396
0
 

Author Comment

by:bfarris7581
ID: 21815251
Thanks, but that's not what I'm looking for. Access 2007, through it's VBA interface, has a built in function for adding a Outlook contact from data. I would appreicate someone who has had experience with this function telling me how (or where I can find) to use it.

Thanks!
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 21817027

in vba you can use the SaveasOutlookContact  this way

 docmd.runcommand accmdSaveasOutlookContact
0
 

Author Comment

by:bfarris7581
ID: 21817058
I understand that, but how does that command know which fields are mapped to the Outlook Contact Fields? When I do it now, only about 50% of the fields are mapping correctly. Thank you.
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 21817097
bfarris7581,

Are you sure the "SaveasOutlookContact" is exposed in VBA?

When I did this on my machine, everything I needed I found here:
http://www.mydatabasesupport.com/forums/ms-access/377693-a2007-saveasoutlookcontact-won-t-work-linked-tables.html

There is even a link to a demo of the feature in Action.

JeffCoachman
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 21886682
bfarris7581,

So I guess you are not interested in any more resources?

JeffCoachman
0
 

Accepted Solution

by:
bfarris7581 earned 0 total points
ID: 21886702
Sorry, I just figured I would wait. Here is the VBA code that I'm referencing...
Private Sub cmdSaveAsOutlookContact_Click()

On Error GoTo cmdSaveAsOutlookContact_Click_Err
 

    On Error GoTo 0

    DoCmd.RunCommand acCmdSaveAsOutlookContact
 
 

cmdSaveAsOutlookContact_Click_Exit:

    Exit Sub
 

cmdSaveAsOutlookContact_Click_Err:

    MsgBox Error$

    Resume cmdSaveAsOutlookContact_Click_Exit

Open in new window

0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 21887860
bfarris7581

I am not at my 2007 machine.

Is that code working for you?

Thanks

JeffCoachman
0

Featured Post

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now