I have about 400 payment details need send to our vendors each month, before I have used a macro written in 32 bit OS, and sending OK
But after Windows and Office upgrade to Win 10 and 2019 the Macro can not be used any more.
Pls help modify the attach macro to send Email also pick-up related pdf attachment from folder C:Data then send to specific Vendors together with specific pdf payment details as attachment.
Hi David,
You need to be specific about what the problem actually is. When you say 'can not be used any more' - why? Are you getting an error?
I've just run this code in Excel 365 64-bit on Windows 10 without an issue.
Regards
Phil
Sorry my meaning is to pick-up pdf files from a folder eg c:Dataa.pdf,b.pdf,c.pdf x.pdf
and send to recipients via Outlook
Hi Philip,
You need to be specific about what the problem actually is. When you say 'can not be used any more' - why? Are you getting an error? -
David : No I mean my previous macro as written in 32 bit Office 2010 now can not use in 2019 Office 64 bit
Hi David,
I just ran it on my W10 Office 64 bit PC??
So, you still haven't said what problem you are experiencing. When you try to run the macro what happens? An error? Nothing? It runs then hangs?
Phil
Sorry Philip, my porr explanation of the problem
Please refer this Email macro and the error code.