Replace .addattachment rngAttach1.Value with
If Dir(rngAttach1.Value) <> "" Then
.addattachment rngAttach1.Value
End If
Cheers!!
On Tue, Mar 24, 2015 at 9:05 AM, Ashish Bhalara
wrote:
> When value of path is null, function by default set 0 in cell F2, so I
> tried below code to avoid error on
When value of path is null, function by default set 0 in cell F2, so I
tried below code to avoid error on path not written in cell. but though
same error is occur, pls do something in coding.
If ws.Range("F2") <> Chr(48) Then
.addattachment rngAttach1.Value
End If
On Mon,
Before adding att check if attachment exists or not, if its null then you
will get error...
Cheers!!
On Mon, Mar 23, 2015 at 5:00 PM, Ashish Bhalara
wrote:
> Dear experts,
>
> See the attached file of email sending from excel. Normally mail send
> successfully to all together from database. I n
