Outlook forms and Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rory - 23 Mar 2005 15:55 GMT

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?

Reply to this Message

Sue Mosher [MVP-Outlook] - 23 Mar 2005 15:59 GMT

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

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> I've created a user appraisal form in Outlook 2002. It is populated with
> textboxes for the user to write comments plus optionbuttons, comboboxes
[quoted text clipped - 10 lines]
> Is all of this possible, please? Is there a good source of information for
> me to get to grips with this concept?

Reply to this Message

Roderick O'Regan - 30 Mar 2005 13:51 GMT

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

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

Reply to this Message

Sue Mosher [MVP-Outlook] - 30 Mar 2005 13:57 GMT

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

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

Signature

Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx

> 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
[quoted text clipped - 13 lines]
>>Are you using Exchange as your mail server? If so, can you publish a form to
>>the Organizational Forms library?

Reply to this Message

Walter - 23 Mar 2005 22:49 GMT

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.

> 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
[quoted text clipped - 8 lines]
> Is all of this possible, please? Is there a good source of information for
> me to get to grips with this concept?

Reply to this Message