Excel spread sheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Shirley Morgan - 30 Sep 2003 18:38 GMT

I want to set up a spread sheet using column 1 to insert a
name and address with puncutation, i.e.
Mr. F. Bloggs,
Noddy House,
Big Ears Lane,
Mr. Plod Parish,
Toytown

I then want to be able to cut and paste this address to an
invoice in Word, is this possible?

Thank you.

Regards
Shirley Morgan

Reply to this Message

Gord Dibben - 01 Oct 2003 02:19 GMT

Shirley

Is it possible? Yes. Have you tried it? Obviously not.

You might be better off to set up your Excel sheet as a source for a Word
Mailmerge with fields for your Invoice.

Have your titles such as Name, Address, City, State, Zip in separate columns
in row 1.

Then each client on its own row across these columns.

For mailmerge tips see David McRitchie's site.

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

Gord Dibben Excel MVP XL2002

>I want to set up a spread sheet using column 1 to insert a
>name and address with puncutation, i.e.
[quoted text clipped - 11 lines]
>Regards
>Shirley Morgan

Reply to this Message