MS Excel-Approach Merge

[bmor]

I have a simple Approach database set up with such fields as user id, name, address, city/state, zip and pin number.
I also have an Excel spreadsheet with user id, original confirmation number and new confirmation number. I need to retrieve the mailing info from Approach database using the info from the spreadsheet and populate a form letter using info from both except the pin number. What's the easiest way to accomplish this?

 

[suesloan]

I would do it this way. Define a new table with the same fields as the Excel spreadsheet and join it to your other database on the "user id" field.

Import the spreadsheet into the new table. You can now put information from both of the databases into a form letter.

Sue Sloan