how do I merge labels onto a seperate form letter ?
i using excel 2003; i have a form letter to send to about 120 individuals; i
have names and addresses as labels in columns A & B in my spreadsheet. how do i take names and addresses from excel and insert each into my Word generated letter ? |
how do I merge labels onto a seperate form letter ?
Here are a couple of links:
http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMerge The first is from David McRitchie and the second is by Beth Melton and Dave Rado. terwanley wrote: i using excel 2003; i have a form letter to send to about 120 individuals; i have names and addresses as labels in columns A & B in my spreadsheet. how do i take names and addresses from excel and insert each into my Word generated letter ? -- Dave Peterson |
how do I merge labels onto a seperate form letter ?
For help on Word mail merge using Excel as the data source.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm http://www.mvps.org/word/FAQs/MailMe...DataSource.htm And a training tutorial for creating envelopes and labels. http://office.microsoft.com/training...tID=RC01039029... Gord Dibben Excel MVP On Thu, 19 Jan 2006 08:47:04 -0800, terwanley wrote: i using excel 2003; i have a form letter to send to about 120 individuals; i have names and addresses as labels in columns A & B in my spreadsheet. how do i take names and addresses from excel and insert each into my Word generated letter ? Gord Dibben MS Excel MVP |
All times are GMT +1. The time now is 04:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com