Click here to Skip to main content
15,881,172 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hi Guys

I need to be able to export data from emails, I look after recruitment and need to be able to put all the vacancy request information into one excel spreadsheet so the heading run at the top of the excel spreadsheet, e.g in A1- Vacancy internal/external and then in A2- Position, The subject of the email is always- Vacancy Request Form, and information is always in the same format: Please see below details:

Vacancy Internal/External :
Position :
Vacancy Type :
Please confirm Total hours available :
Reason for vacancy :
Leaver Name :
Are there any consultants looking for additional hours in store? :
Please confirm shift pattern :
Store name and number :
Store Type :
Number of consultants required? :
Date customer consultant required [dd/mm/yyyy] :
Requested by :
Date Requested [dd/mm/yyyy] :
Additional comments :


Would really appreciate your help in this.

Thanks

John
Posted
Comments
[no name] 9-Aug-14 11:55am    
Help.... with what? This is not a question or a description of any kind of problem.
Abhishek Pant 9-Aug-14 14:15pm    
parse every mail from outlook that have subject you provided..if same then find email text and split and export as required in db or excel

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900