Outlook forms and Excel

[Rory]

I've created a user appraisal form in Outlook 2002. It is populated with
textboxes for the user to write comments plus optionbuttons, comboboxes with
choices, etc.

I now want to send this form to users of my choice - not as a merge - and
they can then forward the form back to me with their replies.

I then want to take the results of all the objects in the form and drop them
into an Excel file (to act as a database) for subsequent manipulation.

Is all of this possible, please? Is there a good source of information for
me to get to grips with this concept?

 

[Sue Mosher [MVP-Outlook]]

Are you using Exchange as your mail server? If so, can you publish a form to
the Organizational Forms library?

 

[Walter]

If you create a custom view with all of your fields displayed, you can select
all of the rows in the view and then paste them into Excel... works like a
charm.

 

[Roderick O'Regan]

Ahhh. now here's the rub...I'm floundering a little here. I normally
deal with Word VBA and have never done anything with Outlook so it's a
new ball game for me.

Looks like I need to start from the begining somewhere...wherever that
is!

Is there a suitable place I can start reading up a little more on
this, please?

I feel like a dog who has a nice juicy bone to eat but don't know how
to!

Rory

 

[Sue Mosher [MVP-Outlook]]

If you're new to Outlook custom forms, you might want to start here:

http://www.outlookcode.com/d/forms.htm


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