Thread: Letter format
View Single Post
  #3   Report Post  
David McRitchie
 
Posts: n/a
Default

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.