Exporting records with certain data in a specific field

Hi All,

I was wondering if anybody could point me in the right direction. I have the following base set up:

A B C D 

1 @ ! P £
2 @ ! P $
3 @ ! P $
4 @ ! P £

1,2,3,4 are the records, and A,B,C,D are the files. What I would like to be able to do is email the full records of 2 and 3 as they have a “$” in the “D” Feild and 1 and 2 dont.

I have been able to email out the records individually, but I want to put both records in the same email.

Any advice? ,

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.