how to copy one cell at a time from excel sheet and parse the data into outlook mail?

[sumandevadiga]

Hello Water, 

Local $clientname = StringStripWS(ControlGetText($hWnd, '', 'TEIEdit106'),8) ;getting the client name

I mean if suppose in system client name is "ABC LTD" but i get output from controlgettext "ABCLTD" without any space between, how to get variable data as it is. 

2nd query was if suppose user would like to process for muliple files,how to go about that

 Local $filenumber = InputBox("Input Box", "Enter your File numbers.")

Above case this give option to update only 1 file number, if there are mutilple file numbers, what will be code? 

 

 

[water]

You are using the wrong flag for StringStripWS. Please check the help file for the proper flag to remove leading/trailing and doubl whitespace.

The user could enter a separator character and enter multiple file numbers this way e.g. "number1;number2;number3". Then use StringSplit to retrieve each file number.

[sumandevadiga]

Hello Water, 

Local $clientname = StringStripWS(ControlGetText($hWnd, '', 'TEIEdit106'),8) ;getting the client name

I mean if suppose in system client name is "ABC LTD" but i get output from controlgettext "ABCLTD" without any space between, how to get variable data as it is. 

2nd query was if suppose user would like to process for muliple files,how to go about that

 Local $filenumber = InputBox("Input Box", "Enter your File numbers.")

Above case this give option to update only 1 file number, if there are mutilple file numbers, what will be code? 

 

 

[sumandevadiga]

Hello Water, Thank you

[sumandevadiga]

On 3/10/2017 at 0:36 AM, water said:

 

Come on, that's not too hard to put some quotes around the HTML code and concatenate with $sBody

 

Hello Water,

 

I have tried to put quotes around HTML code however am getting error, can you please help on this

[water]

Global $sBody = $sStyle & "<Table><TR><TD>" & $sshpordr & "<TD>" & $var & "</TD></TD></TR><TR><TD>" & $onhandnmbr & "<TD>" & $onhand & "</TD></TR></TD><TR><TD>" & $omnmbr & "<TD>" & $iomb & "</TD></TD></TR>" & _
"<TR><TD>" & $cfs & "<TD>" & $cfs1 & "</TD></TD></TR><TR><TD>" & $point & "<TD>" & $point1 & "</TD></TD></TR><TR><TD>" & $ctc & "<TD>" & $ctc1 & "</TD></TD></TR><TR><TD>" & $chb & "<TD>" & $chb1 & "</TD></TD></TR><TR><TD>" & $hpr1 & "<TD>" & $shpr & "</TD></TD></TR><TR><TD>" & $cnee1 & "<TD>" & $cnee & "</TD></TD></TR><TR><TD>" & $sVessel & "<TD>" & $vsl1 & "</TD></TD></TR><TR><TD>" & $voyage & "<TD>" & $voy1 & "</TD></TD></TR><TR><TD>" & $etd & "<TD>" & $bkd1 & "</TD></TD></TR><TR><TD>" & $custom & "<TD>" & $lrd1 & "</TD></TD></TR><TR><TD>" & $final & "<TD>" & $dlv & "</TD></TD></TR><TR><TD>" & $pos & "<TD>" & $ponum1 & "</TD></TD></TR><TR><TD>" & $inv & "<TD>" & $invnum1 & "</TD></TD></TR><TR><TD>" & $pkg & "<TD>" & $pkgs & "</TD></TD></TR></TABLE>" & _
'<p><span lang="en-us" sytle="font-family:Arial, sans-serif;color:#000080;"xml:lang="en-us">Please note the following >>>>><br/br/>' & _
'1. hello</span><span lang="eng-us" style="font-size:12pt;font-family:"Times New Roman",serif;"xml:lang="en-us"></span></p><p></p>'

Wasn't too hard, was it?

[sumandevadiga]

Hello Water,

You are simply  great and magician but for me its little bit difficult,still trying to figure out, how did you do that

What if i want to add these quotes before table? 

 

[water]

Just do it! You now know how HTML should be enclosed in quotes.
The web is full of easy to read/understand HTML tutorials.

[sumandevadiga]

Hello Water,

Thank you for inspiration and motivation, am able to complete these quotes.

[water]

[sumandevadiga]

Hello Water,

My project is almost complete only because of you, my last activity is to scan this email to my internal system for that we have option Print2edoc which directly this email to our system,Autoit window not giving any information, attached is the screen shot

[water]

You could use this UDF to set the default printer,

then run _OL_ItemPrint to print the mail.

[sumandevadiga]

Hello Water,

I want to keep cursor at delivery "SOU" and press F6 button(ie Help), how to move cursor via Autoit

[water]

Use function ControlSend.

[sumandevadiga]

Hello Water,

Is this right way? but am not getting result 

ControlSend($hWnd, "", "TEIEdit5",  "{F6}")

 

[water]

If it works it is the right way. If not it isn't.
I assume it doeswn't work.
I suggest you check the help file on how to specify the class of a control.

[sumandevadiga]

On 3/15/2017 at 11:41 AM, water said:

then run _OL_ItemPrint to print the mail.

Hello Water,

This picking up default printer , if want to select printer from drop down list, how to code it?

[water]

Isn't it always the same printer?
Would the user need to select a printer from the above dropdown and should this information then be passed to your AutoIt script?
 

[sumandevadiga]

Hello Water,

Script which am working for that printer will be always same "pdf2edoc".

No,when we  run the script, this should select "pdf2edoc" by itself.

 

[water]

Then why do you want to use a dropdown when the printer name is fixed?