A Microsoft Outlook email forum. Outlook Banter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Outlook Banter forum » Microsoft Outlook Email Newsgroups » Outlook and VBA
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Outlook program, outlook form, local webpage form & Excel



 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1  
Old April 2nd 06, 10:37 PM posted to microsoft.public.outlook.program_vba
Junoon
external usenet poster
 
Posts: 27
Default Outlook program, outlook form, local webpage form & Excel

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!

 




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
modify outlook form-appointment form blanc Outlook and VBA 1 March 24th 06 03:20 PM
Import from excel into a custom form and fields in Contacts John Outlook - Using Contacts 1 February 1st 06 02:37 PM
Outlook opens Form as Email message, not Form [email protected] Outlook - General Queries 2 January 26th 06 09:54 PM
I send an Outlook custom form, but a std. form displays? Sue Mosher [MVP-Outlook] Outlook - Using Forms 0 January 20th 06 07:41 PM
Can I program on the designed form in outlook? Eric Legault [MVP - Outlook] Outlook - Using Forms 0 January 10th 06 04:33 PM


All times are GMT +1. The time now is 09:51 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2025 Outlook Banter.
The comments are property of their posters.