Excel to Word document

  • Thread starter Thread starter clickit
  • Start date Start date
C

clickit

Hi to all,

here is what i want to do
i want to create a Word document
which has in it letters for each person
i have the person's data in an Excel file

for example

[Excel file]
SurName Name Euros
Smith Adam 1000
John Lock 140

[Word Document]
Dear Mr. Smith

--- page break ---
Dear Mr. John

--- page break ---
Dear Mr. <Excel column Name>

and here is the difficult one
i also want to include a chart, pie, in the word document
created with euros column

i would appreciate any help

thanks in advance
 
Hi

In Word is a Mail Merge feature (Tools.MailMerge). There you get exactly
what you want (set data source to your Excel document). In addition, you can
print labels or envelopes, or instead creating word document with letters,
you can print them directly, or generate mail letters.

About Excel table you use as source:
1. All data for one letter must be on single row
2. The table must have header row
3. The table must be continuous
4. It's best when it's single-sheet workbook. Otherwise, the sheet with
source table has to be first.

Arvi Laanemets
 
thanks a lot for your quick answer

but
how can import a chart into this word document

thanks again
 
Hi


clickit said:
thanks a lot for your quick answer

but
how can import a chart into this word document
Click to expand...


Open main document and make enough room on it for chart. Switch to Excel
file with chart and copy the chart. Switch back to Mail Merge main document,
and select from menu Edit.PasteSpecial.Paste.Picture(Enchanced Metafile).
Drag the chart to proper location, and resize it when needed. OK. Create new
letters.
(Using Metafile is reasonable, as it uses considerably less storage space,
as implementing the whole excel document into every letter. And don't use
links - otherwise addressates will have problems)


Arvi Laanemets
 
Back
Top