Creating a Custom Task Form for Export into Excel or Access

[mutthound]

I am hoping to create a custom task form that will allow me to transfer the
data from outlook to either excel or access .

If it is easier to develop, I might just copy and paste the data if it all
can be done with a "copy all" method., as It will be only used for a short
amount of time by a few people (under 100)

Am I better off creating a website for people to assign tasks, or can this
be pulled off with Outlook 2000?

Any help is appreciated.

 

[Sue Mosher [MVP-Outlook]]

Whoa! Web site? Assign tasks? Copy and paste data? There are a lot of big
pieces there but no big picture. Why don't you back up and explain what it
is you're really trying to do?

 

[mutthound]

What I am trying to do is make a "request to purchase" form. It will answer
the questions What? how much? when? how often? Bill to? Contact name? Ship
to? It should have room to order up to10 items at a time.

I will be the only "non customer" using the final product. About 15
customers will use the product each day. Once a day I will need to use the
data to place orders with 2-4 suppliers and It will only be used for a bout
2 months.

Whatever system I use, I will need to get the data into an environment like
a spreadsheet or database for record keeping.

Did I do better this time Sue?

thanks

 

[Sue Mosher [MVP-Outlook]]

Better, but still not the complete picture. Are these customers all using
Outlook? If not, then build a web page form that emails information to you
in a structured format or places it directly in a database.

If they are using Outlook, are they willing to publish your custom form on
their system?

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