Recent content by vnwallace

Is there a way to build that in to my code already or do I need to write it completely different? When looking through this code I am thinking that I will need to write it completely different than what I have so far.. hopefully not though! Thanks so much!

I actually got it to save where I want it to. Now I just need help splitting out the reports to indivuals and email to their corresponding email address. Below is my updated code: Private Sub EmailReport_Click() Dim stReport As String Dim stWhere As String Dim stSubject As String Dim...

Thank you! This is an amazing start! Below is my code.. I have a few issues.. -I need it to split out the reports and email to a corresponding address (stored in a table that the report gathers it's data from..the table is "Counterparty Data") -In my code I couldn't get my reports to save to...

Also, when looking at this code, I see something that might need to differ from mine. I need an email with the recipient/subject/body to pop up but not to send (we will manually push the send button).. Any ideas?

Thank you! Before I get started, do I create this using a Standard Module or a Class Module? I'm guessing class but I just wanted to verify before I start this.

Hi, I am working on an Access DB and I need to email individual reports to email addresses linked to the corresponding email. I would like these email to be sent though outlook and the attachment to be a PDF. Does anyone know how to help with this? Thank you! Valerie Wallace