auto send emails using vba

[shiva_raj]

Hi,


I wrote VBA code to send individual emails automatically. my code intention is , send every mail with individual attachment ('F' column) as well as attach all repeated attachments ('G' column) (these attachments is for all candidates). if there is no invidual attachment then mail should go with repeated attachments. i think code is perfect. but while running the code, i'm getting error (path not found) in "IF" condition. Pls help.


regards
shiva

[Richard Buttrey]

Which IF block?

Does the code process at all or does it fail immediately.
And stating the obvious but are you certain the path\filname does exist.
When the code debugs what's the value of .Cells(i,6) ?

[shiva_raj]

HI,

1) code fails immediately.
2) My path exist on my desktop.
3) cells(i,6) contains file path.

i attached sample file. pls go through it.

regards
shiva