Hello, all -
I've just built a database in Access, and had a request come up from the end users. I think this is possible, but I'm not sure of the easiest way to go about it. What they want is for the body of chosen emails in MS Outlook to be saved in a record in their Access database. This could happen in one of two ways:
1.) Opening Outlook with a command button on a form in Access, having the record on screen determine automatically who the email recipient would be (and populate the To: field accordingly), and then, once the user has typed an email and sent it, having the text of the email recorded in a field within that same Access record, OR
2.) As in the previous scenario, the user could open Outlook with a command button on a form in Access, and have the record on screen determine automatically who the email recipient would be (and populate the To: field accordingly). The difference would be that the user would've already written out the body of the email in the Access record, which would then populate the body of the email automatically.
The difference is that in the first way Outlook populates an Access record, and in the second example, the Access record populates an Outlook email. Either way would be great.
Does anyone have any idea as to how to set up either of these scenarios?
Thanks a lot for any help anyone can offer.
Spherey
I've just built a database in Access, and had a request come up from the end users. I think this is possible, but I'm not sure of the easiest way to go about it. What they want is for the body of chosen emails in MS Outlook to be saved in a record in their Access database. This could happen in one of two ways:
1.) Opening Outlook with a command button on a form in Access, having the record on screen determine automatically who the email recipient would be (and populate the To: field accordingly), and then, once the user has typed an email and sent it, having the text of the email recorded in a field within that same Access record, OR
2.) As in the previous scenario, the user could open Outlook with a command button on a form in Access, and have the record on screen determine automatically who the email recipient would be (and populate the To: field accordingly). The difference would be that the user would've already written out the body of the email in the Access record, which would then populate the body of the email automatically.
The difference is that in the first way Outlook populates an Access record, and in the second example, the Access record populates an Outlook email. Either way would be great.
Does anyone have any idea as to how to set up either of these scenarios?
Thanks a lot for any help anyone can offer.
Spherey