Software

Ask something
Question Locked

EXCEL Form

0 helpful
2 replies

by centavur

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am trying to develop an Excel form for my colleagues to be able to access from the network. When they open the form, the intention is that they will be able to fill in some details and then send it (as an attachment) to their manager for approval selecting his or her name from the Outlook Global Address List (GAL) by a button on the form. Once the manager has approved the request, he or she will then send the form (as an attachment) to a mailbox, using another utton of the form. I presume some programming will be required. So far I have put a macro that can attach the form into an Outlook message but don't know how to make it so that the e-mail address is autoinserted into the To box. Secondly, I don't know how to insert a control that on click will open up the GAL. Can anyone help? Many thanks, Cent.

2 replies

by gardenhawk

I am trying to learn how to create a form in Outlook 2002 that can be filled out by others at a remote location, but on the same network. It will be e-mailed to myself and others, and when received, I can can direct the form to auto-fill into my spreadsheet. (My apologies for the lack of better technical terms). I would prefer that the form is not in an attachment, but included in the body of the e-mail. Most grateful!!! Gardenhawk

This discussion is closed to new replies.