Need Program to create form, data-table and use MS Outlook

In Progress

Summary: I'd like a program written using a Microsoft Suite software. We'd need to email a blank form, the completed form would be returned, the information populate a table/database, and when we enter information into the table/database this will send an email response back to the requester.

I’m the manager of a record center at a government agency where we store records and respond to requests for files (records). I’d like for one of our processes to be more streamlined. I’ve detailed the process below, as well as my request for a program to make the process more efficient. My thought that the program would utilize a MS suite program such as Outlook, Info Path, Share Point, Excel, etc.

Please let me know if my request is possible, or if there is another way to get around the limitations I’ve outlined. Also, please see attached file for a bit more information.

Current process (We use MS Office suite 2010)

• An email from another agency employee comes into a dedicated mail box requesting a file (the content of the email is not in any format but has confidential information). We get over 200 such emails a month.

• We cut and paste their information into an Access table for tracking purposes.

• We print the email.

• We later respond to the previously mentioned email letting the requestor know the file is being mailed out or the file cannot be located. We also inform them of other information regarding the non-located file.

• Then we go into the database and either input the date the file is being sent or document what we said in the email that we cannot locate the file.

• We then print out a mailing label (if we are mailing the file) using a Dymo Label maker printer

Minimum requirements – What I envision the program/process to be

• Create a Microsoft Outlook/InfoPath/SharePoint/Excel form. Or something we can email to our requestors. This form would require certain data fields, with perhaps a few other fields of ancillary information. (FYI – our email servers are completely secure as long as we email information internally.)

• After the requestor sends (emails) us the completed form, with a click or two this data would populate our database/table.

• We’d need to print each request.

• We later respond to that request. Is it possible to enter a date in the database/table (as to when we’ll send the file) or a Note in a comments section and that input into the database automatically generate an email response back to the requestor?

Limitations

• I do not have access to our agency servers. Any request for IT services takes over 4 months.

• The requests have confidential information, so a public web site form is not viable.

Extras, if possible

After we say we will send the file, can the program automatically print the requestors address using the Dymo Label printer?

Thank you!! :)

Skills: Microsoft, Sharepoint, Software Architecture, Visual Basic

See more: outlook create form table, what i need to create site, what i need from my manager, we ve sent you an email, web site maker software, web site maker, visual basic web services, sharepoint in a box, sharepoint access services 2010, program to make a site, program requirements document, locate mailing address, government Data, excel form to enter data, employee need, data government, a site to create my web, ms infopath, microsoft office sharepoint, microsoft info path, do i need microsoft office, click agency, web maker software, ms access 2010, summary table

Project ID: #4319494

Awarded to:

pesek

Please, review my private message for detail offer.

$200 USD in 3 days
(14 Reviews)
5.0

4 freelancers are bidding on average $223 for this job

defactoinfotech

De facto Infotech, is a technology consulting firm delivering strategic services and Microsoft technology solutions since1996. We are a Microsoft Partner with Silver Competency providing consulting services in Microsof More

$250 USD in 7 days
(1 Review)
2.6
pythonshell

consider it done . !!! check pm.

$220 USD in 5 days
(2 Reviews)
2.1
exprtsolution

i can make this project and i can guaranty working quality., please check pm..thanks

$220 USD in 6 days
(3 Reviews)
2.0