Pivot Table Rowfields - Values - Email.

Need to figure how to loop thru rows in a Pivot Table and get all of the values of the second Row Level under the first Row Level. The code will fall within a For Loop that loops thru the rows of the Worksheet.

For example:

AAA
11111
22222
33333
BBB
33333
44444
55555
CCC
11111
22222
55555
66666

Want to be able to load the values into an array as I loop thru the values. And when I hit the end of the group of rows, be able to put the values as voter buttons in an email message.

For example

email message
to: CCC's email address
subject: Please vote.
11111 vote: Yes/No
22222 vote: Yes/No
55555 vote: Yes/No

Any code snippets would be appreciated!

Thanks
66666 vote: Yes/No