Forum

Email Macro send pd...
 
Notifications
Clear all

Email Macro send pdf as attachment to Vendors

6 Posts
2 Users
0 Reactions
91 Views
(@david_ng)
Posts: 310
Reputable Member
Topic starter
 

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.

 
Posted : 24/11/2020 3:35 am
Philip Treacy
(@philipt)
Posts: 1631
Member Admin
 

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

 
Posted : 24/11/2020 10:31 pm
(@david_ng)
Posts: 310
Reputable Member
Topic starter
 

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 

 
Posted : 25/11/2020 12:14 am
(@david_ng)
Posts: 310
Reputable Member
Topic starter
 

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 

 
Posted : 25/11/2020 1:48 am
Philip Treacy
(@philipt)
Posts: 1631
Member Admin
 

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

 
Posted : 25/11/2020 7:08 am
(@david_ng)
Posts: 310
Reputable Member
Topic starter
 

Sorry Philip, my porr explanation of the problem

Please refer this Email macro and the error code.

 
Posted : 25/11/2020 8:55 pm
Share: