software

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?


This should be a standard process.If I understand you correctly, you
have each field of your address in a distinct cell...is that correct?

ie...
cell a1 Mary Jones
cell b1 123 Main St
c1 anytown, Maine 08888

If not how is you data arranged?

plettieri--
plettieri
------------------------------------------------------------------------
plettieri's Profile: www.excelforum.com/member.php...oamp;userid=34531
View this thread: www.excelforum.com/showthread...hreadid=542914Greg,

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.

HTH

quot;Gregquot; wrote:

gt; I have a spreadsheet, each cell has the name, address, etc.... all in each
gt; cell. Not name in one cell, address in another, and so on. When i try to
gt; use the mail merge with Word, it looks at it as all one sentance and cant
gt; seperate name from address and all being they are all in one cell per person.
gt;
gt; Since they are already put together, is it possible to print directly from
gt; excel and tile it to print on labels?

the file was sent to me already created this way...

in one sell...say A1...i have the name. under that is street address.
under that is city state and zip. All this in one cell. in A2 will be a new
label and so on. I didnt relalize you could have multiple lines in a single
cell but i guess you can. So it seems to me everything is formatted
perfectly. I just need to get them to print out on a tiled label sheet

quot;plettieriquot; wrote:

gt;
gt; This should be a standard process.If I understand you correctly, you
gt; have each field of your address in a distinct cell...is that correct?
gt;
gt; ie...
gt; cell a1 Mary Jones
gt; cell b1 123 Main St
gt; c1 anytown, Maine 08888
gt;
gt; If not how is you data arranged?
gt;
gt; plettieri
gt;
gt;
gt; --
gt; plettieri
gt; ------------------------------------------------------------------------
gt; plettieri's Profile: www.excelforum.com/member.php...oamp;userid=34531
gt; View this thread: www.excelforum.com/showthread...hreadid=542914
gt;
gt;


Hi:

You might try this:

1. execute this macro to remove unwanted line returns.

Sub RemoveReturns()
Cells.Replace Chr(10), quot;;quot;
End Sub2. Data \ Text to columns and select the delimiter quot;;quot; options

This should break the address fields down to managable fields for the
Mail merge function....

Hope this helps
plettieri--
plettieri
------------------------------------------------------------------------
plettieri's Profile: www.excelforum.com/member.php...oamp;userid=34531
View this thread: www.excelforum.com/showthread...hreadid=542914