acCmdAddFromOutlook

[Mikki]

Good Day~
I have used the DoCmd.RunCommand acCmdAddFromOutlook, but it does not capture every field value. Can the acCmdAddFromOutlook be ran in a vba code?
I want to get one contact's information into the access table.
Please advise.
Thank you in advance~mjc

 

[NauticalGent]

Do I imderstand correctly that you want to work with your outlook contacts?

 

[Mikki]

Good Day~
Yes I want to bring one Outlook contact information into an Access table. It is bring in the basic information, but I need it to capture the Alias and Display names also.
Thanks so much~mjc

 

[sneuberg]

Can you tell us more about what you have set up? I'm especially curious about how you have acCmdAddFromOutlook working. There doesn't seem to be much information on line about it.

I find (in Access 2013) that I can link to my Contacts folder. The linked table seems to have all of the Contact information although I don't see Alias. Could this be Nickname which I do see? Anyway do you have this link table?

If you have this linked Contacts table or can set it up I could give you some VBA code to copy the data. I'd need to know to where you want it copied (e.g., Form or Table) and if you want a specific record what information would determine that record.

 

[Mikki]

Good Day~
I have a Contacts table with these fields
ID
Company
Last Name
First Name
E-mail Address
Job Title
Business Phone
Home Phone
Mobile Phone
Fax Number
Address
City
State
ZIP Code
Country/Region
Department
Office
Display Name
Alias Name.
I have a form with a command button that on click it does the DoCmd.RunCommand acCmdAddFromOutlook.
The only field values that command imports is
Company
Last Name
First Name
E-mail Address
Job Title
Business Phone
Fax Number
Address
City
State
ZIP Code
Country/Region.
I need a VBA code to bring up the Outlook Select Names to Add: Global Address List dialog box and bring all the field values into the Access table.
Thx~mjc

 

[sneuberg]

Something has come up and I won't have time to help you until later today or tomorrow. In the mean time please read this Web page and see if it has any information you can use.