Link unrelated tables

[Davidatlamont]

I'm sure this is not difficult, but . . .

I'm setting up a contact database with an email script. I've added fields for user to enter/paste for Email Subject Line and Text Body, etc. Included is a section so they can choose which categories will receive email.

However, if I set up a special layout in contacts db I'm entering this into a single record, though it's not related to just that record.

If I set up a separate table with only one record to house the email layout, I'm not sure how to link to contacts db to send email to all found records (by way of script).

Sorry if this does not make sense.

[Withan]

You want to make an email in a separate table. Good idea. Then you want to send it to every contact in your contact table which has a certain characteristic or characteristics. ("Buyer", "Female, tall, blonde")

You need to figure out what characteristics you want to choose from, and then make a relationship between contacts and email using the characteristic as a key. Then you can populate your To: field, or preferably you Bcc field with a list of the related email addresses. FMPro has a list function that would work perfectly.

There are other methods, including doing it in the contacts database with global fields, then doing a find to isolate the set you want to send to, and then running a loop through, sending each email one at a time.

Then you can combine the two methods...