Access to Word Automation
Posted on 2003-11-17
Most of my experience in automating word from access has been using bookmarks and populating the contents of a single document with the contents of one record. However I now have the need to do this on a mass basis. That is, instead of one record at a time, it may be between 50 and 700 at a time. Any time I have needed to do multiple records like this, I have done a mail merge manually. I am wondering if the same methods I use with bookmarking with a single record can be reused when Im doing multiple records, or should I set this up as a mail merge instead. Ideally I would like to set up the code so it can be used in any scenario. The source for this merge will be a query, select statement, or recordset. The document will be a one page word document with bookmarks or merge fields(whichever is necessary). I need the results to reside in one word document. Any thoughts/examples on this process would be appreciated. I realize this question is vague, but I think I need more help on the general direction and concepts of this operation than the actual code writing.