I've Googled and found a couple of references to this problem on the
web, but no solution. At least I know I'm not the only one seeing
it. The "SaveAsOutlookContact" functionality in A2007 will only work
if the data is contained in an embedded table. If the table is linked
it fails. Has anyone else experienced this? Surely this can't be by
design.

My solution was to make a local / temporary "contacts" table, using the
create tab for tables. By choosing a contacts table, access 2007
automatically sets it up for use with Outlook.

Then, when saving as outlook contact, I do the following:

1) Clear out the local / temp table, with a "docmd.runsql Delete * from
_tmpTblOutlook" or whatever you name the temp / local table.

2) On your button that will run the saveasoutlookcontact, first run an
append query that will append the currently selected contact to the temp /
local table.

3) Then open a small confirm popup that has a command button that says
something like "Export to outlook Now"

4) The recordsource on the confirm popup should be the local / temp table,
where you have ensured that the selected contact's info has already been
appended to the table.

The above works like a charm. In fact, you can also setup the "Add from
Outlook" in the same manner. The benefit if using the temp table, is you can
run your own / existing code that checks for duplicate contacts, etc. Then
just append from the local / temp table.

Hope this helps,

Andy
"Wayne" <cqdigital (AT) volcanomail (DOT) com> wrote

My solution was to make a local / temporary "contacts" table, using the
create tab for tables. By choosing a contacts table, access 2007
automatically sets it up for use with Outlook.

Then, when saving as outlook contact, I do the following:

1) Clear out the local / temp table, with a "docmd.runsql Delete * from
_tmpTblOutlook" or whatever you name the temp / local table.

2) On your button that will run the saveasoutlookcontact, first run an
append query that will append the currently selected contact to the temp /
local table.

3) Then open a small confirm popup that has a command button that says
something like "Export to outlook Now"

4) The recordsource on the confirm popup should be the local / temp table,
where you have ensured that the selected contact's info has already been
appended to the table.

The above works like a charm. In fact, you can also setup the "Add from
Outlook" in the same manner. The benefit if using the temp table, is you can
run your own / existing code that checks for duplicate contacts, etc. Then
just append from the local / temp table.

Hope this helps,

Andy
"Wayne" <cqdigital (AT) volcanomail (DOT) com> wrote

My solution was to make a local / temporary "contacts" table, using the
create tab for tables. By choosing a contacts table, access 2007
automatically sets it up for use with Outlook.

Then, when saving as outlook contact, I do the following:

1) Clear out the local / temp table, with a "docmd.runsql Delete * from
_tmpTblOutlook" or whatever you name the temp / local table.

2) On your button that will run the saveasoutlookcontact, first run an
append query that will append the currently selected contact to the temp /
local table.

3) Then open a small confirm popup that has a command button that says
something like "Export to outlook Now"

4) The recordsource on the confirm popup should be the local / temp table,
where you have ensured that the selected contact's info has already been
appended to the table.

The above works like a charm. In fact, you can also setup the "Add from
Outlook" in the same manner. The benefit if using the temp table, is you can
run your own / existing code that checks for duplicate contacts, etc. Then
just append from the local / temp table.

Hope this helps,

Andy
"Wayne" <cqdigital (AT) volcanomail (DOT) com> wrote

On Mar 8, 9:09*am, "ARC" <PCES... (AT) PCESoft (DOT) invalid> wrote:
Thanks, I'll give this a try.

Hope that worked out for you. I wanted to post a link in case it would help
to "see" the solution in action. Note the 2 popup / access forms asking to
confirm the final step, these are the one's that have the recordsource tied
to the temporary contacts formatted table.
http://www.pcesoft.com/viewlets/Outl...ewlet_swf.html

In the "Add from outlook" function, on the confirm/popup access form_load
event, I'm running the docmd.runncommand addfromoutlook. then displaying
what they selected in the list box, which is where I can run existing code
for adding as customers / checking for dup's, etc.

Hope this helps,

Andy



"Wayne" <cqdigital (AT) volcanomail (DOT) com> wrote

On Mar 8, 9:09 am, "ARC" <PCES... (AT) PCESoft (DOT) invalid> wrote:
Thanks, I'll give this a try.