Excel or Word

[MarkyP05]

Im looking to set up a template where by I would enter numerical values and text - calculations done on these values and then output into a pre-defined letter. Is this possible?

[ACtheTROLL]

everything is possible in time ...
in word it's difficult - in excel it's relatively simple

if the text is
Oranges bought 5
Oranges sold 3
Oranges in stock B3 = b1-b2

it's perfect for invoices where sticking to the boxes is acceptable

sorting words from numbers and calculating is a pig in word - and because you're asking if ... I guess that writing a macro isn't an option

[MarkyP05]

Ive managed to do what i've wanted on excel which is fairly basic - its just transfering that information into a template letter i.e.

excel (simple example)

A B
1. Purchased Price(wholesale) �0.35
2. Oranges at Open 50
3. Oranges at Close 35
4. Oranges Sold 15 (b2-b3)
5. Selling Price �0.50
6. Profit Margin �0.15 (b5-b1)
7. Days Profit �2.25 (b4 x b6)
8. Close Stock �5.25 (b5 x b3)

output (word/ letter?)

Dear Boss

We have managed to sell (b4) oranges today, this gives us a daily profit of (b7).

At close we have (b3) oranges left. At (b5) per orange this values the stock at (b8).

Regards

The above is kinda what im looking for.

Macro not really an option no.

[gen2]

What you need to investigate is setting up a mailmerge from Ms Word linking to your excel spreadsheet. I did this when I was working, but since retiring, I am using OpenOffice.Org at home so any explanation i could give now would be slightly different from how it would be done with Microsoft software.

I hope I have pointed you in the right direction.

[THECORBYLOON]

Could you not just do it as a simple table showing the numbers selt, the profit etc? Does the boss need to have in the form of a letter? If he does can you not just write out the words leaving a cell free for the appropriate figure and then adjust the cell width so that it looks okay? You can then highlight the area to be printed and then Robert is yir father's brother!

[ACtheTROLL]

right ... easy
the best way to explain is if you look at word's help
open help - type "embed object"

basically highlight the result in excel - copy

switch to word - paste special | MS office excel worksheet
the results will (should) update automatically
if not right click and update

if you save the word document as a template and use the same excel sheet it will be stress free

if you need a permanent record close word - use "Save As" in excel