Excel merge files that work like Word merge files

  • Thread starter Thread starter Rick
  • Start date Start date
R

Rick

I use Word to make several hundred different forms
(letters & documents)that contain data merged from an
Excel database file. I find that I need to use an Excel
file to make some forms and it will be a big help if I
can merge information from the Excel database file, but I
can't find any info on how to do that. Does anyone know
how to make an Excel file work like a Word merge fle
using an Exce database (separate) file?
 
Excel doesn't have an equivalent to Word's Mail Merge Wizard. You could
use code to loop through all the items in your list, and print a copy of
the sheet for each item.
 
Thank you Debra,
That sounds like it will take more time than I can allow
a learning curve to take, so I'll pass on trying that. I
thought it would be easy using vlookup across files, but
I couldn't make that work, even using multiple sheets in
the same workbook. Do you know how to make vlookup work
when trying to pull something from a separate file?
Rick
 
Back
Top