Hello all - I'm a relatively new Access user. I had training last month (3 classes, basic to advanced) and I've been working on my database creation skills for a few weeks. My boss recently gave me a larger project to create a DB for and I need some help with one of the features I'm building in.
I work for a doctor, and the database is to assist with surgery scheduling. I have a form in the database with a large number of fields. One field is a combo box which pulls from a table with medical device reps' contact information. When you select the device name, four other fields populate the rep name, company name, rep phone number, and rep email address. Next to this, I have placed a command button.
I want the user to be able to click the command button, which will open Outlook (if not already open, which it usually is), create a new mail message, and pre-populate that particular rep's email address in the To: field, plus some kind of general subject like "RWP Office Scheduling Notification" in the Subject: line.
I've tried searching a number of forums to get an answer for this, but I can't find any kind of code or macro that I could modify to fit my particular use case. Bear in mind that my VBA skills are basic, but I'm really good at copy-and-paste .
Can anyone please help me? Thanks in advance!