Search results

Hi Experts, Can anyone help me in above please. Have a nice week ahead. :)

Hi, Am using below code. Only issue is with the default outlook e-mail signature. Macro not able to populate default e-mail signature. Can anyone please help me in this. Sub OpenEmailWithRange() Call DefineWorksheets Dim OlApp As Object Dim olNS As Object Dim olMail As Object...

Hi, Most of the issues resolved now, only e-mail signature issue is still there. Thanks.

Hi, Am facing two issues with this code. E-mail signature is getting created at the very bottom of the previous e-mail. For example, am the user and if e-mail sent by ABC and macro is editing that e-mail, so my e-mail sign is getting created at the bottom of ABC's e-mail. In short, it is not...

First, my apologies for late reply, I was away due to some emergency hence could not reply on time. This code line is working great, thanks a lot for the help. Was not able to resolve it on my own for 3-4 days. Have a nice day ahead. :)

Hi, Can anyone please help me in this.

Hi, Can anyone please help me in this. I am using below code lines to edit .SentOnBehalfOfName still previous sender's name is reflecting on e-mail. I am required to manually select the user (i.e. my name). Not able to understand how do I resolve this. ' Display the email Dim OL As...

Hi, The only only issue am facing is, email is trying to be sent as on-behalf, am trying to resolve that issue. on-behalf name is appearing as the person who sent existing e-mail. Used below lines but still not helping. olMail.SentOnBehalfOfName = "" olMail.Display

Hi @Debaser sorry for late reply. Below code is editing existing e-mail. Please see if you get time. Ideas is to, open an existing ongoing issue for the item and reply to that item, that is why need to edit existing email only and not create new one. Now with this code, we are able to copy the...

Hi @Debaser thanks a lot for the help. Please give me some time to give a detailed reply.

Hi, I tried using below code. It is editing existing e-mail, however facing some issues with HTML body and formatting. </p><p> is getting added to e-mail body. Also, this code is pasting excel range as picture, I need to get the excel range as it is, it should be editable. Sub...

Hi @Debaser , thanks for the help. I am able to resolve this. I do not want to create new e-mail. I want to edit the existing e-mail. Could you please help me if you get time. Have a nice day ahead. :)

Tried another version, it is opening existing e-mail, however facing bug at olInsp.WordEditor.Range.Paste It is saying, word has encountered a problem. Sub OpenEmailWithPath() Call DefineWorksheets 'Define variables Dim olApp As Object Dim olNs As Object Dim olMail As...

I tried with below code. However it is creating a new e-mail. I want to edit the existing e-mail. Sub OpenEmail() Call DefineWorksheets Dim olApp As Object Dim olMail As Object Dim olInsp As Object Dim olDoc As Object Dim strPath As String Dim strTo As String...

Hi I need help for editing and existing e-mail saved on a drive. Please see below details for your reference. User have saved an e-mail at his drive. We have an Excel macro. Path of this email is saved in a cell in the macro. Macro needs to open the e-mail on the base of path mentioned in the...

Thanks for the help. I will check this. Have a nice day ahead. :)

Thanks for the help. Have a nice day ahead. :)

Hi Experts, I have an e-mail. This e-mail body has a screenshot pasted. This screenshot is copied from an Excel worksheet. There are around 3-4 columns and 3-4 rows copied from the excel worksheet and pasted as screenshot in an e-mail. Column and row number may vary. My task is, get the...

Hi @vletm thanks a lot for the help. Have a nice day ahead. :)

Hi @vletm could you please see attached file if you get time. Thanks.

Hi, Can anyone please help me in this.

I have tried below loop too. However loop is more time consuming. TempLr = Sht_Child.Range("A" & Rows.Count).End(xlUp).Row Set TempRng = Sht_Child.Range("N2:N" & TempLr) TempLr = Sht_Master.Range("A" & Rows.Count).End(xlUp).Row For Each TRng In TempRng FoundKey = "" '...

Hi, I have two excel files. First is parent file, second is child file. Both files have same structure. Same number of worksheets. Child file is replica of parent file. Only difference is parent file has all the records whereas child file has few records. In each worksheet there is one unique...

Welcome to the Forum @Malachi Kasel !

Sorry for being late, @bosco_yip sir I hope now you are better. :)