Aaron
Goonsquad Officer
- 9,374
- 22,859
Didn't find a topic that this might be relevant in, so I thought I'd create an MS Office help topic, as I have a problem I need help with.
The thing is I need to send out a letter to a bunch of people, and while each letter is largely the same, there are certain fields that change (name, address, etc). I have an excel sheet where each column has this info. Now I have a hunch that it is possible to write a Word template where all the changeable text are actually some type of field that are then linked with a column in an excel sheet, and when sent to the printer it automatically prints out the info one row per word document, thereby saving me the trouble of having to copy paste info for 50+ letters.
The question is, does anyone know how to do this, or have links to sites that show you how? I haven't been able to find anything good via Google, mainly because I probably don't even know what terms to look for.
TIA
The thing is I need to send out a letter to a bunch of people, and while each letter is largely the same, there are certain fields that change (name, address, etc). I have an excel sheet where each column has this info. Now I have a hunch that it is possible to write a Word template where all the changeable text are actually some type of field that are then linked with a column in an excel sheet, and when sent to the printer it automatically prints out the info one row per word document, thereby saving me the trouble of having to copy paste info for 50+ letters.
The question is, does anyone know how to do this, or have links to sites that show you how? I haven't been able to find anything good via Google, mainly because I probably don't even know what terms to look for.
TIA
