Mail Merge to Discreet Documents 1

[CyLiGn]

I need to merge word documents, but would like to have it create separate documents for each row in the data set.

I know that this is possible in some freeware versions, but because it is a business document, I need to have word documents to send out.

Also, I would like to password protect each of the documents once they are saved. If it were possible to 'group protect' or something along those lines, it would certainly make my life easier.

I would appreciate any and all advice. I have pretty fair latitude to set up the data set and perform the merge in anyway that is necessary.

AtDhVaAnNkCsE!
CyLiGn

 

[PeterMoran]

Hi CyLiGn,

You might like to check out this excellent reference:

http://mvps.org/word/FAQs/MacrosVBA/index.html

and select Mailmerge - you will find a number of answers to questions, one of which is creating separate files.

HTH

Peter Moran
Two heads are always better than one!!

 

[CyLiGn]

Peter:

THANK YOU! That site is SO useful.

You are my hero of the week!

Sincerely,
CyLiGn

 

[riffer28]

I looked at the MVPS site and found it very useful. Howerever, do you know how to accomplish the same thing using ActiveX Data Objects (ADO) instead of DAO?