I have a spreadsheet that I have created. It is pretty basic and straight forward.
I have found some VB online to create convert to PDF and email automatically. There are two things I want to do.
1. Create a section to pull email address's from (approx 6 email address's) to put in the send to section when the VB is activated. Right now it is coded in the actual code and doesnt pull the data from cells
2. When the convert / email VB is activated, I would like it to remove all the lines that have no data in it so when it is emailed there is not all the dead space and everything is compacted.