Hi, I need help with mail merging

  • Thread starter Thread starter kamchor
  • Start date Start date
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
 
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...
 
you can also "double" click in the cell and paste directly in to the cell.
Everything will go into the same cell.
 
Back
Top