Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

Welcome!! On 20 August 2014 00:21, Ujjwal Desai 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" wrote: > >> Thanks Brother!! >> >> >> On 19 August 2014 16:47, Vaibhav Josh

Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

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" wrote: > Thanks Brother!! > > > On 19 August 2014 16:47, Vaibhav Joshi wrote: > >> Great!! >> >> >> On Tue, Aug 19, 2014 at 4:08 PM, Ashish Kum

Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

Thanks Brother!! On 19 August 2014 16:47, Vaibhav Joshi wrote: > Great!! > > > On Tue, Aug 19, 2014 at 4:08 PM, Ashish Kumar > wrote: > >> Hi Ujjwal, >> >> PFA...!!! >> >> >> Regards >> Ashish >> >> >> On 19 August 2014 15:54, Vaibhav Joshi wrote: >> >>> On which line you are gett

Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

Great!! On Tue, Aug 19, 2014 at 4:08 PM, Ashish Kumar wrote: > Hi Ujjwal, > > PFA...!!! > > > Regards > Ashish > > > On 19 August 2014 15:54, Vaibhav Joshi wrote: > >> On which line you are getting error & also pls share screen shot with >> error number.. >> >> >> On Tue, Aug 19, 2014

Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

Hi Ujjwal, PFA...!!! Regards Ashish On 19 August 2014 15:54, Vaibhav Joshi 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 > wrote: > >> Deleted the lines. >> Emails are also going pr

Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

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 wrote: > Deleted the lines. > Emails are also going properly > > Now getting "Automation Error" > On Aug 19, 2014 12:29 PM, "Vaibhav Joshi" wrote: > >> Delete thes

Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

Deleted the lines. Emails are also going properly Now getting "Automation Error" On Aug 19, 2014 12:29 PM, "Vaibhav Joshi" wrote: > Delete these 3 lines.. > > > On Tue, Aug 19, 2014 at 11:25 AM, Ujjwal Desai > wrote: > >> Hi Vaibhav , >> >> on the below line : >> >> If Dir(rngEntry.Offset(0, 3

Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

Delete these 3 lines.. On Tue, Aug 19, 2014 at 11:25 AM, Ujjwal Desai 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, 2014

Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

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 wrote: > On which line you are getting error? > > > On Tue, Aug 19, 2

Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

On which line you are getting error? On Tue, Aug 19, 2014 at 12:40 AM, Ujjwal Desai 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 we fix t

Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

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 wrote: > Try this code, if fi

Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

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 = CreateObject("Outlook.Ap

Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

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" wrote: > chek if attachment is there in place? > > > > > On Mon, Aug

Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

Hi, Your code is working fine. check onces, as said by vaibhav ji. On 18 August 2014 16:32, Ujjwal Desai 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 t

Re: $$Excel-Macros$$ Send multiple email with attachment through outlook

chek if attachment is there in place? On Mon, Aug 18, 2014 at 4:32 PM, Ujjwal Desai 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 attached file.