Hi everyone, I am insanely new to VBA and I am trying to solve a problem with a macro that was set up by someone else, I probably know where the problem is, but I have no idea how to solve it. Short story: I have a list of suppliers with corresponding emailadresses, each supplier has a supplier number and a specific folder path. From this excel file. The macro should be able to create the email with the RIGHT files from the corresponding folder path. The problem with my macro is that it only works for certain rows perfectly. Very often it will create the email without any attachments when there are several pdf files in the folder path. This is the code below THe red labeled text, looks like it has no added value, but as soon as I delete this text, the vba no longer works. As shown in the screenshot, You can see that it copies row E2:E3000. pastes it in column D. But for some reason it will start hussling the emailadresses Could someone help me? :( (Code, 172 lines)

Create Outlook Item with specific set of pdf files from specific folder for specific emails

Don’t have an account yet? Register yourself now and be a part of our community!