Outlook program, outlook form, local webpage form & Excel

  • Thread starter Thread starter Junoon
  • Start date Start date
J

Junoon

Hi,

I am trying to make a local webpage, (client-side), for all employees
to access it. it is a web form, which they have to fill & submit.

Now, due to IT restrictions in our office, all the employees donot have
Excel, but they have MS Outlook mail program to mail to their
Supervisors. only the Supervisor has Excel installed on his computer.

I tried making a 2-column table form made in MS Outlook .msg file
(which is clumpsy), which is stored in a folder & linked to a local
webpage available to everyone. Employees click on the .msg file fill
the table form & send it to their Supervisor who collects it in an
Excel worksheet using VBA Macro.

Since i have limited resources, i.e. MS Outlook & the html page, i want
to create a webpage form which users can fill & Submit using VBScript
or VBA (not Javascript, as it does not submit contents client-side),
Directly to the MS Outlook program, which will mail contents to the
Supervisor's Excel Sheet as a 2 column table to be extracted in Excel..

Also, does anyone know Outlook Form Design (form publishing) & can it
work with VBScript or VBA to mail text contents to Outlook & ultimately
to Excel worksheet....????

P.S: The html webform or Outlook Published Form will have the exact
labels as the Columns headers in the excel sheet, so that data will get
extracted automatically under the appropriate Header columns.

Once i get a gist of how to create a form, code it in VBScript or VBA &
mail it into Excel sheet on Supervisor's PC, i would be creating
different forms for different sheets....

Can anybody help!
Please Help ASAP!
 
Am 2 Apr 2006 14:37:03 -0700 schrieb Junoon:

I have a commercial tool that does exactly what you are asking for. If you
are interested the please mail to me.

If you rather like to code it yourself, creating and publishing HTML forms
is probably easier than creating then creating Outlook custom forms. But on
the receiver´s side it´s easier to read the custom form´s content.

Extracting the data into the Excel sheet is a lot of more work. You can use
the Inbox´ ItemAdd event which tells you about new messages. If the message
was created by an HTML form then read its Body content with the functions
Left, Right and Mid. If it´s an custom form then read its UserProperties.

You need the Excel functions Workbooks.Open and/or Workbooks.Add to create
new new sheets or to open existing ones. If each e-mail should be copied
into its own sheet it´s easier, simply write the field names into the
Range("A1") .Value, Range("B1").Value etc., and the field values into
Range("a2").Value etc.

If instead many e-mails with the same topic should be copied into the same
sheet, then you´d need additionally the Find function to look for existing
column names and the next free row.

For each mentioned function you´ll find samples in the Outlook or Excel VBA
help file.
 
Back
Top