Chance1234
IS-IT--Management
Heres a scenario which im facing
company B have lots of offices, over the UK , they want to coallate complaintts infrination from all of their offices
up to head office.obvioulsy cant say who my client is , but typical of these type of people there IT infrastructure
is pants and they wont spend any money.
Firstly lacking is there not all on the same network and getting them all on the same network isnt possible, they wont
spend money on geting access, but however they all have excel and they all have outlook, i hate using excel as a database but
dont have much choice here.
What i was thinking however is using outlook as a back end for my "database" and excel as a front end. what i am thinking is
i have a form in excel for entering a new record, when the user hits saves via VBA the from sends an e-mail up to head office
at head office, the person there has a message rule which moves the message to a specified folder in the outlook folders, then
in the excel spreadhseet there, using VBA on open, it lists all the e-mails in that folder on a spreadsheet.
Only thing is this complaints thing has 20 odd fields i can only see how i could get the subject heading of the mail listed on a excel spreadsheet
how could i get detailed infomation ?
Also another point is if the user wants to change a record how would i approach that ?
or is this totally the wrong approach ?
Chance
company B have lots of offices, over the UK , they want to coallate complaintts infrination from all of their offices
up to head office.obvioulsy cant say who my client is , but typical of these type of people there IT infrastructure
is pants and they wont spend any money.
Firstly lacking is there not all on the same network and getting them all on the same network isnt possible, they wont
spend money on geting access, but however they all have excel and they all have outlook, i hate using excel as a database but
dont have much choice here.
What i was thinking however is using outlook as a back end for my "database" and excel as a front end. what i am thinking is
i have a form in excel for entering a new record, when the user hits saves via VBA the from sends an e-mail up to head office
at head office, the person there has a message rule which moves the message to a specified folder in the outlook folders, then
in the excel spreadhseet there, using VBA on open, it lists all the e-mails in that folder on a spreadsheet.
Only thing is this complaints thing has 20 odd fields i can only see how i could get the subject heading of the mail listed on a excel spreadsheet
how could i get detailed infomation ?
Also another point is if the user wants to change a record how would i approach that ?
or is this totally the wrong approach ?
Chance
