ProFox September 2019

profox@leafe.com

30 participants
24 discussions

Outlook Redemption tool
by MB Software Solutions, LLC 04 Sep '19

04 Sep '19

I have a need to use MAPI (yes, I know Ted et al: MAPI bad, SMTP good...but this customer wants to see a system generated email in Outlook, review it including file attachment, and then press Send manually). I thought I was going to have to use the Redemption tool to get around the security issues with Outlook but I'm stunned that this simple code worked on my laptop which has Outlook 2016 on it: LOCAL oOutlook as Outlook.Application, oNamespace as Outlook.NameSpace, oMailItem as Outlook.MailItem oOutlook = CREATEOBJECT("Outlook.Application") #DEFINE olFolderDisplayNormal 0 #DEFINE olMailItem 0 oNameSpace = oOutlook.GetNameSpace("MAPI") oExplorer = oOutlook.Explorers.Add(oNameSpace.Folders[1],olFolderDisplayNormal) oMailItem = oOutlook.CreateItem(olMailItem) WITH oMailItem .Subject = 'Testing email send' .Body = "Thank you for your participation in the test at " + TTOC(DATETIME()) .Recipients.Add("mbabcock(a)mbsoftwaresolutions.com") .Attachments.Add("C:\crap\MyFile.pdf") .Save() *.Send() && commented out for now as I don't want to auto-send...user wants to review and manually Send ENDWITH oExplorer.Activate() This is basically using the code from the Microsoft Office Automation with Visual FoxPro book from HWP. (Thanks for the cue, Ted!). Now the comment and question: 1. I'm amazed that Outlook 2016 let me do this without any warning/blocking. I was thinking I'd have to use the Outlook Redemption add-in tool (http://www.dimastr.com/redemption/) 2. The sample code above saves it to the Drafts folder but when I open OL via the last line (oExplorer.Activate()), I was hoping to have the email front and center so the user could just press the Send button after reviewing it manually on screen. Any ideas how to achieve that? tia, --Mike --- This email has been checked for viruses by Avast antivirus software. https://www.avast.com/antivirus --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

8 13

FoxPro 2.6a for Chromebooks
by Charles Hart Enzer, M.D. 03 Sep '19

03 Sep '19

I can't find a site from which can download the Foxpro 2.6a app for my Chromeboook -- Android OS *Shai / שי **Charles Hart Enzer, MD(Ohio, USA), FAACAP* *Aliyah <https://en.wikipedia.org/wiki/Aliyah>: Cincinnati to Jerusalem <http://www.gojerusalem.com/items/263/German-Colony/>'s German Colony <https://en.wikipedia.org/wiki/German_Colony,_Jerusalem> May, 2017* *Volunteer Associate Professor of PsychiatryUniversity of Cincinnati Medical CenterWebSite: **EnzerMD.com <http://EnzerMD.com>* *Publications* <http://www.enzermd.com/CV.html#Publications> *Tiny Country, Huge Dreams* *ארץ זעירה, **חלומות ענקיים* *עם ישראל חי* --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

11 23

SMB
by Chris Davis 03 Sep '19

03 Sep '19

Hi All With any networked VFP application sharing a DBC the SMB performance of the server hosting the DBC is very important? Assuming your answer to the above question is Yes or Of Course, then when you have one server that seems to perform well and one that doesn't it would be useful to easily compare the setup of the two. Is anyone aware of any utilities that make the configuration and tweaking of SMB easy or at least allow you to compare to setups? Of course, if your answer to the first question isn't yes I would also be interested in your thoughts. I know there is a lot more that comes into the performance of an application other than the setup of the server, i.e the spec of the client, the os of the client, other software such as anti virus, network infrastructure etc etc. Where I am going with this... We have lots of sites where an application works well and one site where it doesn't, and without having to spend hours and hours investigating all the various settings and registry entries, I just want to start with the servers and make a comparison to see if there are any obvious differences. Thanks Chris. --- StripMime Report -- processed MIME parts --- multipart/alternative text/plain (text body -- kept) text/html ---

5 12

ProFox List Statistics for August 2019
by List Administrator Account 01 Sep '19

01 Sep '19

================================================== ProFox List Statistics August 2019 ================================================== Subscriber Count at End of Month: ProFox: 291 ProFoxTech: 182 ================================================== Total Posts: 204 (Up 29.11% from July 2019) Total [OT] Posts: 0 (Down 100.0% from July 2019) Total [NF] Posts: 49 (Down 22.22% from July 2019) Daily Message Counts for August 2019 ------------------------------------------------ DOW Date Count --- ---- ----- T 1 - 7 F 2 - 20 M 5 - 3 T 6 - 9 W 7 - 2 S 11 - 1 M 12 - 1 T 13 - 12 W 14 - 5 T 15 - 11 F 16 - 9 S 17 - 12 S 18 - 2 M 19 - 11 T 20 - 26 W 21 - 27 T 22 - 2 F 23 - 11 M 26 - 3 T 27 - 9 W 28 - 2 T 29 - 2 F 30 - 14 S 31 - 3 Message Counts By Day of Week for August 2019 ------------------------------------------------ DOW Count --- ----- Sun - 3 Mon - 18 Tue - 56 Wed - 36 Thu - 22 Fri - 54 Sat - 15 Distinct Posters to the List (changes relative to July 2019) ------------------------------------------------ Non-OT messages: 40 (Up 2.56%) OT messages: 0 (Down 100.0%) NF messages: 19 (Down 5.0%) Total number: 40 (Up 2.56%) Top 20 Contributors by Number of Non-OT Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 21 MB Software Solutions, LLC 2. 16 Ted Roche 3. 16 Alan Bourke 4. 11 Johan Nel 5. 10 Charles Hart Enzer, M.D. 6. 9 John Weller 7. 9 Chris Davis 8. 8 Frank Cazabon 9. 8 Paul Newton 10. 6 Richard Kaye 11. 6 Peter Cushing 12. 6 Ken Dibble 13. 6 Tracy Pearson 14. 5 Stephen Russell 15. 5 Gene Wirchenko 16. 5 Eric Selje 17. 5 Malcolm Greene 18. 5 Paul H. Tarver 19. 4 Kurt @ Gmail 20. 4 <juergen(a)wondzinski.de> Top 0 Contributors by Number of OT Posts ------------------------------------------------ | Posts OT% Contributor | ------------------------------------------------ Top 19 Contributors by Number of NF Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 7 Charles Hart Enzer, M.D. 2. 6 Ted Roche 3. 6 Ken Dibble 4. 4 Johan Nel 5. 3 MB Software Solutions, LLC 6. 3 Alan Bourke 7. 3 Michael Oke, II 8. 2 Gene Wirchenko 9. 2 <datades(a)adam.com.au> 10. 2 Gérard LOCHON 11. 2 Stephen Russell 12. 2 Kurt at VR-FX 13. 1 Chris Davis 14. 1 Eric Selje 15. 1 Richard Kaye 16. 1 CCTbySteveGraves 17. 1 davethayer(a)gmail.com 18. 1 Kurt @ Gmail 19. 1 Malcolm Greene Top 20 Contributors by Total Number of Posts ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 21 MB Software Solutions, LLC 2. 16 Ted Roche 3. 16 Alan Bourke 4. 11 Johan Nel 5. 10 Charles Hart Enzer, M.D. 6. 9 John Weller 7. 9 Chris Davis 8. 8 Frank Cazabon 9. 8 Paul Newton 10. 6 Richard Kaye 11. 6 Peter Cushing 12. 6 Ken Dibble 13. 6 Tracy Pearson 14. 5 Stephen Russell 15. 5 Gene Wirchenko 16. 5 Eric Selje 17. 5 Malcolm Greene 18. 5 Paul H. Tarver 19. 4 Kurt @ Gmail 20. 4 <juergen(a)wondzinski.de> Top 18 Contributors by Number of New Threads Started ------------------------------------------------ | Posts Contributor | ------------------------------------------------ 1. 6 Johan Nel 2. 4 Charles Hart Enzer, M.D. 3. 3 MB Software Solutions, LLC 4. 3 <juergen(a)wondzinski.de> 5. 2 Gene Wirchenko 6. 2 Alan Bourke 7. 2 Chris Davis 8. 1 John Weller 9. 1 List Administrator Account 10. 1 Ed Leafe 11. 1 Ted Roche 12. 1 Peter Cushing 13. 1 Paul Newton 14. 1 Bill Anderson 15. 1 Brian 16. 1 Rick Schummer 17. 1 Paul H. Tarver 18. 1 Ken Dibble Top 20 Non-OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 18 [NF] Seeking well-equipped laptop recommendations 2. 17 SQL server connection 3. 17 Happy Anniversary! 4. 14 Easiest/best way to create an email using local MS Outlook with file attachments? 5. 14 FoxPro 2.6a for Chromebooks 6. 12 Get file path and name from file handle 7. 12 Working with multi-page PDF files and automatically labeling and later extracting select pages 8. 11 [NF] Search String 9. 8 SMB 10. 8 SFTP 11. 7 X# Bandol GA 2.0 released 12. 7 [NF] Chromebook End of Automatic Updates 13. 7 So how many classes in a VCX is *too* many ... 14. 6 Easiest/best way to create an email using local MS Outlook with file attachments? 15. 6 Timing Issue 16. 6 [NF] Microsoft Teams 17. 5 SET DEFAULT or ? 18. 5 Thor Updates and VFPX GitHub site 19. 3 Using Chilkat Tools with VFP 20. 2 SWFOX Post conference training session Top 0 OT Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ Top 20 Threads by Total Number of Posts ------------------------------------------------------------------ | Posts Subject | ------------------------------------------------------------------ 1. 18 [NF] Seeking well-equipped laptop recommendations 2. 17 SQL server connection 3. 17 Happy Anniversary! 4. 14 Easiest/best way to create an email using local MS Outlook with file attachments? 5. 14 FoxPro 2.6a for Chromebooks 6. 12 Get file path and name from file handle 7. 12 Working with multi-page PDF files and automatically labeling and later extracting select pages 8. 11 [NF] Search String 9. 8 SMB 10. 8 SFTP 11. 7 X# Bandol GA 2.0 released 12. 7 [NF] Chromebook End of Automatic Updates 13. 7 So how many classes in a VCX is *too* many ... 14. 6 Easiest/best way to create an email using local MS Outlook with file attachments? 15. 6 Timing Issue 16. 6 [NF] Microsoft Teams 17. 5 SET DEFAULT or ? 18. 5 Thor Updates and VFPX GitHub site 19. 3 Using Chilkat Tools with VFP 20. 2 SWFOX Post conference training session

1 0

2026

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

ProFox September 2019