Search results

Okay, thank you, done that. Slowly moving down the code. So now getting to this: Set salesRST = CurrentDb.OpenRecordset(strSQL) Getting run-time error: Too few parameters. Expected 2 Sorry if I'm being a pain but as I say I'm a noob really. I have this idea in my head for a DB and...

Thank you. Now stuck at this Set MailOutlook = appOutlook.CreateItemFromTemplate(Application.CurrentProject.Path & "\RefundRequest.oft") Its stating Object Required?

Hi, I have an outlook template (attached screenshot) and some code that looks through two tables to grab required info for email template. I have to be honest I have borrowed this code from somewhere else and amended it. I am however getting syntax error: Syntax error (missing operator) in...

An example would be very helpful please 👍

@theDBguy how do I adapt that code to loop through the continuous subform?

Outlook 👍

Hello once again, I had previously posted with a very similar question but in that example I was using a list box. Having a re-think I was potentially adding an unnecessary step to my DB because I already have a list of the documents that are required to be attached in my 'ExisitngLeadF, as a...

Apologies for the delay have been away for a few days with the kids. I shall have a look through all suggestions today and update on my progress. Thank you all for your help so far.

Sorry probably should of explained what I'm trying to achieve! My database allows the end user to attach (copy & past) proofs of attempted client contact to the database (folder under the database). This proof isn't required beyond 30 days, so rather than files building up I wanted an...

This works in windows command line as I have tried it: ForFiles /p "C:\Users\David\Desktop\New Leads\ContactProofs" /s /d -30 /c "cmd /c del @file" I thought I might be able to run it as a shell command within VBA but with CurrentProject.Path like this: Shell ForFiles /p &...

Send me your address and I'll send you a pack ;-)

BOOM! and thats the kinda help I'm talking about @CJ_London. Thank you so much, your a diamond 👍

Unfortunately not! :-( Literally copied and pasted the code you provided, I can repost if you would like me to? This is what I couldn't work out, I thought I was really close with the code I had!

So my original code opens two emails one with each of the attachments. Your amended code adds the same attachment twice to one email 👍

@arnelgp are you able to help please? I note that you helped in this thread: (2) Solved - Sending Email to recipients from Listbox | Access World Forums (access-programmers.co.uk) where @Momma wanted to loop through a listbox. Thanks in advance

@Gasman once again I find myself staring at the screen without a clue what to do, scratching my head, really confused. Please don't take this the wrong way but you have now been involved in three maybe four of my threads, and every time I find your input really frustrating! I get your slogan...

Could you not just show me how I fit that in with the code please?

@Gasman how would I incorporate that into the code please?

Okay thanks @MarkK. This is not my issue, I have tried and failed at what I was attempting hence why I am here asking for help.

Hi @MarkK, thank you for the code. Your code does not attach anything unless you select the item first. I'm only using the list box as a method to display what is being attached. I'm looking for code that will loop through each item in said list box, without, end user interacting with said...