L
Lumpy
I'm responsible for tracking all our silent auction prizes for our annual
fundraiser. I'm am Access rookie but I've sent the light of databases for
list management. I've set up 3 tables; a membership list of our club with
names, phone #'s and email fields, a prize list with prize, Rotarian ID,
Donor ID, value..., and a Donor list with donor business contact info. I've
got them related properly so I can query all differnet information. Pretty
cool!
Problem is that many Rotarians have turned in their prizes with fields
missing on their paper form that they submitt. Stuff like Donor mailing
address or prize location. I'd like to send out emails to each Rotarian who
turned in a prize where a field is blank asking them to provide hte missing
information. I have the Rotarian email in a field of hte Membership table.
Anyone know how to do this?
fundraiser. I'm am Access rookie but I've sent the light of databases for
list management. I've set up 3 tables; a membership list of our club with
names, phone #'s and email fields, a prize list with prize, Rotarian ID,
Donor ID, value..., and a Donor list with donor business contact info. I've
got them related properly so I can query all differnet information. Pretty
cool!
Problem is that many Rotarians have turned in their prizes with fields
missing on their paper form that they submitt. Stuff like Donor mailing
address or prize location. I'd like to send out emails to each Rotarian who
turned in a prize where a field is blank asking them to provide hte missing
information. I have the Rotarian email in a field of hte Membership table.
Anyone know how to do this?