Shadowwolf
Complete Novice
- Local time
- Today, 11:17
- Joined
- Jun 21, 2005
- Messages
- 17
Hi, Im not sure if this is possible or whether this has been mentioned in another place but I want to be able to send a form to a selectable person. At the moment I have a button on the form which runs a macro, in which is SendObject. The problem I have is that I want this macro to send the email to a person which is selected on the form.
I.e. I have a drop-down box listing the workers initials which are stored in a seperate table. Therefore when a person is selected from this list and the button is pressed I want the details in that form to be sent to the person that has been selected.
So what I want to know is if this is possible, how long it would take me to implement, and where I would store the details of each worker (currently I am thinking in the same table as the initials). So is there a way to look up a record and place that into the "To" area of the email.
Any help would be kindly appreciated.
Thanks
Shads
I.e. I have a drop-down box listing the workers initials which are stored in a seperate table. Therefore when a person is selected from this list and the button is pressed I want the details in that form to be sent to the person that has been selected.
So what I want to know is if this is possible, how long it would take me to implement, and where I would store the details of each worker (currently I am thinking in the same table as the initials). So is there a way to look up a record and place that into the "To" area of the email.
Any help would be kindly appreciated.
Thanks
Shads