+ Reply to Thread
Results 1 to 3 of 3

E-Mails auto generated in Excel just to not include blank rows

  1. #1
    Registered User
    Join Date
    07-26-2010
    Location
    Hull, England
    MS-Off Ver
    Excel 2003
    Posts
    44

    Question E-Mails auto generated in Excel just to not include blank rows

    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':
    Please Login or Register  to view this content.
    See sample file http://www.srands.co.uk/exoftable3.xls

    The WORKSHEET 'RESULTS', has the VISUAL BASIC code called 'Send EMail'.

    Stephan

  2. #2
    Registered User
    Join Date
    07-26-2010
    Location
    Hull, England
    MS-Off Ver
    Excel 2003
    Posts
    44

    Re: EMAILs AUTO GENERATED in Excel just to include NOT BLANK ROWS?

    Obviously to view 'RESULTS' worksheet VISUAL BASIC code, View, Tools Bars, Visual Basic, then on the Toolbar press the play symbol (R/H arrow), Step into:

    Please Login or Register  to view this content.
    This code I saw elsewhere (J Walk http://spreadsheetpage.com/index.php...il_from_excel/ ) and would work well for my purposes with a little editing as suggested on 1st post.

  3. #3
    Registered User
    Join Date
    07-26-2010
    Location
    Hull, England
    MS-Off Ver
    Excel 2003
    Posts
    44

    Talking Re: EMAILs AUTO GENERATED in Excel just to include NOT BLANK ROWS? SOLVED!

    I've solved it!

    See my WORKING file http://www.srands.co.uk/exoftable3.xls

    Simple 1 line code change:
    Please Login or Register  to view this content.
    So the full VBA code for the RESULTS page is:
    Please Login or Register  to view this content.
    NOTE: This code is of an edit from J Walk http://spreadsheetpage.com/index.php...il_from_excel/

    See my WORKING file http://www.srands.co.uk/exoftable3.xls

    This is a great working file, I wonder if it is possible to do the same with an EXCEL 2003 FORMULA? (Aka not Ron de Bruin or erlandsendata!)
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1