#1   Report Post  
Ratowl
 
Posts: n/a
Default 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   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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   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.



  #4   Report Post  
Gord Dibben
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Format numbers in chart datatable MB Charts and Charting in Excel 3 May 29th 05 03:37 PM
pivot chart format Valeria Charts and Charting in Excel 1 January 14th 05 02:19 PM
format one data series, with error bars, and use it as default JBR Charts and Charting in Excel 2 January 9th 05 05:03 PM
Conditional format rexmann Excel Discussion (Misc queries) 4 December 2nd 04 01:01 PM
nunber format in Excel 2000 Erle Excel Discussion (Misc queries) 3 November 30th 04 08:27 PM


All times are GMT +1. The time now is 10:55 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"