@yeevon3852 3 жыл бұрын
Thanks bro, u are right, online sources about pulling data into excel is not much
@SigmaCoding 3 жыл бұрын
Welcome 👍
@City-yr4ub 4 жыл бұрын
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 :-)
@kamillasabitova6570 2 жыл бұрын
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.
@hitheshknair2378 2 жыл бұрын
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.
@reng7777 4 жыл бұрын
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?
@SigmaCoding 4 жыл бұрын
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.
@userx460 3 жыл бұрын
Thanks, I have one question how can I copy only one column of data from table in mail and past into excel
@usmanattari3790 2 жыл бұрын
Hi, i am getting error as " Run-time error '438': Object doesn't support this property or method
@krupamehta7996 2 жыл бұрын
Getting the same error. Sir kindly help
@pradip424 4 жыл бұрын
Curious. Why are you not using namespace MAPI in this video?
@jeanpierre4370 2 жыл бұрын
Can you do one with Excel opened?
@ashitoshshinde2642 4 жыл бұрын
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?
@SigmaCoding 4 жыл бұрын
Here is the link: kzfaq.info/get/bejne/rb-peJt5nrKrnIU.html
@SahilTla 3 жыл бұрын
thanks
@SigmaCoding 3 жыл бұрын
You're welcome!
Learn Excel to excel
Рет қаралды 2,1 МЛН
Ajay Kumar
Рет қаралды 8 М.
VBA A2Z
Рет қаралды 29 М.
VBA A2Z
Рет қаралды 33 М.