(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › email invoices and statements
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic email invoices and statements (Read 524 times)
pineberry
Full Member
***
Offline


No personal text

Posts: 115
Location: Strawberry, AZ  USA
Joined: Nov 30th, 2002
email invoices and statements
May 3rd, 2009 at 10:39pm
Print Post Print Post  
I have ignored the email capabilities of Sesame up to this point. Now I would like to email invoices to customers based on a result set of a days invoices. At the end of the month I would like to email statements to customers. The customer database contains the customers email address in their account record. The invoice and statement files do not contain the email address. Can these tasks be accomplished with Sesame ?

Harley
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: email invoices and statements
Reply #1 - May 8th, 2009 at 1:09pm
Print Post Print Post  
Hello Harley,

You would want to use XLookup to retrieve the E-mail address from the customer Database
Then use the @FormFieldValue commands to get the data from the subform,
Compile it and Data from the parent form into one long String Variable
and use SendMail() to Send the E-mail

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge