Solved

Save as Outlook Contact cmd

Posted on 2008-06-18
8
2,379 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
Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

 
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
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…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

762 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

21 Experts available now in Live!

Get 1:1 Help Now