ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Word merge with Excel data (https://www.excelbanter.com/excel-discussion-misc-queries/19147-word-merge-excel-data.html)

julie

Word merge with Excel data
 
I'd like to create a full sheet of labels from each row in my Excel sheet.
Using Word merge and the standard setup, I am only able to get one label per
row. Is there a way to set up the merge so I can get a full sheet (or
repeating labels) per record?

Gord Dibben

julie

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...RC010390291033


Gord Dibben Excel MVP

On Thu, 24 Mar 2005 15:01:04 -0800, "julie"
wrote:

I'd like to create a full sheet of labels from each row in my Excel sheet.
Using Word merge and the standard setup, I am only able to get one label per
row. Is there a way to set up the merge so I can get a full sheet (or
repeating labels) per record?




All times are GMT +1. The time now is 12:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com