Outlook forms and Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Are you using Exchange as your mail server? If so, can you publish a form to
the Organizational Forms library?
 
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.
 
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
 
Back
Top