I am a newbie at this and need to know if it is possible to do.
I have created a database (in 2003 and 2007) for dog shows which have 1 table (the main data imported from excel) then a number of queries to pull out info needed:
1. Handlers - includes handler and contact info
2. Dogs - includes Dogs and handler (1 handler, many dogs)
3. Dogs and Class - includes Dog, Handler and classes entered
I need to send an email to each handler telling them which classes their dog(s) are in and their running order so I created a form with 2 subforms. The main form is the Handlers detail and then there are 2 subform, one with the dogs they own and the 2nd with the classes etc they have entered. The forms are all linked to each form only shows the details for the one handler (I was please that I had managed to get this far )
When I export the form to Excel or Word all I get it the Handlers bit of the form not the other info so need to link all the subforms so they appear as well.
I think I have to use a VB script to send the email but do not have a clue as to how to go about it.