VBA Spliting and emailing

[rawatjaibind]

Please help me on priority basis as

1. I want to prepare multiple worksheet file from a single worksheet file on the basis of A Column value
2. Send email on the basis of A column through VBA Coding but in easiest way.

Rgds
Jai

RSM	Bill-to party	Customer Name	Email id	Location	Final Category	Credit limit based on rating	Expected Gross sales as per growth	CL as per working	Proposed Limit	Cut List final- 1st	Shop owned/Rented	Wholeseller/School Counter/Both	Annual turnover/L	Market feedback/reputation	No.of years in book trade	chk	Legal/ Block Status	CL-Prev
Shabih Usmani	1000099	A.B. Enterprises	abc@yahoo.com	West Bengal	Cat-D	0.18	0.28	0.20	1.00	0.20	Owned	School counter	50	Good	10			428510​
Shabih Usmani	1000768	Adarsh Pustak Bhandar		Bihar	Cat-A	9.65	8.61	8.61	10.00	8.61								1300000​
Manish Lakhmani	1001128	Ahuja Book Depot	xyz@gmail.com	Punjab	Cat-D	9.73	15.05	10.70	20.50	10.70	Owned	Both	10Cr	Good	20Years			1500000​
Shabih Usmani	1001254	Akarsh Book Depot		Bihar	Cat-C	9.40	10.90	10.34	10.00	10.00	Owned	School counter	100	Avarage	50	No Account		2500000​
Vibhas Jayaswal	1001255	Akash Book Centre		Uttar Pradesh	Cat-B	1.22	1.18	1.18	1.18	1.18						Rajeev sir Handle this account		2000000​
Shabih Usmani	1001286	Akshar Ghar		Guwahati	Cat-D	0.82	1.27	0.90	0.90	0.90						Rajeev sir Handle this account		500000​
Rajeev Trehan	1001356	Akshay Books		Haryana	Cat-D	7.63	11.80	8.39	13.00	8.39						Rajeev sir Handle this account		1000000​
Shabih Usmani	1001760	Alphabet Public School		Guwahati	Cat-D	9.14	14.14	10.05	10.05	10.00								2500000​
Unnikrishnan-Sajeev Kumar	1001889	Amass Book Centre		Kerala	Cat-A	14.86	13.26	13.26	15.00	15.00	Owned	Both	2.5​	Good	20​			1200000​
Manish Lakhmani	1001995	Amit Book Depot		Punjab	Cat-B	5.96	5.77	5.77	5.50	5.77								400000​
Rajeev Trehan	1002096	Anamica Trading		Chandigarh	Cat-C	14.39	16.69	15.83	18.00	10.00								1500000​
Vibhas Jayaswal	1002107	Anand Book Distributors		Uttar Pradesh	Cat-C	1.19	1.37	1.30	2.00	1.30								500000​
Unnikrishnan-Sajeev Kumar	1002200	Anchumana English Medium Public School		Kerala	Cat-D	1.63	2.52	1.79	1.79	1.79								3000000​
Shabih Usmani	1002201	Andaman Book Centre		A&N	Cat-A	4.05	3.62	3.62	4.00	4.00	owned	school counter	140	Very Good	15			200000​
Shabih Usmani	1002280	Angels English High School		Guwahati	Cat-B	0.84	0.82	0.82	5.00	0.82								300000​
Vibhas Jayaswal	1002483	Anubandh Estate Developers Pvt. Ltd.		Rajasthan	Cat-C	2.18	2.52	2.39	2.39	2.39								800000​
Rajeev Trehan	1002528	A-One Books		Delhi	Cat-A	19.49	17.39	17.39	18.00	10.00								5000000​
Shabih Usmani	1002631​	Arannya Book House		Guwahati	Cat-A	0.28	0.25	0.25	0.25	0.25								200000​
Unnikrishnan-Sajeev Kumar	1002675	Archbishop Mar Gregorios Public School		Kerala	Cat-D	0.12	0.18	0.13	0.13	0.13								16941​
Shabih Usmani	1002847	Arora Books		Jharkhand	Cat-B	2.81	2.72	2.72	5.00	5.00	Rented		1 Cr	Good	10​			500000​