Re: $$Excel-Macros$$ Query in code of email send with attachment from excel

2015-03-23 Thread Vaibhav Joshi
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 ashishbhalar...@gmail.com wrote: Dear experts, See the attached file of email sending from excel. Normally mail send successfully to all

$$Excel-Macros$$ how to run SQL Query in Excel to retrive a set of Data.

2015-03-23 Thread Rakesh kumar
Hi, I want to run SQL Query in Excel to retrive a set of Data. Currently i am executing a query in Sql then copied the output and pasted into excel. Now i want to direct Execution of query into excel. Am able to import complete table, but i don't have idia how to execute the Query. can

Re: $$Excel-Macros$$ Query in code of email send with attachment from excel

2015-03-23 Thread Ashish Bhalara
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,