Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Mail merge: trapping situation where no records to merge

Status
Not open for further replies.
Cads

Cads

Technical User
Jan 17, 2000
40
GB
Hi

Have set up a mail-merge using Access and Word 97 based upon MS Knowledgebase sheets Q159328 (Automation techniques) and Q199963 (Stopping another instance of Access using ODBC). All works fine when there are records to mail-merge. However, when there aren't any records I firstly get a MS Word message saying so but then I get an error message on returning to Access. Also the whole process tends to generate a 'fault protection' error in Word.

I'm trying to set up the mail-merge for others to use so I need to trap this 'zero record' situation efficently. Has anyone had any experience with this and so can provide me with a cool solution, please?

Steve House
 
Status
Not open for further replies.

Similar threads

ameedoo3000
  • Locked
  • Question
Clear all table contents without deleting records
Replies
15
Views
1K
ameedoo3000
ameedoo3000
YoBi4Ever
  • Locked
  • Question
I would like to compute how many minutes or hours the employee left work by comparing two records
Replies
3
Views
404
dhookom
dhookom
Bubba002
  • Locked
  • Question
WHERE clause in the Set command of an db.OpenRecordset method
Replies
16
Views
1K
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
5K
TheresAlwaysAWay
TheresAlwaysAWay
renigar
  • Locked
  • Question
Access 365: Search LastName in one table to put EmployeeID in another
Replies
8
Views
1K
renigar
renigar

Part and Inventory Search

Sponsor

Back
Top