Hi guys,
I have written a script that returns 3 things of all the employees in my organisation. i.e. Name, Login time & log out time of each and every employee. It returns the output in pipe-delimited format. For your ref. sending a small sample
e.g.
Deepti|083032|174501
Anushka|081705|190003
Neeraj|082715|173200
After getting this output I copy it to excel and convert that pipe-delimited txt to normal excel format by using “Text-to-columns” option in excel.
Then I use MS Word's “Mail Merge” function to arrange n print it in a particular format. For your ref. sending a small sample
e.g. (After using MS word's “Mail Merge” option, the document which is ready to print looks something like this)
Name: Deepti
Login time: 083032
Log out time: 174501
Name: Anushka
Login time: 081705
Log out time: 190003
Name: Neeraj
Login time: 082715
Log out time: 173200
This format then I print on a “PIN Mailer” (Continuous stationary)
Now, what my problem is, as you can see, I have to do lot of manual work in this log printing process.
Can I in any way automate it? Like, something which I can incorporate in my script which is giving me that pipe-delimited format.
Can I get a txt document that can be ready to print?
Waiting for reply.
And thanx in advance