J
jjyooi
I have an excel spreadsheet with several fields, such as name, address,
etc. In this spreadsheet, I also have a template name, which is the
document I want the persons details to be printed on (one for Europe,
on for US, one for HK, etc.)
Is there anyway in Word that I can say "take this spreadsheet, and do a
mail merge using the form letter documents in Column X"? All form
letters have the same fields, but with different text.
Essentially, the spreadsheet would say "Joe Bloggs lives at 123 Some
Road, and these details need to be printed using template A. Jon Doe
lives at 125 Some Road, and these details need to be printed using
template B." So what should come out is a page with Jon Bloggs'
details, mail merged using template A, then a page with Jon Doe's
details, mail merged using template B.
I can do this manually, but it would take ages, and I wondered if there
was a faster way?
Any help or advise would be greatly appreciated.
etc. In this spreadsheet, I also have a template name, which is the
document I want the persons details to be printed on (one for Europe,
on for US, one for HK, etc.)
Is there anyway in Word that I can say "take this spreadsheet, and do a
mail merge using the form letter documents in Column X"? All form
letters have the same fields, but with different text.
Essentially, the spreadsheet would say "Joe Bloggs lives at 123 Some
Road, and these details need to be printed using template A. Jon Doe
lives at 125 Some Road, and these details need to be printed using
template B." So what should come out is a page with Jon Bloggs'
details, mail merged using template A, then a page with Jon Doe's
details, mail merged using template B.
I can do this manually, but it would take ages, and I wondered if there
was a faster way?
Any help or advise would be greatly appreciated.