Interesting! I have, AFAIK, the latest Office 365 running on Win 10 1909 and mine shows Microsoft Outlook for Office 365 MSO (16.0.12624.20422) 32-bit.
Curiouser and curiouser.
John
John Weller 01380 723235 07976 393631
-----Original Message----- From: ProfoxTech profoxtech-bounces@leafe.com On Behalf Of Charlie Coleman Sent: 20 April 2020 12:16 To: profoxtech@leafe.com Subject: Re: Office automation using VFP 10 64-bit version
- In Outlook, I went to File, then Office Account, then clicked "About Outlook" - Near the top of the resulting screen I saw "Microsoft Outlook for Office 365 MSO (16.0.11929.20618) 64-bit" (and of course there were "TM"s spread around in that string). - Then I went to VFP and opened up the code I had used a while back. The 'basic' design of it is as follows:
oOutlook = CREATEOBJECT('outlook.application') ... oMsg = oOutlook.CreateItem(0) oMsg.to = <email address> oMsg.from = <the from address> oMsg.subject = <some subject line> oMsg.htmlbody = <my email message, a fantastically formatted and built/styled HTML message I might add.... :) >
*-- maybe there was another step or two - but you get the gist
*-- then actually sent the message. oMsg.send()
I did the above this past Friday (4/17/2020) - grabbing out some of that code and ran lines of it from the VFP command prompt (the actual code would have sent out about 100 emails for a 'crisis' situation that did not exist so I did not want to trigger that - heh). But the email I created with the above process was sent and delivered (to myself at a couple different email addresses I have). According to the "About" VFP - I am using VFP SP2, version 09.00.0000.5815.
Of course, this was ONLY Outlook. It was not Word, Excel, or Powerpoint. But it does clearly call itself 64-bit. Now.... based on MS's past behavior I certainly do not expect them to be honest. But trying to deceive at this level would seem a little ridiculous even for them.
I will add that I do not know if we perhaps started with 32-bit Office at one point and then migrated to 365 64-bit. This particular PC was set up about 11 months ago. And given MS's poor history of cleaning up after itself, there may be 32-bit libraries hanging around.
Note that I have installed 32-bit MS SQL ODBC drivers on the machine. I kind of doubt that would have an impact, but its hard to tell without a lot of library-calls tracking work (which I do not feel like doing...).
I have some Powerpoint automation code around here somewhere. Maybe I'll give that a try too.
But the thing that started this whole thread was whether or not the "VFP 10" (64bit VFP?) version would be able to do automation into "64bit" Office stuff. So even if my 32-bit example is 'magic' are we still thinking the 64bit VFP would not work with 64bit Office?
Maybe it would be worth sharing/creating several code samples that we have used for 'Office automation', store them somewhere, and then use those as a quick-test set for any new VFP release or compatible product...
-Charlie