Mailing labels using Excel

T

terri

Can anyone tell me why I can't get my mailing labels from
excel to work in word? Is there anyway to do mailing
labels out of excel without word?

Please help.

[email protected]
 
P

Paul

terri said:
Can anyone tell me why I can't get my mailing labels from
excel to work in word? Is there anyway to do mailing
labels out of excel without word?
Click to expand...

Only by writing a macro using VBA.
What's the problem when you try to mail merge into Word?

Try a simple example to get you going - two or three columns, and just a few
rows of data. The columns need headers in row 1, which will be the field
names in Word when you insert mergefields. Create and save this simple Excel
file first. Then go to Word and call up this file as the data source. The
field names will then be available for you to insert.

Post back with the specific problem if you still have trouble.
 
D

David McRitchie

Hi Paul,
Excel does not support labels, and Microsoft expects you to
use MS Word with Excel as the database when you want to
print labels from data in Excel. Since you have both you
shouldn't have a problem. Take a look at my webpage
on Mail Merge
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

If you didn't have MS Word then you can look in the #Related
area at the bottom of the above web page.

The biggest stumbling block with Mail Merge is not having
the spreadsheet as the first spreadsheet in the workbook.

Frequently people have similar data in different sheets,
and wonder why it almost works but doesn't have their
latest changes, etc. -- because it is not the 1st worksheet.
 
Top