Mail merge macro - ensuring only certain rows are pulled from data sheet

Hi all,

So I have a data sheet which regularly pulls down stock quotes from the internet. I also have a word doc which I use as a template for a mail merge, taking data from the excel file and generating some text to go with the quotes.

I'm trying to write a macro to automate this process, since I do it so frequently. The trouble is, I have some 'junk' rows in the database, which I don't think I can remove (since they come from a web query). How can I force my macro to ignore those rows? My current code follows:

Please Login or Register  to view this content.

I've attached a sample data file. In this case, I only want to use rows 5, 7, 9, 11, 13, 15, 19 and 21. The column names are in row 1. Any help would be much appreciated! It seems like there ought to be a simple way to do this...

Alternatively:

1) Is it possible to edit my web query to omit the junk data? Removing it manually doesn't work because it returns every time the query is refreshed.

2) Can I add a conditional around my Word code so that it acts only on rows for which the 'Stock' column is not empty? Code follows:

Please Login or Register  to view this content.

Couldn't figure out how to make that last bit execute without adding the "IF 1 >0" line.

3) Is there another way I should be approaching this problem? Any suggestions welcome; I haven't been able to make progress.