Path: csiph.com!x330-a1.tempe.blueboxinc.net!newsfeed.hal-mli.net!feeder3.hal-mli.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: Thu, 20 Oct 2011 16:49:49 -0500 From: Doug Anderson Newsgroups: comp.databases.filemaker Date: Thu, 20 Oct 2011 16:49:49 -0500 Message-ID: <2011102016494919105-douga@fcstonecom> References: <2011101215485852723-douga@fcstonecom> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1; format=flowed Content-Transfer-Encoding: 8bit Subject: Re: FM 11 - Emailing lists User-Agent: Unison/2.1.4 Lines: 73 X-Usenet-Provider: http://www.giganews.com X-Trace: sv3-ncBa3t3pkRNRJHjNnlR5rj25QvGA5uz13kA8gBSftxHvRHI7ibYYRqt51Rsr5sscnw3MVzQsTzNiMoX!/KbRRwF+cUb0sRQMkn7XFXZQIq/VhB2X/Uo4tLKY7lhpC1qqCYj1aUZO0KP0Hb4= 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: 3668 Xref: x330-a1.tempe.blueboxinc.net comp.databases.filemaker:443 On 2011-10-14 23:28:24 +0000, Your Name said: > In article <2011101215485852723-douga@fcstonecom>, Doug Anderson > wrote: > >> 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? > > You already have a Relationship link from Emails -> Names, so you're half > way there. > > Now you can create a new Calculation field in the Emails Table that > retrieves all the Names via that Relationship using the List function (it > depends on what version of FileMaker you're using as to what this function > is actually called). > e.g. > EmailNames Calculation, Text Result, Unstored > = List (Relationship::Name) > > This will cause the EmailNames field to be given a copy of all the related > Names, separated by a carriage return character. > > For example, if you had data like: > > Email Table: Flinstones@Bedrock.com > Rubbles@Bedrock.com > > Names Table: Flinstones@Bedrock.com Fred > Flinstones@Bedrock.com Wilma > Rubbles@Bedrock.com Barney > Flinstones@Bedrock.com Peebles > Rubbles@Bedrock.com Betty > Rubbles@Bedrock.com Bam-Bam > Flinstones@Bedrock.com Dino > > Then the new EmailNames field in the Email Table for the two records would > have this data: > > Fred > Wilma > Peebles > Dino > > and > > Barney > Betty > Bam-Bam > > The order of the Names will depend on the sorting of the Relationship. > > This Field can then be used when emailing - you can of course replace the > carriage return character with commas or whatever else you want using the > Substitute function. > > Helpful Harry :o) Thank you for the help, that worked perfectly.