vba macro that generates email attachments in 2010 but not in 2016

kodadawn

New Member
Joined
Jul 4, 2018
Messages
1
hello

new to the forum and any forum - have been advised this forum is fantastic for help and all there is to know about excel, i have spent over a week googling and trying different things so at wits end.

due to GDPR we had to purchase new HP machines with bitlocker capabilities, which needed windows 10 and office 2016 (due to move to 365 for emailing) currently using outlook within 2016.

we work with an excel sheet that has been developed and changed over many years from 2007 through to office 2010 - worked fine. the excel sheet is completed and has been set up to run a VBA script/macro that generates a form to come off the excel sheet turn itself into a pdf, put it self into a given named folder, then attach itself to an email ready to send, ..so we have a button on the form called email, by clicking that button it generates the vba macro to run (we have to have a printer installed to make it work), that click puts the pdf in the folder ok we can see them going into the folder, but the attachments to an outlook email is not happening.

now heres the thing - i have a few machines (new) on 3 machines it works and on 4 it does not, our IT department say the build and spec are exactly the same on them all, they are all the same versions, we have been through various settings and they all appear the same. we have tried various things on the machines but nothing is fixing the issue, and unfortunately it means the machines cannot be used as this forms a massive part of our working routines.

please be gentle i am not an excel expert !!!

thank you for reading.

please advise help and what i can check for.

thanks in advance
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Hi

We have similar issues at work with an emailing script i put together, we have found on some machines if outlook is open it wont work and on others if outlook is closed it works fine, so i would try using the sheets with and without outlook open and see what happens

paul
 
Upvote 0

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top