AnsweredAssumed Answered

Is it possible in FM Pro Advanced 11? If so, how might I go about it?

Question asked by JamesBlaine on Nov 12, 2011
Latest reply on Nov 15, 2011 by philmodjunk

Title

Is it possible in FM Pro Advanced 11? If so, how might I go about it?

Post

Problem

Customers request Pricing catalog or product flyer be sent to them via email

So I have created a table with .PDF file contained in a container field of the requested material and link it to the customer table using a one to many link. i.e.:    cutomer--------------- = --------------<flyers

My Question (Hope I explain this well enough)

How can I do a look up from the customer table of the customers email address and use to send the email without actually adding the email to the flyer table. In other words is their some way to get the email address and possibly keep it in memory until it is used or copy and paste it, use it, then delete it from the flyers table?

I have a working script that does something similar in my invoice table. Only it creates the PDF file and attaches it t an email. (However, the invoice table has the email address contained in it looked up from the customers table. In this new senerio I would like to use the email address after I look up the right customer from the customer table to send the information to.

Maybe someone has a script that they would like to share or a proven work around they would like to share.

Thanks to all who take the time to help with this problem,

Jim 

Outcomes