Printing bulk of letters all together instead of printing one after another

[Nancy123]

Hi guys

I designed an application in excel as a frontend and Access backend. Now in the userform when the user types all the details in it and press "Complete" button then a letter with all those details gets printed out.

Now the problems users getting are:

1. As they have to type sometimes about 100 letters so each time they press "Complete" the letter gets printed out they have to go to printer to collect the letter otherwise it can get mixed with other documents other users are doing or may be lost.So if one user is doing 100 letters then 100 times he will go to printer and collect it.

Is there any solution so that those letters get saved somewhere and when they press print then the bulk of letters should be printed off together so that they can go just once to printer to collect all the letters.

Presently I have written the following code on "Complete" button:

Please Login or Register  to view this content.

Thanks

[antoka05]

Try to use this code. Do your command call Sub cmd_complete.
This macro will copy all your sheet in a new workbook called 'myLetters.xls' auto saved in your 'my document' folder.
when you close your workbook you will see workbook 'myLetters.xls' with the copy of all your letters.

See attached file, I hope it's what you need.

Regards,
Antonio

Please Login or Register  to view this content.