If your client is not using Gmail than VFPWinsock is the easiest app to
mail with attachments
Koen
Op wo 21 aug. 2019 om 08:58 schreef John Weller
> I use CDO to do just that. I’m not in the office until later today but
> when I get in I’ll send you some sample code if you wish?
>
> John
>
> Jo
If you want to use Outlook:
loOutlook=CreateObject("Outlook.Application")
loMsg = loOutlook.CreateItem(0)
loMsg.BodyFormat= 2
&& olFormatHTML
loMsg.HtmlBody="HTML body text"
loMsg.Body = "Plain body text for clients without HTML mail suppo
Make sure you are using ODBC Data Sources (32-bit) and in the Drivers tab
you'll see which drivers you have for SQL.
I have ODBC Driver 17 for SQL Server, SQL Server and SQL Server Native
Client 11.0
I prefer to use a connection string rather than DSN so that I don't have to
set up a DSN on each cl
I use SQL native client (which is an option to install when installing SQL
server):
https://www.microsoft.com/en-us/download/details.aspx?id=50402
And then I use a connection string like:
ConnectionString=DRIVER=SQL Server Native Client
11.0;Trusted_Connection=Yes;DATABASE=GoldBuy;SERVER=MySer
Mike,
along with Alan's code you can use loMsg.Display() to display the email
on screen before sending.
Frank.
Frank Cazabon
On 21/08/2019 04:17 AM, Alan Bourke wrote:
If you want to use Outlook:
loOutlook=CreateObject("Outlook.Application")
loMsg = loOutlook.CreateItem(0)
loMsg.BodyFormat
Now got it working with SQLSTRINGCONNECT() thanks.
I will have a look at this native client. Does that give you any
advantages over the ODBC connection?
Also noticed in an archive post someone using this to check the
connection before doing a real query/update.
nResult=SQLEXEC(datahandle,'SELECT
On Wed, Aug 21, 2019 at 12:22 AM MB Software Solutions, LLC <
mbsoftwaresoluti...@mbsoftwaresolutions.com> wrote:
> VFP9SP2 app
>
> Customer uses Outlook and wants the app to generate an email to a given
> email address from the app AND attach certain documents to it. Customer
> will preview it a
An ODBC connection has to be created on every workstation, as well as
installing a SQL Client as well. I'd avoid the ODBC route and go straight
SQL Client that does have to be installed on each machine. Pick a higher
Client version number such as 10 or 11 today.
connectionString="Data Source=SE
Teams is a nice upgrade over Skype for Business. Your O365 probably is on a
monthly or semi-annual update and got it automatically yesterday.
Eric
On Wed, Aug 21, 2019 at 1:28 AM Chris Davis wrote:
> If you have Office365 and had Skype for Business installed then Microsoft
> Teams is it's repla
Teams is a nice upgrade to what Skype was. We use it here to message a
group of people, add in planner to task people and see if they have done
their parts or tasks.
When I first saw it it was after updating something from M$ on my laptop.
Since then our company is testing Office 365 usage and th
Michael,
A better option than Outlook (ugh!): Check out SendGrid (now part of Twilio).
Malcolm
___
Post Messages to: ProFox@leafe.com
Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox
OT-free version of this list: http://mail.leaf
I feel better now... 😊
--
rk
-Original Message-
From: ProfoxTech On Behalf Of Ted Roche
Sent: Wednesday, August 21, 2019 9:37 AM
To: profoxt...@leafe.com
Subject: Re: Easiest/best way to create an email using local MS Outlook with
file attachments?
And remember, kids, MAPI Bad! SMTP
> A better option than Outlook (ugh!): Check out SendGrid (now part of Twilio).
SendGrid, MailJet et al are definitely the way to go for bulk emailing, however
are possibly overkill for sending occasional one-off messages from an
application, which is what I took the requirement to be.
"I'm al
> SendGrid, MailJet et al are definitely the way to go for bulk emailing,
> however are possibly overkill for sending occasional one-off messages from an
> application, which is what I took the requirement to be. "I'm already paying
> for Office 365, why am I paying for SendGrid on top to send a
As promised. This example uses a Gmail account.
lcErr = ""
lcSchema = "http://schemas.microsoft.com/cdo/configuration/";
loConfig = CREATEOBJECT("CDO.Configuration")
WITH loConfig.FIELDS
.ITEM(lcSchema + "smtpserver") = "smtp.gmail.com"
Wow. Lots of stuff to check out there. Will definitely be checking out
the SQL server stuff even though I'm not writing the new software. I
could well be writing some reports though.
Thanks,
Peter Cushing
IT Department
WHISPERING SMITH
On 21/08/2019 14:40, Stephen Russell wrote:
> An ODBC co
Thanks for the info. I don’t use skype so... But at least I know what it is.
Thanks!
-Original Message-
From: ProFox On Behalf Of Eric Selje
Sent: Wednesday, 21 August 2019 11:14 PM
To: ProFox Email List
Subject: Re: [NF] Microsoft Teams
Teams is a nice upgrade over Skype for Business.
This client is using OUTLOOK, not Gmail.
On 8/21/2019 3:10 AM, Koen Piller wrote:
If your client is not using Gmail than VFPWinsock is the easiest app to
mail with attachments
Koen
Op wo 21 aug. 2019 om 08:58 schreef John Weller
I use CDO to do just that. I’m not in the office until later
Yes, thanks...spec calls for user to review everything and they have the
responsibility to press Send...the app will not auto-send it.
On 8/21/2019 7:40 AM, Frank Cazabon wrote:
Mike,
along with Alan's code you can use loMsg.Display() to display the
email on screen before sending.
Frank.
F
On 8/21/2019 9:58 AM, Malcolm Greene wrote:
Michael,
A better option than Outlook (ugh!): Check out SendGrid (now part of Twilio).
Hi Malcolm,
But this customer--who uses Outlook currently--wants the email "prepped,
ready, and shown" in Outlook so they can review and just press the Send
bu
Hi John,
Thanks for your code below. It's pretty much exactly what I use for my
bug reporting where the app automatically sends an email. However, in
this case, the customer WANTS to see it in Outlook and review it
themselves before pressing the Send button to email it. (Paranoia?)
Thanks t
So maybe make the loMsg object visible and don’t invoke the Send() method?
--
rk
-Original Message-
From: ProfoxTech On Behalf Of MB Software
Solutions, LLC
Sent: Wednesday, August 21, 2019 5:31 PM
To: profoxt...@leafe.com
Subject: Re: Easiest/best way to create an email using local MS
Well that answer sounds like the obvious easy answer but I kinda thought
that using this component was all for a seamless emailing and did not
have a visible component. I'll test that out and report back.
Basically, I thought there was no visible email client with this approach?
On 8/21/2019
23 matches
Mail list logo
