[mso] Populating a letter with info from Excel

From: "Kelly Arnold" <Kelly.Arnold@xxxxxxxxxxxxxxxx>
To: <mso@xxxxxxxxxxxxx>
Date: Tue, 6 Oct 2009 17:02:10 -0400
Hello!
 

Is it possible to add numerical information to a letter typed in either
Word or Excel where the information pulls from a data spreadsheet? I
would like to be able to set up a template (so to speak) where the copy
itself doesn't change, but with minor changes to certain cells, all
related numerical information is populated in the text.

 

I will try to explain better here:

 

I have a monthly reporting obligation, where copy does not change, i.e.
"Currently all regions combined have spent $XXXX on repairs." The text
is then detailed with numbers compared to budget, average cost per
repair, quantity of repairs, etc.

 

I would like to be able to use data from the master spreadsheet to
update all of the number fields in the text by simply changing the
reporting period.

 

Is this possible if I am writing in a sentence format? I know I can do
it if I can make sure by copy ends in such a way that I can link the
spreadsheet to the next empty cell. But that won't make for a very neat
report as it's not very likely the sentences  would all end at the same
spot. Can I embed the link in the sentence?

 

Thanks very much,

Kelly

 

 

Kelly Arnold

Assistant Director - Signage Services

 

Regal Entertainment Group

7132 Regal Lane

Knoxville, TN 37918

 

O: 865/925-9407

C: 865/406-9632

F: 865/925-9763

 

P Please consider the environment before printing this email


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
//www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************
[mso] Populating a letter with info from Excel

Other related posts:
