Re: $$Excel-Macros$$ Dynamic Attachment with Email Send

2014-03-16 Thread ashish koul
Function workbook_path(txt1 As String) As String Dim pathname As String Dim wkb As Workbook pathname = Environ("Temp") & txt1 & " " & VBA.Format(VBA.Now, "ddmmmyy_hhmmss") & ".xlsx" If Sheets("Branch Name").AutoFilterMode = True Then Sheets("Branch Name").AutoFilterMode =

Re: $$Excel-Macros$$ Dynamic Attachment with Email Send

2014-03-14 Thread Vijay
Dear Mr. Richard, Thanks for the reply. im really happy for received E Mail from you for what i'm expected and i have few more requirement to fulfill the process what i exactly need as mentioned below. 1. I want to send it through MS Outlook instead of Gmail. 2. Not Require a Command Button in Ex

$$Excel-Macros$$ Dynamic Attachment with Email Send

2014-03-13 Thread Vijay
Hi Team, I need a help in creating a macro for attached Excel File in E Mail. Process Brief:- 1) I have one excel file. In that excel file, there is one column named as "Branch Name". Which is important us to find out Branch Name and that particular branch details should be create as Separat