Hi everyone. I think this one should be easy, but I haven't been able to find a specific example by searching online.
I have a continuous form which filters records from a couple txt and combo boxes. One of the fields contains email addresses. What I want is to create a button which allows me to open an Outlook email and paste all of the SELECTED records' emails into the To: field.
For example: Let's say I run a muffin business. The form allows me to filter my muffin sales to view # sold per customer by Muffin-Type and #Days since today (two txt boxes and a cmd button to apply the filter). The last field displayed is the email for each customer. I decide to filter down to Blueberry Muffins in the last 30 days, and get a list of 20 different customers. The top 3 customers have purchased 20, 15, and 14, so I want to select those lines and email all 3.
The records show CustomerID, CustomerName, #Sold, State, and Email
I want to be able to select the top 1, 2, 3, etc customers (using the normal records selection option), then click an "Email Customers" cmd button to open a new Outlook email, which automatically pastes their emails into the To: field, and have a Subject and Body already filled (maybe a message telling those customers that blueberry muffins are on sale).
I hope there is a way to do this using the Record Selection on the left side, because I think it's easier for an end-user. But I would consider creating a Selected field as well. Any suggestions? I want to avoid VBA as much as possible, simply because I'm still learning the program, but I can apply it where needed. Remember: the only relevant field here is the Email field in the continuous form, where I want to copy several emails from the filtered query and paste them into a new Outlook email. (Access 2010)
Thanks ahead of time for the help!