Hi, I need help with mail merging

K

kamchor

I want the following to come up in the same Cell, and this the format im
pasting below.

A C GLOBAL CAPITAL INC
4530 WEST BUCKINGHAM
GARLAND, TX 75042


but when i paste it into an excel cell, each line goes into a different
colum [cell].
Is there a way to get the whole address into one Cell, and in the
format i posted above. Btw, this is for merging mail.

Thanks in advance
 
D

Debra Dalgleish

To paste the entire address into the same cell --

Select the cell
Click in the Formula bar
Click the Paste button

However, you should be able to use an address in different cells as the
source for a mail merge. For example, if your address list is:

Company Street City State Zip
A C GLOBAL CAPITAL INC 4530 WEST BUCKINGHAM GARLAND TX 75042

you can use those columns as fields when you do a Mail Merge in
Microsoft Word. There's information on the Word MVP site:

http://www.mvps.org/word/FAQs/MailMerge/CreateAMailMerge.htm

And David McRitchie has instructions on his web site:

http://www.mvps.org/dmcritchie/excel/mailmerg.htm


I want the following to come up in the same Cell, and this the format im
pasting below.

A C GLOBAL CAPITAL INC
4530 WEST BUCKINGHAM
GARLAND, TX 75042


but when i paste it into an excel cell, each line goes into a different
colum [cell].
Is there a way to get the whole address into one Cell, and in the
format i posted above. Btw, this is for merging mail.

Thanks in advance
Click to expand...
 
G

Greg

you can also "double" click in the cell and paste directly in to the cell.
Everything will go into the same cell.
 
Top