?
Solved

Save as Outlook Contact cmd

Posted on 2008-06-18
8
Medium Priority
?
2,614 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
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 

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

Easily Design & Build Your Next Website

Squarespace’s all-in-one platform gives you everything you need to express yourself creatively online, whether it is with a domain, website, or online store. Get started with your free trial today, and when ready, take 10% off your first purchase with offer code 'EXPERTS'.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Usually, rounding is performed by some power of 10 - to thousands, hundreds, tens, or integer - or to one, two, or more decimals. But rounding can also be done to a power of two, say, 16 or 64, or 1/32 or 1/1024, even for extreme values.
The best software application must always have an error handling tool
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

590 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