Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Format numbers in chart datatable | Charts and Charting in Excel | |||
pivot chart format | Charts and Charting in Excel | |||
format one data series, with error bars, and use it as default | Charts and Charting in Excel | |||
Conditional format | Excel Discussion (Misc queries) | |||
nunber format in Excel 2000 | Excel Discussion (Misc queries) |