Issue with DoCmd.RunCommand (acCmdSaveAsOutlookContact)

[Verdenal]

Hi, I meet an issue with this command: the MS template "Contacts and Tasks", there is a button 'Create a contact Outlook' (a macro with thec command SaveAsOutlookContact). Il I change the source of the Forms (a table of mine, vs the Query "Extended Contacts"), it occurs an error, ?

Is somebody knows what I can do ?

Thanks.

Serge (in France)
'sory, my English is rude ...

 

[vbaInet]

I've just had a play with this and I can confirm that it won't work with the table you created. You have to download the Contacts template and import the Contacts table into your database. Now create a form based on this imported table and run the command. It should work.

You can change the table name if you want or even change the field names as you see fit, but regardless of whatever you call the field names it won't affect the result you see in the Add Contacts dialog in Outlook.

The developers at Microsoft have created a mapping between the fields in the table and the fields in Outlook and that internal structure cannot be changed.

Edit: But of course you can write your own code to create a new contact from any record source anyway.