Solved

Save as Outlook Contact cmd

Posted on 2008-06-18
8
2,435 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 120

Expert Comment

by:Rey Obrero (Capricorn1)
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 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 21817027

in vba you can use the SaveasOutlookContact  this way

 docmd.runcommand accmdSaveasOutlookContact
0
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 

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
 
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

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Familiarize people with the process of utilizing SQL Server views 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 Access…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

830 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