|Subject:||RE: Printing Mailing labels...already have full address in each cell|
|Posted by:||Dominic LeVasseur|
|Date:||Wed, 17 May 2006|
You can separate the name, address, etc of each entry so that the mail merge
can work properly.
You will need to use the Data:Text To Columns command on the toolbar. The
settings you will need to use depend on how the data looks in each cell. Try
the fixed width and see if that works for you.
> I have a spreadsheet, each cell has the name, address, etc.... all in each
> cell. Not name in one cell, address in another, and so on. When i try to
> use the mail merge with Word, it looks at it as all one sentance and cant
> seperate name from address and all being they are all in one cell per person.
> Since they are already put together, is it possible to print directly from
> excel and tile it to print on labels?
Printing Mailing labels...already have full address in each cell posted by Greg on Wed, 17 May 2006