RonSurn Posted January 29, 2018 Share Posted January 29, 2018 Hello Water I just used you wrapper script, intend to reade the - email address - email subject - email body from the excel .... anyway i have some problem, i found that when the email body exceed than 256 character then the email body will be blank !!! while the short message the code below are working fine, any suggestion ??? Thank you very much Regards Ron #include<excel.au3> #include <OutlookEX.au3> ;Local $sString = String(10) $i = 0 While $i <= 2 ; MsgBox(0, "Value of $i is:", $i) $i = $i + 1 Local $Open_Excel = _Excel_Open() Local $File_Path = "D:\autoit\email_list.xlsx" Local $Open_WorkBook = _Excel_BookOpen($Open_Excel,$File_Path) WinActivate($Open_WorkBook) Local $Read_Excel_address = _Excel_RangeRead($Open_WorkBook,Default,"A"&$i) Local $Read_Excel_Subject = _Excel_RangeRead($Open_WorkBook,Default,"B"&$i) Local $Read_Excel_MailBody = _Excel_RangeRead($Open_WorkBook,Default,"C"&$i) _Excel_Close($Open_Excel, False) Global $oOutlook = _OL_Open() Global $bodyvar = $Read_Excel_MailBody Global $recipientAddress = $Read_Excel_address Global $subjectvar = $Read_Excel_Subject _OL_Wrapper_SendMail($oOutlook, $recipientAddress, "", "", $subjectvar, $bodyvar) If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF: _OutlookSendMail Wrapper Script", "Error sending mail. @error = " & @error & ", @extended: " & @extended) Wend Link to comment Share on other sites More sharing options...
water Posted January 29, 2018 Share Posted January 29, 2018 According to the help file there is a solution Quote The Excel transpose method doesn't support cells with more than 255 characters. Set $bForceFunc = True to bypass this limitation(s). hugomito 1 My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
RonSurn Posted January 30, 2018 Share Posted January 30, 2018 Water, thank you for shading the light ... appreciated !!! Link to comment Share on other sites More sharing options...
water Posted January 30, 2018 Share Posted January 30, 2018 My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
hugomito Posted June 21, 2018 Share Posted June 21, 2018 On 1/29/2018 at 5:28 AM, water said: $bForceFunc = True Thanks a lot Master. It solved my issue too. Regards, Link to comment Share on other sites More sharing options...
water Posted June 21, 2018 Share Posted June 21, 2018 My UDFs and Tutorials: Spoiler UDFs:Active Directory (NEW 2022-02-19 - Version 1.6.1.0) - Download - General Help & Support - Example Scripts - WikiExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example ScriptsOutlookEX (2021-11-16 - Version 1.7.0.0) - Download - General Help & Support - Example Scripts - WikiOutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - DownloadOutlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - WikiPowerPoint (2021-08-31 - Version 1.5.0.0) - Download - General Help & Support - Example Scripts - WikiTask Scheduler (NEW 2022-07-28 - Version 1.6.0.1) - Download - General Help & Support - Wiki Standard UDFs:Excel - Example Scripts - WikiWord - Wiki Tutorials:ADO - WikiWebDriver - Wiki Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now