[cowplopmorris]

That's absolutely fine. I wouldn't have thought the records would grow above a few 1000 so I should be able to set it with a bit of leeway and it should do.

Thanks so far.

Now I'm trying to get the other part of the question to work, emailing only the current record. I think I should be able to just stick something in the onClick line, but I'm not quite there yet..

Something like:

=FollowHyperlink("mailto:" & ThisRecord.[email])

But I'm not sure how to actually make it use the email of the current record.

Any ideas? Or will it be fairly complex?

[Keebellah]

I see you got the idea. Good thinking.
The 2nd part: if you know the correct record is selected than your code should do the thing.
Happy coding.

[cowplopmorris]

Hi,
I completely made up the function ThisRecord!! Any ideas what the actual thing is?
Thanks.

[Keebellah]

Send me your new version and I will look into it.
I can't garantee an answer inside the hour but I'll get back to you once I receive your copy

[cowplopmorris]

Thanks

Congratulations on reaching your 100th post by the way

[cowplopmorris]

Yes! Got it! All I had to do was create a new sub with:

FollowHyperlink ("mailto:" & Me.email)

That simple. I never knew about the "Me" function.

[Keebellah]

Well, you found it.
If it's solved you should mark it solved.
Happy coding.