I want to send the extracted xlsx file through smtp mail message.During attachment if the xlsx file, I’m unable to find its location/path in my system. Can you help to further?
Can you specify from where you are extracting this xlsx file? Are you downloading the same from a portal or are you getting the file as a part of attachment from any received mail?
Best Regards.
Ahh… Can we connect via meet?
Actually, i extracted the data through data scraping method.
I think you have extracted data from the webpage and stored in a datatable. write the datatable in the excel(xlsx) file in the “Write range workbook” activity. In that activity you given the file path. Use that file path to search in your system to find the excel(xlsx) file.
While attaching to the send smtp mail message click on attach files, create an argument and pass the same file path there. Then it will take the excel(xlsx) attachment from your system where it be stored.
I hope it will help for you!!
Hi @Suthari_RohithReddy post the data scraping is done, hope you have used the any of excel activities to write the data into an excel file.
The path provided there would be the same path where your excel file would be residing
By default when you try to use write range, the folder location it would point would be the project folder.
Please check if your file is located there
Can we connect via google meet for 5-10min ?
Yuhh Sure @Suthari_RohithReddy
send me a invite to join in meet.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.