Need info on how to go about coding for extracting excel attachment from Lotus notes

[Pavan.Sada.PS]

Hey Friends,

I have cute little user form which is used for simplifying hiring process in my company. Request you to play around with this form in terms of using all the 3 command buttons "Record Data", "View and Edit" and "Send Email" as there are many things happens in background and I don't know how to explain..

At an overall
1. Record data helps in printing a line entry based on the selections made in the form.
2. Based on the selected metro ticket number it opens up the form allows user to make any changes if he has done any mistake in submitting previously. Also it allows user to print another line item based on the previous selections and making minimum changes.
3. Send email sends out the selected metro numbers in a excel file via lotus notes.

Please look at the Worksheet_SelectionChange in sheet1 Module and SubjectLine procedure in Module 2.

I am working on the VBA for consolidation of those emails so that It will become the complete package. What I am looking at is... Based on the Selected From date and To date, Can I extract the line items from those excel output files and make a consolidated master file? what I meant is that the poor chap who receives numerous emails from different users who triggered emails by using this user form, can be consolidated in a single master file?

If so please guide me on the steps to achieve this out put. I have never worked on this kind of requests and I don't know ABCD of this kind of coding. I order to work I can ask that poor chap to move all those emails received to one designated archive folder so that VBA can lookinto that folder name only.



I have tried researching on Google to get it started and I have done some testing but some how I get run time error -438 on the line "For Each vaAttachment In vaBodyofEmail.EmbeddedObjects" in the attached macro file [Extract Requests]. (Module1)

Please assist me in resolving this...

Password for the vba project: pavangbs

[Pavan.Sada.PS]

Hey Friends..

I got it to work.. here is the file attached for reference.

Password: pavangbs