Newbie needs to know feasibility of creating forms linked to excel

  • Thread starter Thread starter Phil E. Lampe
  • Start date Start date
P

Phil E. Lampe

Hello,

I am a new outlook user, so please forgive me if I ask dumb questions.

My intended application an electronic work order request form. I would
create a form in outlook that has cells that would be linked to an excel
spreadsheet (or access if that would be easier). The idea is that the
user would call up the form, fill it in, and when they exit out of the
form, the form would then populate the excel spreadsheet. That way I
could print out the spreadsheet daily to see what work orders have been
placed.

Therefore, my questions are:

1 - How difficult is this to do?
2 - Is there a good tutorial online that outlines some or all of these
desired functions?
3 - Should I consider doing this instead all inside of the excel
application, I mean, create the form in excel instead?

TIA

Phil in Orange County
 
1) Not difficult if you have a basic understanding of Outlook property
syntax (see http://www.outlookcode.com/d/propsyntax.htm and Excel
automation.

2) I don't follow Excel VBA sites, but some of the samples listed here might
help -- http://www.outlookcode.com/d/customimport.htm

3) It's up to you. You could certainly create a VBA form in an Excel
worksheet that also generates an Outlook message. The Outlook environment
(mail server, version, etc.) might dictate the best approach.
--
Sue Mosher, Outlook MVP
Author of
Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers




Hello,

I am a new outlook user, so please forgive me if I ask dumb questions.

My intended application an electronic work order request form. I would
create a form in outlook that has cells that would be linked to an excel
spreadsheet (or access if that would be easier). The idea is that the
user would call up the form, fill it in, and when they exit out of the
form, the form would then populate the excel spreadsheet. That way I
could print out the spreadsheet daily to see what work orders have been
placed.

Therefore, my questions are:

1 - How difficult is this to do?
2 - Is there a good tutorial online that outlines some or all of these
desired functions?
3 - Should I consider doing this instead all inside of the excel
application, I mean, create the form in excel instead?

TIA

Phil in Orange County
 
Back
Top