How to open .CSV file and attach it in my Gmail Account

[Trisha]

I tried (using AutoIt) to automate a scenario where Internet Explorer will open a specific URL. Next I click on a link to download a .doc file. Then I want to open this file and attach it in my Gmail Account.

I did as far as the download step. Now, how would I open the file which is stored in Downloads folder, and attach in Gmail?

The sample code below is not opening the file as expected:

WinActivate("Downloads")
Sleep(2000)
;Local Const $sTestPath = _PathFull("C:\Users\camanjana\Downloads\xyz.doc")
$hFile = Fileopen("xyz.doc")
$FileContent = FileRead($hFile)
FileClose($hFile) 

[Trisha]

2 minutes ago, Trisha said:

I tried (using AutoIt) to automate a scenario where Internet Explorer will open a specific URL. Next I click on a link to download a .doc file. Then I want to open this file and attach it in my Gmail Account.

I did as far as the download step. Now, how would I open the file which is stored in Downloads folder, and attach in Gmail?

The sample code below is not opening the file as expected:

WinActivate("Downloads")
Sleep(2000)
;Local Const $sTestPath = _PathFull("C:\Users\camanjana\Downloads\xyz.csv")
$hFile = Fileopen("xyz.csv")
$FileContent = FileRead($hFile)
FileClose($hFile) 

[Trisha]

I tried (using AutoIt) to automate a scenario where Internet Explorer will open a specific URL. Next I click on a link to download a .doc file. Then I want to open this file and attach it in my Gmail Account.

I did as far as the download step. Now, how would I open the file which is stored in Downloads folder, and attach in Gmail? Please help me with the issue.

The sample code below is not opening the file as expected:

WinActivate("Downloads")
Sleep(2000)
;Local Const $sTestPath = _PathFull("C:\Users\camanjana\Downloads\xyz.csv")
$hFile = Fileopen("xyz.csv")
$FileContent = FileRead($hFile)
FileClose($hFile) 

[kylomas]

Trisha,

How do you know it is not being opened?  Try running it like this...

WinActivate("Downloads")
Sleep(2000)
;Local Const $sTestPath = _PathFull("C:\Users\camanjana\Downloads\xyz.csv")
$hFile = Fileopen("xyz.csv")
if $hFile = -1 then exit msgbox(17,'Error','File open error')
$FileContent = FileRead($hFile)
msgbox(0,'',$FileContent)
FileClose($hFile)

What is the WinActivate for?

kylomas

Edited January 22, 2018 by kylomas

[Trisha]

Hello kylomas, 

I was trying to give focus to "Downloads" folder, because the .CSV file is there only.

 

[gruntydatsun]

Hi Trisha,

The link below discusses your problem pretty well.

If you do your searching from google instead of the search window in this form and use the term "AutoIT ThingUWantToDoHere" there's a huge amount of quality advice.  Great community here.

You don't need to open the file.  Just attached it as the example above shows

 

Edited January 22, 2018 by gruntydatsun

[lewisg]

9 hours ago, Trisha said:

Hello kylomas, 

I was trying to give focus to "Downloads" folder, because the .CSV file is there only.

 

In your code above "WinActivate("Downloads")" give focus (i.e. highlights) a "window" on your screen, not to the script. You were on the correct track with 

;Local Const $sTestPath = _PathFull("C:\Users\camanjana\Downloads\xyz.csv")
$hFile = Fileopen("xyz.csv")

Either uncomment the "Local Const $sTestPath.....bla..bla.... and use that variable as the argument in the Fileopen function of the next line or add the quoted full path as the argument.

However gruntydatsun link and suggestion will take you to your final goal. 

[JLogan3o13]

@Trisha please stick to one thread in the future.  Spamming your question multiple times on the forum is not going to get you an answer any more quickly.

[Trisha]

@JLogan3o13 As i am new to this forum, got confused where to post. Earlier i posted in AutoIT Technical forum; After reading comments i get to know to post it here. 

[Trisha]

@lewisg Thank you for the help. I have done that using the below code.

Local $sWorkbook = @ScriptDir & "\_Excel.csv"
Local $oExcel = _Excel_Open()

 

[Trisha]

@gruntydatsun Thank you for your hint. Now i was trying to do with Outlook. There is one UDF related to Outlook, And i tried to add in Scite  config tool, But after finishing it. when i reopen the Scite Editor , Its not working.Please help me out with this.

Sorry for this silly question :-) 

[Trisha]

@water could you please help me out with the scenario , where i want to send mail through outlook to more than one people with attachment.

I tried your scripts OutlookEX one. and i wrote code accordingly:

Global $oOutlook = _OL_Open()
If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF", "Error creating a connection to Outlook. @error = " & @error & ", @extended = " & @extended)

Global $sCurrentUser = $oOutlook.GetNameSpace("MAPI").CurrentUser.Name

;_OL_Wrapper_SendMail($oOutlook, $sCurrentUser, sucheta.deb@accenture.com, "", "", "TestSubject", "Testing Purpose", @ScriptDir & "\_Excel.csv", $olFormatHTML, $olImportanceHigh)
;If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF: _OutlookSendMail Wrapper Script", "Error sending mail. @error = " & @error & ", @extended: " & @extended)
;MsgBox(64, "OutlookEX UDF: _OutlookSendMail Wrapper Script", "Mail successfully sent to user '" & $sCurrentUser & "'!")

;Sending Mail

Global $oItem = _OL_ItemCreate($oOutlook, $olMailItem, "*\Outlook-UDF-Test\TargetFolder\Mail", "", _
  "Subject=TestMail", "BodyFormat=" & $olFormatHTML, "HTMLBody=Bodytext in <b>bold</b>.", "To=anjana.prajapati@company.com;xyz.asag@company.com")
; Send the mail
Global $aOL_Item = _OL_ItemFind($oOutlook, "*\Outlook-UDF-Test\SourceFolder\Mail", $olMail, "", "", "", "EntryID")
Global $oItem1 = _OL_ItemAttachmentAdd($oOutlook, $aOL_Item[1][0], Default, @ScriptDir & "\_Excel.csv")
_OL_ItemSend($oOutlook, $oItem)
 

[water]

I'm, a bit late. Sorry about that.
This script works for me:

#include <OutlookEX.au3>

Global $oOutlook = _OL_Open()
If @error <> 0 Then Exit MsgBox(16, "OutlookEX UDF", "Error creating a connection to Outlook. @error = " & @error & ", @extended = " & @extended)

Global $oItem = _OL_ItemCreate($oOutlook, $olMailItem, "", "", _
        "Subject=TestMail", "BodyFormat=" & $olFormatHTML, "HTMLBody=Bodytext in <b>bold</b>.", "To=Jon.Doe@company.com;Jane.Doe@company.com")

_OL_ItemAttachmentAdd($oOutlook, $oItem, Default, @ScriptDir & "\_Excel.csv")
_OL_ItemSend($oOutlook, $oItem)

 

[Trisha]

@water Thank you so much for this great UDF. It works well as expected

[water]

Glad you Like this UDF  

[Trisha]

@water Need your help again  How can I move from my host machine(currently I am using windows 10) to VMware. I ran the VMware.exe, after giving login credential VMWare got open but I am not able to run any application "using run("xyz.exe"), I think VMWare window itself is not getting activated. Below is my code:

Run("C:\Program Files (x86)\VMware\VMware Horizon View Client\vmware-view")
WinWaitActive("VMware Horizon Client")
MouseClick("left",193,292,2)
WinWaitActive("Login")
Send("feb@2018")
Send("{TAB}")
Send("{TAB}")
Send("{Enter}")
If WinExists("VMware Horizon Client") Then
 WinWaitActive("VMware Horizon Client")
  MouseClick("left",224,274,2)
EndIf

WinWaitActive("alcala")
Run(xyz.exe)

[water]

Run always executes on the machine you run your AutoIt script.
The VMWare client is just another computer in the network. Use PSExec ore something similar to start xyz.exe on this c omputer.