Mail Merge: Save every page with the value of cells in excel...

[SupperDuck]

Dear all,

I have a word document that takes values from an excel file.

In my excel file, there are 5 columns and the third column represents the
supplier code.

It takes values from the excel sheet and when i run mail merger, it gives me
about a document with 150 pages...

And then i manuelly split every ! page according the supplier code.

I want a code that makes it automatically.

The code will do something like that;

for 1 = 2 to 150 (would change to the number of suppliers)

Fill the linked places from excel file to word document
document name = suppliercode
save document
close document
next

The problem is i couldn't find a way to use excel from word macro

Can you please help me?

Regards..


PS: The automation is not have to do everything. I can open the document,
show the data adres. I just want it to save every page automatically with the
name of the supplier code...

 

[Doug Robbins - Word MVP]

See the "Individual Merge Letters" item on fellow MVP Graham Mayor's website
at:

http://www.gmayor.com/individual_merge_letters.htm

If you are using Word XP or later, the "Add-in to Merge Letters to Separate
Files" that I have written and that can be downloaded from that site will
allow you to create each letter as a separate file with a filename taken
from a field in the data source with a minimum of fuss.


--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP