Jferrer
New member
- Joined
- Jul 17, 2015
- Messages
- 9
- Reaction score
- 0
- Points
- 0
- Excel Version(s)
- version 2105
Hi,
I am new member on this site, and i can say that i have well understanding of excel while i'm a novice on vba programming my knowledge is very basic so i have to search for a code that i preferred. i've been searching for a code that will automate the process of a rawdata to filter a specified column, and split each distinct values into a separate file then save into a specified directory, and then e-mail it using outlook to designated recipient and copyee, however i could not find any code that has this process, i only found split to file code from superuser
i dont know where to insert the outlook code and how to conditionally set the code for recipient and CC based on the vendor name
i have attached my file, from the spreadsheet there are 2 tabs
1st tab (Main)
-here you can find the list of information of all the vendors (even if its not in the rawdata) and their contact address and copyee.
-on column D, you can put a customized message option in case you dont want to use the default message embedded in the code or you want to composed a different message to the vendor.
-on top of header a botton to send the email.
2nd tab (Rawdata)
-here are the rawdata, basically its only from vendor code(column A) to Fax date only(column M) because i insert the Vendor Name(column N) where you put the same vendor name even if different vendor code so that it can combine all its data in one file only
you can check the process TAB on the attached for my preffered process.
Hope that someone will look into this and i appreciate your help.
Thanks in advance
JonathanView attachment SplitFiles then e-mail.xlsm
I am new member on this site, and i can say that i have well understanding of excel while i'm a novice on vba programming my knowledge is very basic so i have to search for a code that i preferred. i've been searching for a code that will automate the process of a rawdata to filter a specified column, and split each distinct values into a separate file then save into a specified directory, and then e-mail it using outlook to designated recipient and copyee, however i could not find any code that has this process, i only found split to file code from superuser
i dont know where to insert the outlook code and how to conditionally set the code for recipient and CC based on the vendor name
i have attached my file, from the spreadsheet there are 2 tabs
1st tab (Main)
-here you can find the list of information of all the vendors (even if its not in the rawdata) and their contact address and copyee.
-on column D, you can put a customized message option in case you dont want to use the default message embedded in the code or you want to composed a different message to the vendor.
-on top of header a botton to send the email.
2nd tab (Rawdata)
-here are the rawdata, basically its only from vendor code(column A) to Fax date only(column M) because i insert the Vendor Name(column N) where you put the same vendor name even if different vendor code so that it can combine all its data in one file only
you can check the process TAB on the attached for my preffered process.
Hope that someone will look into this and i appreciate your help.
Thanks in advance
JonathanView attachment SplitFiles then e-mail.xlsm