Delete these 3 lines..
On Tue, Aug 19, 2014 at 11:25 AM, Ujjwal Desai ujjwal1...@gmail.com wrote:
Hi Vaibhav ,
on the below line :
If Dir(rngEntry.Offset(0, 3).Value) = Then
MsgBox File rngEntry.Offset(0, 3).Value doesnot exists,
exiting macro.
End If
On Tue, Aug 19,
Deleted the lines.
Emails are also going properly
Now getting Automation Error
On Aug 19, 2014 12:29 PM, Vaibhav Joshi v...@vabs.in wrote:
Delete these 3 lines..
On Tue, Aug 19, 2014 at 11:25 AM, Ujjwal Desai ujjwal1...@gmail.com
wrote:
Hi Vaibhav ,
on the below line :
If
On which line you are getting error also pls share screen shot with error
number..
On Tue, Aug 19, 2014 at 3:40 PM, Ujjwal Desai ujjwal1...@gmail.com wrote:
Deleted the lines.
Emails are also going properly
Now getting Automation Error
On Aug 19, 2014 12:29 PM, Vaibhav Joshi v...@vabs.in
Hi Ujjwal,
PFA...!!!
Regards
Ashish
On 19 August 2014 15:54, Vaibhav Joshi v...@vabs.in wrote:
On which line you are getting error also pls share screen shot with
error number..
On Tue, Aug 19, 2014 at 3:40 PM, Ujjwal Desai ujjwal1...@gmail.com
wrote:
Deleted the lines.
Great!!
On Tue, Aug 19, 2014 at 4:08 PM, Ashish Kumar kumar.ashish...@gmail.com
wrote:
Hi Ujjwal,
PFA...!!!
Regards
Ashish
On 19 August 2014 15:54, Vaibhav Joshi v...@vabs.in wrote:
On which line you are getting error also pls share screen shot with
error number..
On
Thanks Brother!!
On 19 August 2014 16:47, Vaibhav Joshi v...@vabs.in wrote:
Great!!
On Tue, Aug 19, 2014 at 4:08 PM, Ashish Kumar kumar.ashish...@gmail.com
wrote:
Hi Ujjwal,
PFA...!!!
Regards
Ashish
On 19 August 2014 15:54, Vaibhav Joshi v...@vabs.in wrote:
On
Welcome!!
On 20 August 2014 00:21, Ujjwal Desai ujjwal1...@gmail.com wrote:
A Big Thanks guys for helping me out giving your immense help !
Looking for your support in future too.
On Aug 19, 2014 4:51 PM, Ashish Kumar kumar.ashish...@gmail.com wrote:
Thanks Brother!!
On 19
Hello ,
I am trying to send multiple email with attachment with the help of Vba.
Unfortunately I am getting an error “Automation error 440”
Need your help in regards to the attached file.
Awaiting for the reply !
Thanks,
Ujjwal
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do
chek if attachment is there in place?
On Mon, Aug 18, 2014 at 4:32 PM, Ujjwal Desai ujjwal1...@gmail.com wrote:
Hello ,
I am trying to send multiple email with attachment with the help of Vba.
Unfortunately I am getting an error “Automation error 440”
Need your help in regards to the
Hi Vaibhav,
The file path given contains the attachment but still it gives me with the
automation error.
If you can give me another code or solution I would appreciate.
Thanks,
Ujjwal
On Aug 18, 2014 5:19 PM, Vaibhav Joshi v...@vabs.in wrote:
chek if attachment is there in place?
On Mon,
Try this code, if file doent exist it will pop up exit macro.
Try changing file location manually to chek working of code.
Sub CreateMail()
Dim objOutlook As Object
Dim objMail As Object
Dim rngEntry As Range
Dim rngEntries As Range
Set objOutlook =
Hi Vaibhav ,
Finally now working !
But once the macro is executed it does generates the auto email with
attachment too.
But it prompts an error Type Mismatch
How can we fix this problem ???
Thanks,
Ujjwal
On Mon, Aug 18, 2014 at 6:48 PM, Vaibhav Joshi v...@vabs.in wrote:
Try this
On which line you are getting error?
On Tue, Aug 19, 2014 at 12:40 AM, Ujjwal Desai ujjwal1...@gmail.com wrote:
Hi Vaibhav ,
Finally now working !
But once the macro is executed it does generates the auto email with
attachment too.
But it prompts an error Type Mismatch
How can
Hi Vaibhav ,
on the below line :
If Dir(rngEntry.Offset(0, 3).Value) = Then
MsgBox File rngEntry.Offset(0, 3).Value doesnot exists,
exiting macro.
End If
On Tue, Aug 19, 2014 at 11:12 AM, Vaibhav Joshi v...@vabs.in wrote:
On which line you are getting error?
On Tue, Aug 19,
14 matches
Mail list logo