Search results

Hi @Hui sir, thanks a lot for the help. It is working great ! Have a nice day ahead. :)

Hi, I am using below mentioned code to get filenames from a folder. However, I am facing a bug at ‘With Application.FileSearch’ line. The code is copied from ‘https://www.automateexcel.com/vba/list-all-files/’. Can anyone please help me in this...

Hi, I am facing one issue with this code. Code is not able to retrieve and export archive e-mail. Can anyone please help in this. How do I retrieve archive e-mail.

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

Hi @Chihiro sir, thanks a lot for the help. Am checking this and will revert with details. Have a nice day ahead. :)

Hi @vletm sir, thanks for the help. I checked my Outlook but could not see export to PDF option. Also, I need to apply few rules before exporting e-mails hence this needs to be done by macro only. Have a nice day ahead. :)

Hi, I am using below mentioned code to add “CustomDocumentProperties.Add Name”. My code is skipping “objWordApp.ActiveDocument.CustomDocumentProperties.Add Name:="YourName", LinkToContent:=False, Value:="thename", _ Type:=msoPropertyTypeString” line. As soon as code hits this line, macro...

Hi @vletm sir, thanks for the help. My requirement is still the same. Get e-mail to PDF. However I was not able to do it with coding. Hence, now I trying to convert e-mail to WORD and then WORD to PDF. Have a nice day ahead. :)

Hi @vletm sir, thanks for the help. I was not able to convert e-mail to PDF hence trying to convert e-mail to word, then converting word to PDF. Now I am converting e-mails to PDF in one module then trying to convert these saved word documents to PDF. I am aware this is not efficient but could...

Hi, This code seems to be working for me. Still lot of editing is required. But I guess this will work. Thanks for the help. Option Explicit 'https://stackoverflow.com/questions/51655911/export-outlook-email-as-pdf Sub Test_1() Application.ScreenUpdating = False...

1) Hi @vletm sir, no, it is not cross posted by me. Else I would have informed in original post. 2) Yes, have tested with original name, but facing same issue. 3) Fixed file name is for testing purpose. Original macro has real path and real file name but macro is not saving even single file...

Hi, I am trying to export word document to pdf with below code. The code runs without any error but file is not saved at the path. I tried halting this code after word file is generated and recorded file exporting task in word file. Copied same part and trying in excel but no success. Can...

Hi @vletm sir, thanks for the help. I am getting unique values for all the 8 times. Infact all the MHT files are saved with correct names. Have a nice day ahead. :)

Hi, I am using below mentioned code. This code is exporting only first e-mail from the loop. I am able to generate summary for all the e-mails from the folder. Even MHT files are getting saved correctly. For example, I have 8 e-mails in the folder. My list is getting updated for all the 8...

Hi @vletm sir, my apologies, have a nice day ahead. :)

Hi @p45cal sir, thanks a lot for the help. Have a nice day ahead. :)

Hi, Please see attached file for details. Thanks. Can anyone please help me in this.

Hi @vletm sir, If we change To:=0 to To:=1 or any other number than 0 Then I am getting below bug 'The remote server machine does not exist or is unavailable’ Please note, even if we do not do any change to line ‘To:=0’ First fille is getting saved in the folder without any problem. However I...

Hi @vletm sir, Thanks a lot for the help. Please give me some time to revert. Have a nice day ahead. :)