Hi
I am quite new to VBA and half my problem is not knowing what i should be googling to get the right answers.
I have successfully created a subroutine which creates a record set, in this case a set of items someone is booking out under a hire id number and then emails that list to the person booking those items out.
I now want to go one better and send reminders of what people have booked out, so i will be doing exactly the same thing but this time the items in my record set are going to belong to different people, so some how i will need to filter by each person, send them a message and then repeat for the next person.
Any idea how i may do this? At it's simplest the fields will be:
Item key (the thing they have booked out)
Hire ID (items are listed under the hire id's)
Person name
Person email
Hope this makes sense and you will be able to help me out on this one, as always your help id very much appreciated.
Thanks
Jon
I am quite new to VBA and half my problem is not knowing what i should be googling to get the right answers.
I have successfully created a subroutine which creates a record set, in this case a set of items someone is booking out under a hire id number and then emails that list to the person booking those items out.
I now want to go one better and send reminders of what people have booked out, so i will be doing exactly the same thing but this time the items in my record set are going to belong to different people, so some how i will need to filter by each person, send them a message and then repeat for the next person.
Any idea how i may do this? At it's simplest the fields will be:
Item key (the thing they have booked out)
Hire ID (items are listed under the hire id's)
Person name
Person email
Hope this makes sense and you will be able to help me out on this one, as always your help id very much appreciated.
Thanks
Jon
