Ok so I am having a little difficulty figuring out how to do this so I though I would ask for help!
I have a spreadsheet report I need to update daily and email the results. What I am looking for is a macro or VBA module that can do the following...
Copy all the rows in a constant range that currently have data in them. The range will always be a constant - say A1:D300 for example. But sometimes the data will run through row 20, and other days through row 200. I need the VBA code to loop until it hits a blank row of data, and then it can stop. All the data will be consecutive so there won't ever be a situation where there is data on row 5, no data on row 6, then data again on row 7.
Finally I need / would like the data to be pasted into the body of a new email, but not sent yet as I may need to update the daily subject line. However if it is possible to auto populate a distribution list stored in my contacts that would be beneficial (call it "DailyReport Distro").
Any help would b MUCH appreciated!!
Bookmarks