[[email protected]]

Hi all,

I'm facing this problem.

I have an Excel file with 7000 lines and I have to produce 7000 .doc
files with some of these information.
I have a word template to fill with some variable of the Excel file.

I'm using Mail Merge but I'm only able to create a document with 7000
pages correctly formatted instead of 7000 files.

I need to create 7000 files and saving them (the name of the file
saved is one of the Excel's variable).

Any ideas?

Thanks in advance

[Graham Mayor]

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

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



wrote:
Hi all,

I'm facing this problem.

I have an Excel file with 7000 lines and I have to produce 7000 .doc
files with some of these information.
I have a word template to fill with some variable of the Excel file.

I'm using Mail Merge but I'm only able to create a document with 7000
pages correctly formatted instead of 7000 files.

I need to create 7000 files and saving them (the name of the file
saved is one of the Excel's variable).

Any ideas?

Thanks in advance

[[email protected]]

On 9 Apr, 16:22, "Graham Mayor" wrote:
Seehttp://www.gmayor.com/individual_merge_letters.htm

--

Graham Mayor - *Word MVP

My web sitewww.gmayor.com
Word MVP web sitehttp://word.mvps.org




wrote:
Hi all,

I'm facing this problem.

I have an Excel file with 7000 lines and I have to produce 7000 .doc
files with some of these information.
I have a word template to fill with some variable of the Excel file.

I'm using Mail Merge but I'm only able to create a document with 7000
pages correctly formatted instead of 7000 files.

I need to create 7000 files and saving them (the name of the file
saved is one of the Excel's variable).

Any ideas?

Thanks in advance- Nascondi testo tra virgolette -

- Mostra testo tra virgolette -

Thanks Graham,
after posting I found your site and I was reading your code which
solve my problem!
Another (maybe) question: it's possible doing the same thing but
saving it in .pdf file (print to pdf)?

Thanks a lot in advance.
Teo

[Graham Mayor]

Thanks Graham,
after posting I found your site and I was reading your code which
solve my problem!
Another (maybe) question: it's possible doing the same thing but
saving it in .pdf file (print to pdf)?

Thanks a lot in advance.
Teo

You didn't read the page very thoroughly
The add-in (which works with Word XP to 2007) will output to PDF or document

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org

[[email protected]]

ooops! :-)
I'll have a look!

Thanks again
Teo