(How) Can I embed an Access (subfolder) query into Outlook tasks?

L

Lauren-IP

I've been able to import an Access table into tasks, but only with the field
headers given. I need to import a query from that main table, WITH the field
header as is. I've been able to rename the field header in a newly created
task, but cannot make these headers apply to any other task.
In the end, I want to run a task (reminder) for the deadlines that come up
in the Access query, and, once the task is complete, have that reflected back
into the Access query.
Can this be done? (I'm using Office (Outlook) 2000)
 
S

Sue Mosher [MVP-Outlook]

I'm not sure what you mean by "the field header as is" or "make these
headers apply to any other task."
 
L

Lauren-IP

Thanks for the reply.
To clarify: I would like the field header names we use in our Access table
to be imported to a task in Outlook. When I import the Access table, I have
to reassign the field headers to the default headers given.

Ideally, I'd like to use the (shortened) query (not the main table) from
Access for this particular task.

I was able rename/assign another task with the Access field names, but
cannot import to this (properly-named) task.

....And if I may go a level further...
The Access query is for reminder e-mails that must be sent at a particular
time -- already entered into that query. I want to have the Outlook task
remind us to send these e-mails when that date comes due from Access.

Is all this possible?
Thank you,
Lauren
p.s. CAn this be done on the phone?
516-676-4571 (M-F 9:00 -5:30 EST)
 
S

Sue Mosher [MVP-Outlook]

I'm still having difficulty understanding your question. But I can tell you
that you cannot change the names of Outlook properties. If you want to
change the import mapping, you do that on Outlook's Import and Export
Wizard. Outlook doesn't support importing to a custom form or custom fields,
unless you write custom code or use a third-party application. See
http://www.outlookcode.com/d/customimport.htm.


--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
L

Lauren-IP

Sorry Sue, I must be speaking my own language on this (I'm a fairly new user
of Outlook tasks & Access -- I'm sure you can tell).

Can I import a QUERY from Access, as opposed to the entire (main) TABLE it's
built from? The query has just the (limited) information I need for the task
I'd like Outlook to do (remind me of). From what I can tell, only .mdb files
can be imported into Outlook (from Access). But I need the the Query, and I
can't find an extension on this kind of file. Can you help here? (...and I'm
not at a place where I'm can write my own code to do this). : )

Lauren
 
S

Sue Mosher [MVP-Outlook]

I think you need a table. You can use a Make Table query in Access to create
the table just before you import.

--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
 
Top