Scorpiko
05-30-2006, 08:27 PM
Hi,
I'm new to programming with outlook and vb but with simple background on C++ and Java.
Basically i'm doing a registration page for my company and i need to complie the info from the email the page sends to me into an excel file. Hundreds of people register per day and manually inserting the mail body information into each column is taking up almost all my time leaving me with no time to do anything else :(
Long story short, some of the information is as follows
1) The email will come with a Subject: "Registration" (without the "").
The program should scan through the subjects and only saves those with the correct subject.
2) Body of the mail is as follows:
======== Product ========
Product Type : xxxxx
Model Number : xxxxx
Serial number : xxxxx
Full Name : xxxxx
Contact Num : xxxxx
=======================
** the xxxxx is the information i need to save into the excel file
3) Need to save it to an excel file c:\Registration.xls. Auto update(ie append) the old data must NOT be deleted. And i believe that a single worksheet has a limit to how many it can accept will it be a problem?
4) The titles in Registration.xls will be titled according to the info's title.
ie. Product / Model / Serial / etc.
4) I'm using MS Outlook 2000 SR-1 (if this helps)
5) The mails should be placed into the trash/deleted item folder.
Sorry for the long post.
I couldn't find any post with this topic i might have missed it.
Many thanks to who ever that can end my misery.
Regards,
Scorp
I'm new to programming with outlook and vb but with simple background on C++ and Java.
Basically i'm doing a registration page for my company and i need to complie the info from the email the page sends to me into an excel file. Hundreds of people register per day and manually inserting the mail body information into each column is taking up almost all my time leaving me with no time to do anything else :(
Long story short, some of the information is as follows
1) The email will come with a Subject: "Registration" (without the "").
The program should scan through the subjects and only saves those with the correct subject.
2) Body of the mail is as follows:
======== Product ========
Product Type : xxxxx
Model Number : xxxxx
Serial number : xxxxx
Full Name : xxxxx
Contact Num : xxxxx
=======================
** the xxxxx is the information i need to save into the excel file
3) Need to save it to an excel file c:\Registration.xls. Auto update(ie append) the old data must NOT be deleted. And i believe that a single worksheet has a limit to how many it can accept will it be a problem?
4) The titles in Registration.xls will be titled according to the info's title.
ie. Product / Model / Serial / etc.
4) I'm using MS Outlook 2000 SR-1 (if this helps)
5) The mails should be placed into the trash/deleted item folder.
Sorry for the long post.
I couldn't find any post with this topic i might have missed it.
Many thanks to who ever that can end my misery.
Regards,
Scorp