Letter format
 

I need to produce a business letter quoting some of the
calculations from an Excel sheet. Produced the
spreadsheet OK but have been told there is a good way to
automatically produce this quote letter. Can anyone point
me in the right direction.
Thanks

Look up "About Data Merge" in Word Help, then check out

http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm




In article ,
"Ratowl" wrote:

I need to produce a business letter quoting some of the
calculations from an Excel sheet. Produced the
spreadsheet OK but have been told there is a good way to
automatically produce this quote letter. Can anyone point
me in the right direction.

Hi Rat Owl, (real names are a lot more friendly)
Is this a single letter or one letter to be generated for each
row in a worksheet. If the latter you would use Mail Merge in
MS Word. You can pick up the basics on my Mail Merge page which
is designed for printing labels.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

but since it is for a letter you might want to start with a page
more oriented to Word by others.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm#more

You might also take a look at a couple of links about sending
data from Excel to MS Word (not Mail Merge)
http://www.mvps.org/dmcritchie/excel...rg.htm#control
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Ratowl" wrote ...
I need to produce a business letter quoting some of the
calculations from an Excel sheet. Produced the
spreadsheet OK but have been told there is a good way to
automatically produce this quote letter. Can anyone point
me in the right direction.

Qutie possible that RatOwl is poster's real name.

As in Alfred E. RatOwl

Gord

On Sat, 4 Dec 2004 13:32:42 -0500, "David McRitchie"
wrote:

Hi Rat Owl, (real names are a lot more friendly)
Is this a single letter or one letter to be generated for each
row in a worksheet. If the latter you would use Mail Merge in
MS Word. You can pick up the basics on my Mail Merge page which
is designed for printing labels.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

but since it is for a letter you might want to start with a page
more oriented to Word by others.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm#more

You might also take a look at a couple of links about sending
data from Excel to MS Word (not Mail Merge)
http://www.mvps.org/dmcritchie/excel...rg.htm#control
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Ratowl" wrote ...
I need to produce a business letter quoting some of the
calculations from an Excel sheet. Produced the
spreadsheet OK but have been told there is a good way to
automatically produce this quote letter. Can anyone point
me in the right direction.