copy cell values based on conditions to a text file

[manteca]

PLEASE! erase this topic, i don't know how it gets duplicated from the original one! thanks!

copy cell values based on conditions to a text file

i'm trying to copy two cells values based on a condition from a third cell value to a text document to use to edit a mysql database using the command prompt from phpmyadmin. the text document will include the text as follows for each cell that complies with the condition:

Please Login or Register  to view this content.

this is part of the macro for conditioning:

Please Login or Register  to view this content.

this is the part to retrieve the data from specific cells:

Please Login or Register  to view this content.

i already can send the data to an email, but it generate an email for each cell, instead i'm looking to include the data on a single text file or maybe on a single email, i just need to copy the output to use it with phpmyadmin:

Please Login or Register  to view this content.

any help will be appreciate it. thanks!