Discussion on:
Message 2 of 7
Using Macros For simple Forms
I would like to see an article that covers the use of macros to create and fill simple forms from information present in the computer or that can be completed by the user if the information is not available. A perfect example would be a Fax cover sheet. I would like to have a macro that I could install on each user's workstation that when activated by a button on the tool bar would go to that specific users contacts, take that users name, direct dial phone number, direct incoming fax number from an entry in outlook contacts (we could put a standard entry in each users contacts called "A1" or "Addressor" with that information customized for the specific user, and place that information into a fax coversheet template. Then, the macro would stop and ask for the name of the person to whom the fax should go, if the information is in that users's outlook contacts or a shared contacts address book, it would fill in the Name, company name, fax and phone number and then stop allowing the user to check off a box like urgent, please reply, hard copy to follow, etc. and then type in a message if desired into the body.
Posted by eshelton@...
1st Mar 2006

































