Word/Mail Merge - One page in file

[shaggy31]

Hi,

I'm trying to do a Work order that will be mail merged from Excel. As it can be in Excel more data (Rows) I need it to be devided as one page per word file.
Also I would like that files are automaticly saved by specific name from data which is already in the word document (and Excel table).

Here is an example of table:

[TABLE="class: grid, width: 966"]
[TR]
[TD="align: center"]A
[/TD]
[TD="align: center"]B[/TD]
[TD="align: center"]C[/TD]
[TD="align: center"]D
[/TD]
[TD="align: center"]E[/TD]
[TD="align: center"]F[/TD]
[TD="align: center"]G[/TD]
[TD="align: center"]H[/TD]
[TD="align: center"]I[/TD]
[TD="align: center"]J[/TD]
[/TR]
[TR]
[TD="align: center"]WorkOrder
[/TD]
[TD="align: center"]Merchant
[/TD]
[TD="align: center"]Merchant_Contact_Person[/TD]
[TD="align: center"]Phone[/TD]
[TD="align: center"]Store_name[/TD]
[TD="align: center"]Store_ID
[/TD]
[TD="align: center"]Adress[/TD]
[TD="align: center"]City[/TD]
[TD="align: center"]Store_Contact[/TD]
[TD="align: center"]Store_Phone
[/TD]
[/TR]
[TR]
[TD="align: center"]RN-20140129-125[/TD]
[TD="align: center"]aaaa[/TD]
[TD="align: center"]wwww[/TD]
[TD="align: center"]1235[/TD]
[TD="align: center"]aaaa 1[/TD]
[TD="align: center"]88956[/TD]
[TD="align: center"]Adress 1[/TD]
[TD="align: center"]City[/TD]
[TD="align: center"]gggg[/TD]
[TD="align: center"]5655[/TD]
[/TR]
[TR]
[TD="align: center"]....[/TD]
[TD="align: center"]....[/TD]
[TD="align: center"]....[/TD]
[TD="align: center"]....[/TD]
[TD="align: center"]....[/TD]
[TD="align: center"]....[/TD]
[TD="align: center"]....[/TD]
[TD="align: center"]....[/TD]
[TD="align: center"]....[/TD]
[TD="align: center"]....[/TD]
[/TR]
[/TABLE]


The files should be named " 'WorkOrder'_'Store_ID'_'Store_name'_'City'.doc "

I'm a Beginner/Intermediate user of Excel/Word and I don't know nothing about VBA programing, so I would like your help.
I don't know if you need a word tamplate. It is all done in Office 2013.
Is this possible?
Please help me.

Shaggy

 

[Macropod]

have you looked at any of the code that's been posted (some of it very recently) in this forum?

 

[shaggy31]

Hi,

I looked but I didn't found anything...

Shaggy

 

[Macropod]

I looked but I didn't found anything...

There's two threads on the first page of this very forum! See: General Excel Discussion & Other Questions