Search results

Can you have look at my thread when you get minute http://www.access-programmers.co.uk/forums/showthread.php?t=278966 Thanks Shane

Hi I a main form with continous subform I just want to loop through the sub form records to find the attachment for the email if the send field is true then attach the file but if the send field is false then don't attach file Thanks Shane

right this is my 2nd attempt still not working :banghead: Dim olApp As Outlook.Application Dim olMail As Outlook.MailItem Dim olAttach As Outlook.Attachment Dim rstAttach As DAO.Recordset Dim rstFiltered As DAO.Recordset Set olApp = New...

hi after looking at the link you provided me this my attempt but i think it trying to add new or edit not filter ' Add Attachments With rstAttach If .RecordCount > 0 Then .MoveFirst Do...

vbaInet Excellent memory;) here my attempt I know it not right but am I going in the right direction before I go tying myself up :) With rstAttach .Filter = !Send Me.FilterOn = True If .RecordCount > 0 Then .MoveFirst...

hi, vbaInet no this will not be used by multiple user at the same time thanks shane

hi , I have some code that loops the clone recordset of my subform and generates a email with attachments. I have mainform and continuous subform within the subform I have field called address this holds paths to files and another field called send and this is a yes/no field now what...

Thanks VbaInet for your patience (man of steel) got there in end Legend!!!!!!!!!!! thanks again:D Time for Bed I think! Shane

I have done that doesn't make a different what a weird fault :confused: can you see it does the same for you I attached last copy of my db in the last post would it be anything to do with office 365?

WOW !!!!!!!!thanks it works only one issue for some reason if I go to the next record with no path in txtaddress field and run the code the email open's with no attachment which is correct but then if go back to a record with attachments and run the code again it attaches nothing even though...

Yeah it sure does I just double checked it :)

I'm pretty sure see my sample see if I'm right

right... but txtaddress is the field name that holds the file path sorry i must be getting on you nerves now .

right I think I'm closer runtime error 3252 operation not support for this type of object Dim olApp As Outlook.Application Dim olMail As Outlook.MailItem Dim olAttach As Outlook.Attachment Dim rstAttach As DAO.Recordset Set olApp = New...

sorry vbaInet I m lost completely and why over my head here my code now still no good and the same error as before Dim olApp As Outlook.Application Dim olMail As Outlook.MailItem Dim objOutlookAttach As Outlook.Attachment Dim rstFiltered As DAO.Recordset Set olApp = New...

have done what you said quoted above WOW!!! didn't realise how many errors but still not working run time error 3464 data type mismatch here is the code Dim olApp As Outlook.Application Dim olMail As Outlook.MailItem Dim objOutlookAttach As Outlook.Attachment Dim rstFiltered As...

here is a watered down sample of my db

I can't add Option Explicit at the top as it then causes error with other code within the form here what I have change still not working error has moved now say runtime error error 424 object required :banghead::banghead: here the code Dim olApp As Outlook.Application Dim olMail As...

does this look any better I'm getting different message error message now runtime error 3464 data type mismatch :banghead: Dim olApp As Outlook.Application Dim olMail As Outlook.MailItem Dim objOutlookAttach As Outlook.Attachment Dim rstFiltered As DAO.Recordset Dim strteamid As String Set...

I' m back ..... I have had ago with the link you provided vbaInet but still isn't working the error message I get is run error 91 variable not set just some more notes the main form id is call teamid and the subform id that is link to the main form id is linkattachments I have highlight the...