Solved

Save as Outlook Contact cmd

Posted on 2008-06-18
8
2,481 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 

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

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

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

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…
In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
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…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

705 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