Is it possible to email just a certian amount each time ?

[_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

[SoftwareMatters]

You could just filter the data if you have an autonumber field.

[_Chris_]

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 ?

[SoftwareMatters]

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.

[_Chris_]

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 ?

[SoftwareMatters]

Try adding the autonumber but leave indexed as no

[_Chris_]

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 ?

[SoftwareMatters]

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.

[_Chris_]

Many thanks JD, all solved. The helps been appreciated.

[SoftwareMatters]

No problem, happy to help