My spreadsheet is looking good, needs a finishing touch to the VBA code, to send EMAILS to rows that are NOT BLANK in the worksheet RESULTS, excluding the HEADER.
See sample file http://www.srands.co.uk/exoftable3.xls
Issue1: To get VBA code working edited (See code below, last line) to return email for only the 2nd row (Row after HEADER) entry only, on the RESULTS page. However knowing the number of not blank rows is impossible.
Issue2: If I expand the row range to a full page upto row 51, many BLANK emails are generated (Because of blank rows, the auto-generated fields would be BLANK).
I don't know what VBA code to use instead though.
For this spreadsheet the number of RESULTS will be unknown depending on the information/data available, hence I want to include NOT BLANK entries from rows 2 to 51.
PURPOSE OF DESIRED SOLUTION:
CODE NEEDS EDITING, JUST TO COUNT NOT BLANK ROWS IN THE WORKSHEET 'RESULTS':
See sample file http://www.srands.co.uk/exoftable3.xls
The WORKSHEET 'RESULTS', has the VISUAL BASIC code called 'Send EMail'.
Stephan
Bookmarks