Search results

Hi, Background – I want to send an email to multiple recipients based on the query results I receive. I’ve managed to put together some code that sends an email which blind copies in the multiple recipients, enters a ‘From’ email address and places an attachment into the email. This works...

Re: Add Attachment to Email in VBA - SOLVED! Eureka! Thanks for your help darbid, please see working code below Private Sub email_exp1_Click() Dim MyDb As DAO.Database Dim rsEmail As DAO.Recordset Dim qdf As DAO.QueryDef Dim prm As DAO.Parameter Dim strEmail As String Dim strMsg As String...

Thanks darbid that makes sense however I still get the compile error End If without block If even after a few changes see below. Please forgive me if a make some silly errors I'm still getting used to VBA. Private Sub email_exp1_Click() On Error GoTo Err_email_exp1_Click Dim MyDb As...

Thanks. The link was just an example and I pressed the wrong slash. I realised afterwards what I'd done. I was hoping no one would notice lol. Yes I have run the code and get a Compile Error: 'End If without block If'. New one to me.

Thanks for the replies guys, but I'm still having problems. I've managed to get some code to send an attachment with an email, but now want to try and merge the 2 pieces of code together if thats possible? Please below. Private Sub email_exp1_Click() Dim MyDb As DAO.Database Dim rsEmail As...

Hi Guys, Background - I want to send an email/s to various recipents email addresses based on a query result. I've created separate queries for each month but ideally would like to set the parameters to choose a month within the code, however although i cant find anything to do this yet the...

Thanks guys I'll give it a go and let you know the outcome.

Hi Guys, I'm new to all this so please bare with me if I miss anything or dont explain something clearly enough. I have a query with the code below. Although the code works prefectly I'd like the search to include a wild card option i.e. add * before the reference query in the text box. Does...