Automating mail merge

P

Patrick

Hi!

I apologize if this has been addressed before, but I couldn't find it.

I have a directory with 216 .xls files. Each of these files needs to be
merged with the same word mail merge document and the output named the same
name as the .xls file just with a different extension [.doc].

I have tried [and failed miserably] to write this in vb.

Any help would be appreciated.

Thank you!

Patrick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Directory Conditional Page Break 0
Merge Excel file into Word Document 3
Auto Merge text from multiple sources 0
Automating mail merge 3
Mail Merge skipping records/sending one at a time 0
Printing Mail Merge Slow 0
Grouping Names in Mail Merge 0
Naming issue on saved mail merge documents 0

Top