Thanks bro, u are right, online sources about pulling data into excel is not much
@SigmaCoding3 жыл бұрын
Welcome 👍
@City-yr4ub4 жыл бұрын
Thanks so much. it is really help me a lot. My questions please: How can select certain email in certain folder (ex.: its subject starts with certain word) to open it & send a table to excel. Thank you & have a nice weekend!
@jasondennis4458 Жыл бұрын
Hi - this isn't working for me as it fails at the line Set oLookMailitem = Application.ActiveExplorer.CurrentFolder.Items("Forecast OKS Billing Report") because ActiveExplorer is not an option to choose following Application - any advice would be appreciated :-)
@kamillasabitova65702 жыл бұрын
Thank you so much! I am trying to figure out how to extract the table from the email received today, as there is an email received daily with the same subject.
@hitheshknair23782 жыл бұрын
Great video. I want to prepare trackers and i am getting many tables from different people in different tables. So how I can put those details automatically in one table and every time it automatically refreshed. 2 more tabs required like sender name, sender date and time.
@reng77774 жыл бұрын
My Friend this is not just interesting.. BUT GENIUS!!!! You have created a MINI BOT!!!! What about if in the same email i received 3 excel files with some range information that i need to import to an excel template?
@SigmaCoding4 жыл бұрын
You'll have to be a little more specific about the Excel files. Are you talking about an attachment, an embedded OLE Object, or something else? If it's an embedded object, it should be possible, but I'd have to do look at the specific object it is when it is sent to a user.
@userx4603 жыл бұрын
Thanks, I have one question how can I copy only one column of data from table in mail and past into excel
@usmanattari37902 жыл бұрын
Hi, i am getting error as " Run-time error '438': Object doesn't support this property or method
@krupamehta79962 жыл бұрын
Getting the same error. Sir kindly help
@pradip4244 жыл бұрын
Curious. Why are you not using namespace MAPI in this video?
@jeanpierre43702 жыл бұрын
Can you do one with Excel opened?
@ashitoshshinde26424 жыл бұрын
Couldn’t find your video looping through multiple tables. Can you please help with VBA code in case we have multiple tables inside a mail?
@SigmaCoding4 жыл бұрын
Here is the link: kzfaq.info/get/bejne/rb-peJt5nrKrnIU.html