Help with merge

[cla]

I need help with a merge. I have a spreadsheet with personal info (about 100 members). I need to print out a form for each member with their individual info (like ID #, birth date, name). I have the form in Excel as well. Is there a way I could set this up like a Mail Merge so that I can just do one form and it will fill in the individual information automatically without me having to cut and paste each one or type manually?

[daleyman]

You might want to use vlookup for this.

Name the range of data relating to the 100 members, for example, "membersdata", with the ID in the first column of this range. If the ID is not 1,2,3,4...etc then you might want to assign a new ID of this nature for the first column, just for this purpose.

Then on the form that requires the info, enter the ID by hand somewhere on or off the form, and in the other fields put, for example:

=VLOOKUP(A1,membersdata,2,false)

which will get the id from cell A1 of the current sheet, look it up in the first column of the named range, and return the value from column 2 of the named range, etc etc...

Then you only need change the ID cell and the rest of the info will update automatically, and print and then change to the next ID, etc...

[Jack in the UK]

To add also could bve merge by that i nean trans into Word... yuuuuck! but the fields need to be set correctly and also toggle button to scan enloyees by alpha name or number data pulled in from Excel data source..

will be fine..

Your question was hinting at Merger.. yes i beleive you can... suggest play and use wizards...