Lantica User Forum - Email function with embedded xlookupsourcelistall

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › Email function with embedded xlookupsourcelistall

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Pages: 1

Email function with embedded xlookupsourcelistall (Read 630 times)

BWETTLAUFER Full Member Offline Posts: 216 Location: Cambridge, Ontario Joined: Apr 9^th, 2010	Email function with embedded xlookupsourcelistall May 30^th, 2013 at 7:27pm	Print Post
	Hi all, I've had some time to do some programming, and I've built in a number of excellent functions, including batch emailing. What I want to tackle next is the ability to send our clients a batch email on a monthly basis with an inventory report of all their files with us. So, I'm trying to use our client form to pull data from our inventory form like so: Code vInv1 = @xlookupsourcelistall(@FN, CltNo, "DR Screen!DBCltNo", "DBCltNo;DBName;DBRef#;DBList;DBPd;DBBal;DBStatus") It works fine ... however, I want to format the data through a few steps, starting with sorting the string array to display in alphabetical order by DBName. What is the best way to go about this? Thanks, Blair


	WWW Twitter IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2482 Joined: Aug 20^th, 2003	Re: Email function with embedded xlookupsourcelistall Reply #1 - May 30^th, 2013 at 8:19pm	Print Post
	Hello Blair, The way I would go about doing this is to use @XResultSetSearch() and then the subsequent XResultSet commands such as @XResultSetSort() and @XResultSetValue(). Or use @XResultSetSearch(), @XResultSetSort() and @XResultSetPrintReport() (using REPORT_MODE_HTML_GENERATE) and then attach the resulting HTML report to the E-mail that you are sending with @SendMail() -Ray

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

Pages: 1

‹ Previous Topic | Next Topic ›