Hi Richard,
Quote:
quote:Can anyone recommend a book that covers controlling a Word Mail Merge with VBA?
|
On the Mail Merge part of your question, Helen Feddema is someone who has spent a great deal of time working with just about every type of Office Automation you can think of. You might find some of her sample databases useful. She has one in particular that I've played with a bit that demonstrate four different techniques for merging to Word. Of the four, mail merge is her least preferred. Custom doc properties are preferred for creating letters, and the TypeText methos is preferred for labels and cards.
The link to "Merging to Word Four Ways" is:
http://www.helenfeddema.com/CodeSamples.htm
Look under Acces -> Word: VBA sample #24.
Helen also has published several Access Archon articles addressing merging from Access to Word. They are at:
http://www.helenfeddema.com/access.htm
Look at:
#39 - Creating Word Custom Doc Properties
#44 - Merging to Word from Linked Access Tables
#65 - Working with the Word Object Model
#92 - Mail Merge Mysteries
See also has a number of articles with sample dbs for a variety of e-mail issues.
Might give you some ideas.
HTH,
Bob