By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,107 Members | 1,318 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,107 IT Pros & Developers. It's quick & easy.

E-Mail one record at a time to different address

P: n/a
how can i email one record at a time to different
email address from a form that has thousands of records behind it??

tks
larry
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"Larry" <la***@oxmail.com> wrote in message news:<99****************@news1.central.cox.net>...
how can i email one record at a time to different
email address from a form that has thousands of records behind it??

tks
larry


open a recordset based on the table(s) so that all the info you need
is in a single record in the resulting query. Then open that in code,
loop through the recordset, and pass the address etc info to Outlook
or whatever via automation. Look up outlook and automation in this
NG. This question has been asked and answered a zillion times.
Nov 12 '05 #2

P: n/a
"Larry" <la***@oxmail.com> wrote in message news:<99****************@news1.central.cox.net>...
how can i email one record at a time to different
email address from a form that has thousands of records behind it??

tks
larry


Larry,
how do you determine who gets what record mailed to him? (just
wondering...)

This is how you could automate the e-mails, but I think it needs some
serious tweaking to make it really useful.

http://support.microsoft.com/?kbid=161088

If everyone gets the same record/info, you could just Bcc them all.
(or in batches of like 20 addresses or something stupid.) otherwise,
if you're customizing your message to each recipient, then you could
build a message using a function. (Just easier to debug and
manage/understand if you break the task into manageable pieces!) If
you could explain a little more completely what you are after, I'm
sure someone could give you a more useful/concise answer.

hope this gets you started...
Pieter
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.