printing specific cells

[×ליר×]

Hello,

I think i have sufisticated question, so i would be glad to have an answer:

I'm gonna get married soon. i created an Excel worksheet of all the
participants, and now i'd like to print the names on envelopes. I don't want
to work too hard, i wanna print all the names automaticly.

For instance, if i have the name in colomn A, the address in column C, and
the postal code in the fifth column:

A C E
Joe Pink 210 W 70St. 10023

now, i wanna have only the names on the envelope, each name on each
envelope. for example, the details above will be written on the envelope,
seperated by new lines:

Joe pink
210 W 70St.
10023

Thanks a million.

 

[Bernard Liengme]

Do the printing from Word using the Excel as the data file
Merge (Excel - Word)
For help on Word mail merge using Excel as the data source have a look here

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

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

http://www.mvps.org/word/FAQs/MailMerge/CreateADataSource.ht
best wishes

 

[×ליר×]

Thanks Bernard,

Ok, right, i did it. However, what am i supposed to be now? i copied the
worksheet to Word, but am i doing with 600 names?

copy & paste 600 times? is there any automatic command to print each name on
each envelope? I mean, if i made a table, how do i print one row on one paper?

 

[Gord Dibben]

You don't copy the worksheet to Word.

You just use the workbook as the source data for the Word
Mailmerge>Envelopes and Labels.

All the printing is done from Word.

Please re-read one or more of the URL's Bernard posted.


Gord Dibben MS Excel MVP