ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do I merge labels onto a seperate form letter ? (https://www.excelbanter.com/excel-discussion-misc-queries/66123-how-do-i-merge-labels-onto-seperate-form-letter.html)

terwanley

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 ?

Dave Peterson

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

Gord Dibben

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