Search results

Hi @CJ_London thank you for this code. When I've tried it it opens a new Outlook mail item and adds the same attachment twice!?

Hello, I am sure this has been discussed somewhere on this forum already, however, I cant find it! Been experimenting with some code. So far the code picks up the attachments from the list box but puts each one into a separate email. I want all attachments in listbox to be attached to the...

I've managed to get @theDBguy code to work only by trial and error and watching a few YT videos. Regards

Yep you are correct, my other code does include the file extension! Doh! 👍

Just added extension to code and it works! Question then, elsewhere in my VBA code I have this file referenced but without the extension, why did it cause a problem here?

I know what your going to say, no extension!

The file

Hi again! Really not sure why I'm getting this message. I have various pieces of VBA code all pointing to this same document in my DB with no problems. Now I want to try and attach this file to an email I'm getting this error message. The file exists, the path hasn't changed! This is the...

@Gasman I have looked at the other link and it makes as about as much sense as the first. Its all very well telling someone to read something, its all there, but if they don't understand in the first instance they still wont understand after reading it. The links tell you what will happen and...

Yep looked at all of the link still don't get it! As you can probably tell I don't do this sort of thing for a living!

Yes I do but I also want said notes to then show at the end of the client record row under notes. An I getting confused or the wrong end of the stick? Sorry 😳

@Gasman funny you should say that! I've managed to follow Allen's instructions as far as adding the module but to be fair thats quite easy! This is the SQL that I have so far: SELECT Client.Broker, Client.Lead_Date, [Client_FN] & " " & [Client_SN] AS LF, Client.Email_Address...

Cheers @plog That makes sense and the link that you have sent looks exactly as I was looking for. Don't have time to try it now but will do tomorrow and will report back to you how I got on.

Hello, I have attached a screenshot of a query that I have put together. It wont be obvious from looking at it (because I've had to cover confidential information) however the two rows that are underlined are the same client record. I have a note system that stores notes for each client in a...

@bastanu thank you 👍 That took care of that part. Just to add the send as email attachment part now

Brilliant thank you @June7 that worked a treat. Now a couple of questions if I may please? Is there anyway to reference the current project file path for this line rather than including a file path. Ultimately this DB will be distributed to the team and I need a universal place for the SS to...

Scrap that might have just missed it, I'm going to fourth option on that link. I'll let you know how I get on 👍

Thanks for your prompt response. I've read through the website you sent and to be honest I really don't know what option applies. Although I am happy to experiment with pre written code I really would like my hand held on this one and what would be really useful is if I could see an...

Helloooooooooo, The title pretty much says all! I have an Excel Spreadsheet (SS) that the directors have put together in a format they are happy with (please see attached). Lets say I have a table with all the information needed for the SS plus a few little extras that I have added PLUS a...

Sorry I don't follow, I've not mentioned anything about a text box!?