Path: csiph.com!x330-a1.tempe.blueboxinc.net!newsfeed.hal-mli.net!feeder1.hal-mli.net!border3.nntp.dca.giganews.com!Xl.tags.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!local2.nntp.dca.giganews.com!news.giganews.com.POSTED!not-for-mail
NNTP-Posting-Date: Wed, 12 Oct 2011 15:48:58 -0500
From: Doug Anderson <douga@fcstone.com>
Newsgroups: comp.databases.filemaker
Date: Wed, 12 Oct 2011 15:48:58 -0500
Message-ID: <2011101215485852723-douga@fcstonecom>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
Subject: FM 11 - Emailing lists
User-Agent: Unison/2.1.4
Lines: 17
X-Usenet-Provider: http://www.giganews.com
X-Trace: sv3-F68NhKWzGdTyhAGG6oU3AkuOyJReRCh8wswSdG1gnpg2989Ei/nI/x/mnobJfJIbwB6oBguWj+MyASm!uWwkWxUOXnsBa4Kr98eOr5fItAHL6xahI8vHibEb2KDhHVXlYmpm9Tn63aX0lJE=
X-Complaints-To: abuse@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly
X-Postfilter: 1.3.40
X-Original-Bytes: 1658
Xref: x330-a1.tempe.blueboxinc.net comp.databases.filemaker:432

I have a database with two tables.

Table one consists of just one field, its an email address.  There are 
no duplicate email addresses, each is unique.

In the second table I have two fields, one is email address which is 
linked to table 1 and the second is a customer name.

In layouts I can create a portal that shows for each email address all 
the customer names.

What I want to do is carry that over to the Send Mail function; but 
I've been unable to figure that piece out. How do I insert a 
Calculation that will pull each record from table 2 where the email 
address matches and in the body of the email list the values in list 
form from the customer names field?