zotchy

Universalist, thank you for the great example. I need to modify it a bit. I have an array with scale [6x4]. The last column (4th) in every row stores a link. So I need to open it making double-click on no matter what column in the row. So. click on cell 1x1 should open link from cell 1x4. click on cell 2x3 should open link from cell 2x4, click on cell 4x2 should open link from cell 4x4 ...and so on. I hope I was clear enough))) Thank you!

First of all. This UDF is brilliant!!! It was very helpful! Could you kindly assist me with couple of issues here? Here is my case. I need to update cells by array returned from SQL server. This is the part: if $rs.RecordCount Then $i=0 while not $rs.EOF _GUICtrlListView_AddItem($cListView1,$rs.Fields(0).Value, $i) for $j = 1 to 4 if $j = 4 Then _GUICtrlListView_AddSubItem($cListView1,$i,$rs.Fields($j), $j) ; this cell ($j=4) contains a hyperlink EndIf _GUICtrlListView_AddSubItem($cListView1,$i,$rs.Fields($j).Value, $j) Next $rs.MoveNext $i=$i+1 WEnd EndIf Update is working as expected and no problems here. But one of columns from SQL DB contains a hyperlink, which I need to convert to hyperlink (word a "Link" with hyperlink behind). As far as I understand inserting of hyperlinks is not that obvious. All examples on the forum are explaining how to work with lables, but my case is not similar. And another question is very simple: how to copy something from the table? Ctrl+C is not working. Thank you for your assistance.

Everything is clear now. Thank you very much for your assistance.

This is what I have: http://funkyimg.com/u2/2038/400/964514autoit.png

Great. But I have a Body with tables and pictures. Once I try to call array asBody[1][1] and make a replacement, it deletes all formatting and pictures. Thanks

Good. Thank you very much for your help. But I have a problem with returning values from "Body", "CC" etc. Once I try to get result of variable $sBody (Item = Body), it returns nothing to MsgBox. So I am not able to update/replace strings. Thanks Dmitry

Could you please provide me the example? How can I call a particular property? For example field TO:? Is the syntax correct? $oItem = _OL_ItemCreate($oOutlook, $olMailItem, "*", @ScriptDir & "unplanned_template.oft") $aOL_Properties = _OL_ItemGet($oOutlook, $oItem[1][0], Default, "??????") What options should I use instead of ?????? Thanks Dmitry

It works now! Thanks. What function should we use to modify parameters of $oItem? (replace a text in Body for example)

It returns '0' for both.

I have a problem creating mail based on a template. When I use function _OL_ItemCreate it renurns error. I have a script in standard AutoIt folder "Include". I have template there. I want to create mail in the same folder $oItem = _OL_ItemCreate($oOutlook, $olMailItem, "*", @ScriptDir & "unplanned_template.oft") No errors appear, but mail is not being created as well. Also how should I call this create email? I need to check the content in it and modify it by required values from GUI. Thank you for help.

Thanks for replyI have an Outlook

Dear Colleagues, I have a task to generate an email from GUI. This is what I have. 1. GUI with some drop-down lists; 2. Some template in HTML (or msg format) with markers. I need to generate an email. Script should open a template, replace markers with values from GUI and open it in MSG format. To, BC, BCC, Subject should be filled as well to allow me to make some modifications and press Send button. Do you have some scripts for that? Thank you very much for the help.

Dear Zedna, Thank you very much for your help. I think I know what this issue about. It is all about connection. Not with server but with creadentials. The SQL is using Windows Authentification. And it is not possible to use connection under another account(((. That's why script returns error.

Zedna, I added: $conn = ObjCreate("ADODB.Connection") @error Also I changed connection closure line. The message is the same.

We have here the error line, but I do not have line with such number. During compilation it compiles all libraries which I use in script. So it is very hard to determine exact line.