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 Separate file. 2) Once separate file has been created, Excel file name should be saved as Branch name after which is created that the particular sheet automatically attached to E mail "TO and "CC" should assigned as per particulars available in the E mail column in that excel sheet. and if other branch file name to be sent as attachement in E Mail, it is only to send as per the E Mail column details. Example if TO and/or CC column kept as blank. Macro should not send to the same. and also E Mail should not repeat. As mentioned above steps, Suppose i need another branch name, after created as branch file name and attached if i want to send E Mail (as applicable in that column, irrespective of "TO" and "CC") it should e mail as per particulars available in that column. 3) I should be able to give the path where the files are stored. The file would in .xls format. Thanking you in advance. Regards Vijay
-- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
MIS.xls
Description: MS-Excel spreadsheet
