Need Advice Excel to Mail Merge

[GrandMaMa]

This may come as a surprise, but I am a school teacher and rarely use Word.
I am not in Language Arts.

I have 70 Excell WorkBooks from which I must do Mail-Merges.

When other teachers decide to do a mailing they keep selecting the wrong
Workbook.

I want to try to do the MailMerges with Macros unless someone out there has
a better way of getting around this problem.

Any Recommendations are Appreciated!

Granny

 

[Bear]

GMM:

It all depends on why they pick the wrong workbook. If all the macro will do
is limit the number of selections or make the selection names clearer, you
could probably do that by renaming the workbooks and grouping them in separte
categories in different files or folders.

Bear

 

[GrandMaMa]

Bear;
Thanks for getting back!

They have to select the WorkBook based on Criteria! If you were a
high school teacher it would be easier to understand.

I want them to enter the criteria and then let the macro assign the
WorkBook and do the MailMerge if it is possible.

Thanks

Granny

 

[Russ]

In Excel and Word you can record a macro while doing the operations you
require. Open Excel with a blank workbook. Record a macro with menu
Tools/Macro/Record New Macro... A dialog will show asking if the suggested
name of the macro module is OK. Note the name and click OK. A record toolbar
will popup. It will already be in record mode. Open the workbook you want.
After it is loaded, click on the stop button in the record toolbar. Press
ALT/F11 key combination to bring up the VBA editor. In the Project window,
expand the module folder, double click on the module number you just
recorded.
Look at the code and alter, if needed. Macros can be assign to hotkey
combinations, menus, and toolbar buttons.
May this will get you started and know what question to ask next.

 

[GrandMaMa]

Russ;
Thanks for getting back to me!

I will start to work with this on Thursday!

Hope I can resolve this problem.

Granny