Newbie Help With Outlook Form Design.

[dogruf]

As the "Excel king" at my work it was asked of me to produce a
workable spreadsheet to collect and collate results for an "Employee
Of The Month" competition.
On futher thinking my idea was to use Outlook and design a form with
drop down menus to choose names and departments.I would then have a
central e-mail address to collect all the e-mails or even better in a
format I can import to Access or Excel.
From what I have seen it is not as easy as using rowsource to
reference a range of cells to a dropdow like I would in Excel. I'm
thinking Outlook is not as versatile as Excel and so I just wanted to
know if any of this could be done before I start researching how to do
it.
I have no prior knowledge of Outlook development but do of Excel
forms, VBA etc.

Many Thanks,
Carl

 

[Hollis D. Paul]

I'm
thinking Outlook is not as versatile as Excel

Actually, Outlook is NOT Excel, and you should learn it for what it is,
not for how it is deficient in respect to Excel. Then, again, if you
want to plead OLD DOG status, why use it at all?

If you want the comfort of using Excel, then use the excel control and
put a spread sheet on your form. Myself, I have not found that an easy
thing to do, but I've rarely used Excel.

Hollis D. Paul [MVP - Outlook]
(e-mail address removed)
Using Virtual Access 4.52 build 277 (32-bit), Windows 2000 build 2195
http://search.support.microsoft.com/kb/c.asp?FR=0&SD=TECH&LN=EN-US

Mukilteo, WA USA