Generate All Forms and Memos From Macro

Hello,

This has to do with the 'Training' worksheet. There is a column 'J' that will have a yes or no. Can a macro be created to generate all forms and a copy of the memo with all full names to be print previewed? If the ID has a yes then the employee name, employee number, and account needs to be filled out for each form to be printed.

This may be a lot to ask but I hope it's possible. Also any thoughts on saving the form and memo would be appreciated. There will be other types of training required throughout the year.

Thank you very much for your help in advance.

Yes that is correct. The memos will all be the same but the forms will be different.

Thank you

I don't really know how it works but can it fill out one employee info, print it, clear it, then fill out next employee?

Thank you for the code. I have to leave now but I am sorry this isn't what I wanted.

Maybe it can't be done but I didn't want to create new sheets. There will be one type of training per sheet.

I may have to give this more thought.

Thanks I tried it but error:

Range("M5") = Left(join, Len(join) - 2)

Sorry my bad. I didn't have any of the employees set to 'Yes'.

The code works great when I have 1 or more selected thank you very much!

Could this code be used to export the forms only to a file in word format? Maybe have another button?

I hope I am not asking too much.

It stops at this line error:

Dim wrdApp As Word.Application


Do I have to set up a file ?

It says user defined type not defined

I set up a file for the location:

U:\Old User FIles\REPAIR STATION\Repair Station Training

Will this be needed for the code?

This is what I tried:

Please Login or Register  to view this content.

I guess I didn't. How ?

Tools then References part is grayed out

Okay I exited the debug and enabled Microsoft Word.

Now it opens word and has the form and memo with the employee selected. The page margins are all different and I will have to adjust them I guess to fit the pages. I thought they would go to the file location chosen in the code?

Sorry for all the trouble I am learning so much from you though.

yes it is I put the wrong path.

How can I adjust the margins? So what prints from excel and word are the same?

Could they be set to fit page?

I really appreciate your patience with me. I tried it with 2 employees and it does print out each form with the names of those employees as the document names. Can the memo be named as 'Memo' instead of what I think it's doing is putting my name as the document name.

I noticed another thing happening. If I run it again the word documents get replaced.

Thank you that makes better sense although the word documents don't fit on one page and the centering texts are different.

Would it be better to export to pdf so the image is scaled the same?

I have been so much trouble for you sorry.

I attached the file for your review if you would be so kind.

The print area changes sometimes and only prints the memos. Maybe the print preview buttons are interacting?

Yes they do but when I select the 'All Forms and Memo Print Out' the print area is reduced to only print the memos.

It prints one memo and all the forms. The print areas are corrected now but it should have one memo for each employee please.

Thank you

Perfect thank you so much for your help.

I will mark this thread closed and try to figure out how to save the forms as pdf on another thread.

I have taken up so much of your time I hope to repay the favor some how one day.