R
RCMetrics
Wondering if the following can be done and if so what should the VB/Macro
look like...
Background:
-hundreds of e-mails is sent to our department on a daily basis..
-E-mail are in a same format/size as they were generated from a system...
-This is currently manually copied from the e-mail body into a xls worksheet
Body is pretty much like:
Account: 9999999
First Name: John
Last Name: Doe
Service: What ever
....And so on... where anything after the ":" is changing according to the
request sent to us... obviously all different.
E-mail size (1Kb), subject (some subject), Sender ([email protected]) are
always the same
Need the e-mail to then be stored in a folder...and something that
automatically sends it to Access and mark as read
I'm looking into ways of avoiding this awful manual process and into getting
a Raise...
Anyone can help?
I'd appreciate...
Thanks
look like...
Background:
-hundreds of e-mails is sent to our department on a daily basis..
-E-mail are in a same format/size as they were generated from a system...
-This is currently manually copied from the e-mail body into a xls worksheet
Body is pretty much like:
Account: 9999999
First Name: John
Last Name: Doe
Service: What ever
....And so on... where anything after the ":" is changing according to the
request sent to us... obviously all different.
E-mail size (1Kb), subject (some subject), Sender ([email protected]) are
always the same
Need the e-mail to then be stored in a folder...and something that
automatically sends it to Access and mark as read
I'm looking into ways of avoiding this awful manual process and into getting
a Raise...
Anyone can help?
I'd appreciate...
Thanks