Tweet
Is there any step by step procedure so I can send copies of reports to an email address who do not have A5? Setting up an Email Profile seems to be the hangup.
-
-
Re: Trying to Email from A5 anywhere
Yes, print them as pdf is the easiest. Then email them as an attachment.
I am updating a5 right now. Will give more in a bit.
put UI_EMAIL_SETTINGS() in a button to open the email setup dialog(xbasic) or in a script.
If you need more help???Last edited by DaveM; 08-02-2015, 08:22 PM. -
-
Re: Trying to Email from A5 anywhere
Yes i knew i could send them as an attachment to an email but I thought it might be easier to email more than one person from A5? Maybe not!! Thanks for you prompt answer.Comment
-
Re: Trying to Email from A5 anywhere
are you using email_send2 function, the example in wikipedia shows how you can send to many people.I thought it might be easier to email more than one person from A5? Maybe not!
the to parameter of the message pointer can have multiple entries separated by ';', ',' OR crlf()
take look at the function.
i use that function in web but so far i have no need to send to multiple addresses.thanks for reading
gandhi
version 11 3381 - 4096
mysql backend
http://www.alphawebprogramming.blogspot.com
[email protected]
Skype:[email protected]
1 914 924 5171Comment
-
Re: Trying to Email from A5 anywhere
Govindan is correct.
I send to multiples all the time with the other method as well. The addresses need to be in the form or table/set you are working with
You can set up premade email templates and send to many, if you want. I sent 20+ thousand once, but it took a while because my isp would only allow like 35 per 30 minutes.
You do the math.Comment
-
Re: Trying to Email from A5 anywhere
I send about 2500 at a time using Mandrill - it bypasses your ISP. Takes an average of 1.5 to 2.0 seconds to convert one or more reports to PDF and send as attachments.Cole Custom Programming - Terrell, Texas
972 524 8714
[email protected]
____________________
"A young man who is not liberal has no heart, but an old man who is not conservative has no mind." GB ShawComment
-
Re: Trying to Email from A5 anywhere
Don:
If you are reasonably fluent with XBasic, you might want to build something a little more dynamic.
If you hard code in the email addresses, every time they change responsibilities, hire, and fire, you need to go in and change the code. If you work for that company, than that's no big deal.
If this is for a client, you might want to think twice about having to maintain code everytime they add or delete a recipient.
You might want to create a function that looks at a table where an administrator can add and subtract email addresses, and place an X in the column that represents the report to be emailed.
You can get the extra money for expanding what needs to be done, since the script will take longer to create, and the user has the ability to govern the email without waiting for you to add and subtract recipients.
Of course, every time you add a new report, you need to add a new field to the table, but that's easy.
See attached for a generic browse table I did for a company...
Either way, Alpha can do what you need it to do, as others have suggested.Comment
-
Re: Trying to Email from A5 anywhere
If anyone would like me to post the function and tables, let me know. I can give a sample to you on the weekend.
I don't use a profile, just a table with the SMTP info.Comment
-
Re: Trying to Email from A5 anywhere
Please share when you can.Originally posted by CraigSchumacker View Post
Thanks.Al Buchholz
Bookwood Systems, LTD
Weekly QReportBuilder Webinars Thursday 1 pm CST
Occam's Razor - KISS
Normalize till it hurts - De-normalize till it works.
Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.When we triage a problem it is much easier to read sample systems than to read a mind.
"Make it as simple as possible, but not simpler."
Albert Einstein
http://www.iadn.com/images/media/iadn_member.pngComment
-
Re: Trying to Email from A5 anywhere
I put it in the code archive...
Comment
-
Re: Trying to Email from A5 anywhere
Hi Craig,
Thanks for link to Code Archive, I have downloaded your sample and as far as I can tell this is for desktop.
Can you help to do this from AA?Regards
Keith Hubert
Alpha Guild Member
London.
KHDB Management Systems
Skype = keith.hubert
For your day-to-day Needs, you Need an Alpha Database!Comment
-
Re: Trying to Email from A5 anywhere
Keith:
No thanks necessary. I haven't contributed much here, at least not recently. Time is the issue - even this took 2 hours to modify, create and test the small app in the code archive.
By AA, do you mean Alpha Web?
The function will work on either desktop, or on Alpha Web. You are just replacing the browse with a grid.
Everytime the developer adds a report, that person (aka you) needs to revise the grid or browse by adding a new field used as the flag field; the one that gets the 'X'. Only an admin user gets access to selecting who gets emailed each of the reports on that grid or browse.
As for where the report gets saved, that I bet will need to take place on a folder on the web server. You might want to add time to the section that names the report, as well as possibly adding the user id. Then, adjust the CLEANUP section at the bottom of the function so it cleans up by user. You may not even need to save a copy of the report for long. I added that in as some reports are run before a post, so an archived copy was a logical addition to the function.Comment
Comment