$$Excel-Macros$$ Send individual complete details through email to respective client

There is a sheet with name "Sheet1" and it contains the following data: A1 contains name, B1 Product, C1 Amount, D1 Email A1B1 C1D1 Name Product Amount Email Raj Shoes 1000 a...@a.com Sun Socks 800b...@b.com Raj Socks 700a...@a.com Sun Ball500b

$$Excel-Macros$$ Email to receiptant about there data contained in Pivot Table

Suppose there are fields like: Name, Commision, Email Id etc in Sheet1 Now Data contained is given below Name CommissionEmail ABC 1000 a...@abc.com DEF500d...@abc.com ABC 700 a...@abc.com ABC800 a...

$$Excel-Macros$$ Send email to individual receiptant of Pivot Table data

Suppose there are fields like: Name, Commision, Email Id etc in Sheet1 Now Data contained is given below Name CommissionEmail ABC 1000 a...@abc.com DEF500d...@abc.com ABC 700 a...@abc.com ABC800 a...

$$Excel-Macros$$ How to delete blank columns & rows using VBA

I wanted to know how can one delete all blank rows & columns using VBA? Suppose in Cell A1 there is data but in other cells with row 1 there is no data. Thus we can say this row is not blank. BUt taking other example suppose there is data in Cell C1, A3, A4. But entire row i.e ROW - 2 is blank. How