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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

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


"clickit" wrote in message
...
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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

thanks a lot for your quick answer

but
how can import a chart into this word document

thanks again



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Hi


"clickit" wrote in message
...
thanks a lot for your quick answer

but
how can import a chart into this word document


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

If you want a different chart for each person, you can follow the
instructions in the following thread:

http://groups.google.com/groups?&thr...20359%40speedy

clickit wrote:
how can import a chart into this word document

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html