Attachments wrongly attached VBA

[rakesh seebaruth]

Hello guys

I have my excel file as per below drop box link

testing264.xlsm

Shared with Dropbox

www.dropbox.com

The main issue that i am having it that it does not attach the respective attachment to its email .

Let me explain :


Attachment Email Address
C:\Users\rakesh\Documents\d.pdf hs@intnet.mu
C:\Users\rakesh\Documents\ocr.pdf shr@intnet.mu
C:\Users\rakesh\Desktop\ERGISTRY\x.pdf rs@intnet.mu
C:\Users\rakesh\Desktop\ERGISTRY\y.pdf rakesh1974@orangez.mu

The file y.pdf is the attachment of email ------>rakesh1974@orangez.mu
The file x.pdf is the attachment of email .................> rs@intnet.mu
The files ocr.pdf is the attachment of email -------> shr@intnet.mu
The file d.pdf is the attachment of email ------> hs@intnet.mu

When i execute VBA, only file d.pdf is attached to its respective email that is hs@intnet.mu

the output for the others are as follows :-

File d.pdf,ocr.pdf, x,pdf and y.pdf are attached to mail rakesh1974@orangez.mu
File d.pdf, ocr.pdf ,x,pdf are attached to mail rs@intnet.mu
File d.pdf,ocr.pdf are attached to mail shr@intnet.mu

I am working on Sheet3

Thanks/regards

Rakesh

 

[Fluff]

Duplicate Attach excel file according to path and email vba

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).