Our forums are currently in maintenance mode and the ability to post is disabled. We will be back up and running as soon as possible. Thanks for your patience!




By centavur ·
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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Is what I need similar to what you have already done?

by gardenhawk In reply to EXCEL Form

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

Related Discussions

Related Forums