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.

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/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...ADataSource.ht
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"?????" wrote in message
...
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.

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?

"Bernard Liengme" wrote:

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/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...ADataSource.ht
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"?????" wrote in message
...
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.

You don't copy the worksheet to Word.

You just use the workbook as the source data for the Word
MailmergeEnvelopes 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


On Wed, 7 Jan 2009 11:32:08 -0800, ????? wrote:

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?

"Bernard Liengme" wrote:

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/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...ADataSource.ht
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"?????" wrote in message
...
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.