RE: Email from foxpro
Have you looked into blat. Blat.net Bob Lee -Original Message- From: ProfoxTech [mailto:profoxtech-boun...@leafe.com] On Behalf Of Gene Wirchenko Sent: Thursday, June 06, 2013 2:18 PM To: profoxt...@leafe.com Subject: Re: Email from foxpro At 19:30 2013-06-05, José Olavo Cerávolo wrote: >Hi All, > >I was trying to find information about emailing from foxpro. >A customer requested a confirmation email to be sent to their clients >when they enroll for an event. >I tried searching the archives but I did not get any hits. >I don't want to be locked into using Outlook. I would not worry much about that. My app does use Outlook via Automation, but it is only one method to change should I want to switch away. Sincerely, Gene Wirchenko [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/161f01ce65f5$e8fb9dc0$baf2d940$@1amsoftware.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Email from foxpro
At 19:30 2013-06-05, José Olavo Cerávolo wrote: Hi All, I was trying to find information about emailing from foxpro. A customer requested a confirmation email to be sent to their clients when they enroll for an event. I tried searching the archives but I did not get any hits. I don't want to be locked into using Outlook. I would not worry much about that. My app does use Outlook via Automation, but it is only one method to change should I want to switch away. Sincerely, Gene Wirchenko ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/ ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Email from foxpro
On Wed, Jun 5, 2013 at 10:30 PM, José Olavo Cerávolo wrote: > > I was trying to find information about emailing from foxpro. > http://www.tedroche.com/papers.php has a couple papers and sample code on using SMTP to send email. You DO NOT want to depend on Microsoft-provided services (Outlook, MAPI, CDO) to send mail, as each major revision breaks previously working code. Also, visit http://fox.wikis.com and search for "email" and you'll find lots of good information. -- Ted "SMTP Good, MAPI Baad!" Roche Ted Roche & Associates, LLC http://www.tedroche.com --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/CACW6n4s5YUi0VRv=ycLPkuQqS8q32EruHqdM2Ay69KYQ6J8C=a...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Email from foxpro
If you don't want to automate Outlook, then Blat is a good option as other folk have said. I would also consider creating a COM component in .NET 4.5, which uses the strong functionality there for SMTP and/or Exchange Web Services emailing, and then use that component from VFP. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1370504977.28638.140661240546909.090be...@webmail.messagingengine.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
RE: Email from foxpro
I'm up against it with time at the moment, so have just copied and pasted some code in here. Rejig it to suit what you need to do DECLARE INTEGER ShellExecute IN shell32.dll ; INTEGER hndWin, STRING cAction, STRING cFileName, ; STRING cParams, STRING cDir, INTEGER nShowWin SELECT store SCAN FOR quantity <> 0 IF quantity < reorder AND EMPTY(sentmail) && so if the qty is lower than the reorder level and they haven't been sent a mail yet. * Then collect some variables for the email lcemail = "mailto:"; + ALLTRIM(store.email) lcstock = ALLTRIM(stock) lcqty = ALLTRIM(STR(quantity)) lcreorder = ALLTRIM(STR(reorder)) lcacmanemail = ALLTRIM(store.acmanemail) * Then build the email lcMail = lcemail + ; "?CC=" + lcacmanemail + "&Subject= Low Stock Warning from Data Direct"+ ; '&Body=This is an automated email from the Data Direct WareHouse Program to notify you that your stock:%0A' + lcstock +; '%0Ais currently at a quantity of ' + lcqty + '%0Awhich is lower than the reorder quantity of ' + lcreorder + ; '%0A%0AIt is time to reorder more: ' + lcstock +; '%0AAnd have it delivered to:%0A%0AData Direct Australia%0A31-33 Chifley Drive%0APreston VIC 3072' ShellExecute(0,"open",lcMail,"","",1) REPLACE sentmail WITH DATETIME() endi ENDSCAN Regards, Christina -Original Message- From: José Olavo Cerávolo [mailto:jocerav...@yahoo.com] Sent: Thursday, 6 June 2013 12:31 PM To: profoxt...@leafe.com Subject: Email from foxpro Hi All, I was trying to find information about emailing from foxpro. A customer requested a confirmation email to be sent to their clients when they enroll for an event. I tried searching the archives but I did not get any hits. I don't want to be locked into using Outlook. Thanks in advance, Olavo. José Olavo Cerávolo http://www.ceravoloconsulting.com/ --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/007901ce6275$57ee6520$07cb2f60$@datahouse.com.au ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Email from foxpro
I use blat, it's easy to set up and use. http://www.blat.net/ From: José Olavo Cerávolo To: "profoxt...@leafe.com" Sent: Wednesday, June 5, 2013 10:30 PM Subject: Email from foxpro Hi All, I was trying to find information about emailing from foxpro. A customer requested a confirmation email to be sent to their clients when they enroll for an event. I tried searching the archives but I did not get any hits. I don't want to be locked into using Outlook. Thanks in advance, Olavo. José Olavo Cerávolo http://www.ceravoloconsulting.com/ --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1370485845.30509.yahoomail...@web161406.mail.bf1.yahoo.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious. ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/1370494072.19299.yahoomail...@web122302.mail.ne1.yahoo.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Email from foxpro
José, you can try VFPWinsock, an opensource project driven by a french MVP Francis FAURE. I use it for a long time and it works like a charm. As the code is given, I think it is easily understandable although I can translate main things to you ... http://www.vfpwinsock.com/ In french, 'download' is 'telecharger' ... The Foxil ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/51b0139b.60...@wanadoo.fr ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Email from foxpro
"José Olavo Cerávolo" wrote: >Hi All, > >I was trying to find information about emailing from foxpro. >A customer requested a confirmation email to be sent to their clients >when they enroll for an event. >I tried searching the archives but I did not get any hits. >I don't want to be locked into using Outlook. > >Thanks in advance, > >Olavo. > > >José Olavo Cerávolo >http://www.ceravoloconsulting.com/ > In addition to what has been mentioned already. CSMail is a COM control available from http://codestone.co.uk. If you only need to send email, blat is a good way to go. -- Tracy ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/f37a2efb-d590-440e-be65-352bb90cf...@email.android.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Email from foxpro
There are several options 1 Use Blat (Google it and you will see) I used for a long time and then many of clients reported it was no longer working because they installed Ultra Fast Broadband 2 So I switched to CDO method go tohttp://fox.wikis.com/wc.dll?Wiki~CdoEmail~VFP for help 3 and if this is not suitable for some reason, I use Outlook, via oOutlook = GetObject(,"Outlook.Application") On Thu, Jun 6, 2013 at 2:30 PM, José Olavo Cerávolo wrote: > Hi All, > > I was trying to find information about emailing from foxpro. > A customer requested a confirmation email to be sent to their clients when > they enroll for an event. > I tried searching the archives but I did not get any hits. > I don't want to be locked into using Outlook. > > Thanks in advance, > > Olavo. > > > José Olavo Cerávolo > http://www.ceravoloconsulting.com/ > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cag1nny97xz0tdi99xlwrdyhdsb3dae6g5zd1oq9x_beivhq...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
Re: Email from foxpro
There are several ways, but my preference is BLAT. Search for "blat vfp" and you'll have a wealth of info. Mike Original Message Subject: Email from foxpro From: José Olavo Cerávolo To: profoxt...@leafe.com Date: 6/5/2013 9:30 PM Hi All, I was trying to find information about emailing from foxpro. A customer requested a confirmation email to be sent to their clients when they enroll for an event. I tried searching the archives but I did not get any hits. I don't want to be locked into using Outlook. Thanks in advance, Olavo. José Olavo Cerávolo http://www.ceravoloconsulting.com/ --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html --- [excessive quoting removed by server] ___ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/51aff60a.4010...@ggisoft.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.