Excel to Word

[bengaluru]

Hi,

I have an Excel calculation sheet. the results of which are
communicated to my clients by way of a letter. I am using Excel to
generate this letter as all the numbers automatically populate to my
letter worksheet. Everything looks fine except that I dont like the
way the letter looks. It does not look very professional as I cannot
justify my paragraphs in Excel.

I was thinking if there is any way I keep the letter template on my MS
Word and the numbers get automatically populated on to Word, so that
the final letter would look more professional.

I am not sure if I have made myself clear. Let me know if you have any
questions. Thanks for all your help.

Take care Guys......You are the best.

 

[MrShorty]

You can copy the data in Excel and then Edit->Paste Special->Paste as
Link in Word.

Does that help?

 

[Ed]

You might want to check out Word's Mail Merge functionality. It allows you
to do just that - take a spreadsheet pf data and merge it into form letters.

Or you could have a letter "boiler plate" in Word with all your programming
there, so that when the code is run within Word it pulls the data into the
letter at designated places in formatted paragraphs. You can even have it
cycle down a lit of client names to personally address each one. (Although
that's what Mail Merge does.)

HTH
Ed