Has anyone come across a way of just doing a mailmerge of for example, just 200 at a time ? There's about 20,000 records and don't really want to do them all at the same time.
Any help much appreciated.
Chris
Has anyone come across a way of just doing a mailmerge of for example, just 200 at a time ? There's about 20,000 records and don't really want to do them all at the same time.
Any help much appreciated.
Chris
You could just filter the data if you have an autonumber field.
Thanks JD, I don't have autnumbering. Would it cause a problem if I did it to a database that already had 1,000's of entries ?
I've never had a problem adding an autonumber field to a table but I can only honestly say this has been tested with around 15000 records.
You can always make a copy of the database add the autonumber and revert back if it causes issues.
Thanks, just trying to do that, have entered autonumbering and yes, no duplicates, but when trying to save it, it says indexes must have names ?
Try adding the autonumber but leave indexed as no
Thanks JD, that's done it. That parts complete now, but how do I 'tell' the mailmerge to only do, for example, records from 400 to 600 ?
You could do this 2 ways:
1. In the mailmerge in Word click the edit recipients section and do an advanced filter.
2. In your mailmerge query add the autonumber field and in the criteria put >= [Enter Starting Number] And <= [Enter Finishing Number]
This will add prompts so you can filter the data.
Many thanks JD, all solved. The helps been appreciated.![]()
No problem, happy to help![]()