I currently have database set up with so that the user types the first name, last name and persons email address into a form and then at the end of the day, they click a button that hyperlinks them the appropriate Word document to do an email merge. Is there a way that I can automate the process a little better and remove the hyperlink and just have the user click a button in Access without ever going directly to Word and sending out the emails? Sending the email as a snapshot of a report is not an option.
I will also need it to input the person's First and Last Name into the body according to what is in my table, similar to the <<Greeting Line>> function in Word's mail merge. I would also like to use Outlook to send the emails.