greggowaffles

greggowaffles

My mission is to create tutorials that are fun, easy to understand, and connected to real world scenarios.

Пікірлер

  • @sagarsamantaloknath9279
    @sagarsamantaloknath9279Күн бұрын

    Thanks

  • @mizanranawat5940
    @mizanranawat5940Күн бұрын

    File not found in the path where I have saved... please help

  • @two-onebee7030
    @two-onebee70306 күн бұрын

    This has proven very useful for a project I'm working on. Could you possibly explain how to add more than one table as separate images into the email body?

  • @thomasrusli1934
    @thomasrusli19346 күн бұрын

    Hello, how about filter based on specific value in the cell, for the example the value is "Amer", so the data will be show as Northern America, Latin Amer & Carib, etc

  • @praiserofthesun3645
    @praiserofthesun36456 күн бұрын

    5 years later and you saved my ass just because I actually forgot how to do this bs, thanks a lot man

  • @greggowaffles
    @greggowaffles6 күн бұрын

    Anytime! 😎

  • @kumaraprabaharan8669
    @kumaraprabaharan86697 күн бұрын

    Hi Brother, need ur help to get code for. Instead of selecting region one by one . can i give in range of cells with region i required. Need the each region in seperate sheet

  • @Drew-vp
    @Drew-vp7 күн бұрын

    Hi what if you have a cell with defined name. How can you reference that ?

  • @user-vg5lm5zl6g
    @user-vg5lm5zl6g8 күн бұрын

    How to autofilter and copy a table data to Outlook email by VBA Code

  • @minhtrungtran3675
    @minhtrungtran36759 күн бұрын

    Code debug at "set pic=ws.pictures.paste" with error Run time 1004. Can everyone help me?

  • @tramanand
    @tramanand12 күн бұрын

    Can't thank you enough....exactly what i was looking for...deep appreciation🙏🙏🙏

  • @tramanand
    @tramanand12 күн бұрын

    Terrificc...thanks a ton!!! 🙏🙏

  • @Pokemoncharlizard
    @Pokemoncharlizard13 күн бұрын

    What if there are 2 table pictures that we need to attached from 2 different tabs? Thank you for your help in advance.

  • @andyw.8402
    @andyw.840214 күн бұрын

    I have a folder with emails saved. Each email contains a zip folder that contains csv files. Can you do a video on how to go through all the emails, unzip the files and consolidate the csv files into one csv file using vba/macro?

  • @ma.cedezcatherinemalijan2200
    @ma.cedezcatherinemalijan220014 күн бұрын

    Hello! I need this same function but not using pivot. I need to copy and paste a certain range from excel to outlook. Please help

  • @karinbeyaert9950
    @karinbeyaert995015 күн бұрын

    It works. Great, thanks! But in my Excel it also works without the join and split steps. Only difference seems you are using a 1 or a 0 based array. It eventually gives the same filtering.

  • @ultrahen2755
    @ultrahen27556 күн бұрын

    can you share the code?

  • @karinbeyaert9950
    @karinbeyaert99506 күн бұрын

    @@ultrahen2755 Sure I can. But it is the same as shown here in the video. I only noticed that you can skip 2 of these transformations.

  • @ultrahen2755
    @ultrahen27556 күн бұрын

    @@karinbeyaert9950 my list no show or zero, i dont know why, already type the code from the video

  • @adampatterson3125
    @adampatterson312515 күн бұрын

    I keep running into issues with the Set pic = ws.Pictures.Paste line, gives me Run-time error '1004': Unable to get the Paste property of the Pictures Class. Any ideas? Thanks!

  • @MohamedAboAbdo03
    @MohamedAboAbdo0316 күн бұрын

    Thank you so much

  • @federicopelizza9563
    @federicopelizza956317 күн бұрын

    thank you, i've spent too much time commenting out lines to debug stuff.

  • @brittaniguidry6061
    @brittaniguidry606121 күн бұрын

    Ron's site is no longer available... can you paste the code somewhere so I can copy it?

  • @sakhilengwenya594
    @sakhilengwenya59423 күн бұрын

    Is there a reason why didn’t you do a For loop, this looks complicated

  • @kpcrompton
    @kpcrompton26 күн бұрын

    Thank you for the easy to follow tuition. Is it possible for the source data to start a cell other than "A1" and then the range start from there? Thanks again.

  • @sakhilengwenya594
    @sakhilengwenya59427 күн бұрын

    Thank you 🙏

  • @ArvinMartinez-of7tj
    @ArvinMartinez-of7tjАй бұрын

    How about if we put our list starting to B2, what would be code?

  • @ajaz4sky
    @ajaz4skyАй бұрын

    Great explanation, really understood everything pretty easily.. better than other tutorials on progressbar in vba

  • @greggowaffles
    @greggowaffles28 күн бұрын

    Appreciate the feedback!

  • @omkarjethe34
    @omkarjethe34Ай бұрын

    How can I put Thanks and regards after the attached image.. pls share me coding if possible...

  • @sharadpatel07
    @sharadpatel07Ай бұрын

    Hi Greg its help me a lot but i have to paste data in other sheet & create multiple forms from master sheet, how can i do it ?

  • @ankita6162
    @ankita6162Ай бұрын

    Really very useful

  • @ankita6162
    @ankita6162Ай бұрын

    How we can write some text on this image

  • @MuhammadFAH33M
    @MuhammadFAH33MАй бұрын

    Hi Nice Video 👍 Question ❓ I want the code to Auto pick file name from a Cell Value Can you please tell me how to do it. Also please update the VBA code & share it with people feedback given in comments Thanks 🙏 I've Subscribed to your Channel ❤

  • @abcdefg20939
    @abcdefg20939Ай бұрын

    Heii! :) Thanks for the great explanation - i was able to implement that! :) However, I do have an issue and i really really hope there is a quick and easy fix. I don't want an exact match of the criterias, I need a "contains" match. i tried to do Criteria1:=list & "*" but that didnt work. I tried an asterix at the beginning and end of my criteria in the original criteria list, but that also didn't work. I would be super grateful, if you could help me!

  • @petewarby7158
    @petewarby7158Ай бұрын

    I'm going to watch this again to grasp it, bl**dy brilliant though. The only other video I have seen glosses over everything you did at the start, your video is REALLY comprehensive (I think)... I'm going to give it a go later on. Thank you so much for creating this video, I think it's EXACTLY what I have been looking for!!!!!!! You're a star :)

  • @fatihakben6369
    @fatihakben6369Ай бұрын

    Hi Greg, This works almost perfectly! Except the ".HTML" and ."PasteandFormat wdChartPicture" both clobber everything else previously entered. Any Ideas? The

  • @russf62
    @russf62Ай бұрын

    Fantastic, so helpful, thanks. Had created code to clear a weekly timesheet at start of new week but wanted to add the option to save a copy before doing so. Just a few minor tweaks and voila... 😊

  • @greggowaffles
    @greggowafflesАй бұрын

    🙌🙌🙌

  • @vidya7596
    @vidya75962 ай бұрын

    Thank you Greg for this video, this is what I was looking for. I tried to replicate the same but getting an error Error "Run-time error 1004, Application-defined or object-defined error" in the line Set pop = Sheets("Form").Range(Cells(1, 1), Cells(count_row, count_col)) is it possible to share this file please :)

  • @MrJcole0502
    @MrJcole05022 ай бұрын

    This pastes the image when you display the picture without sending but when you change .display to .send, it sends it without the image. Has anyone figure this one out yet?

  • @lanceross1035
    @lanceross10352 ай бұрын

    Helpful video. I didn't realize at first why Field was 2, but figure it out. You present well.

  • @greggowaffles
    @greggowaffles2 ай бұрын

    Appreciate that!

  • @finvest_queen
    @finvest_queen2 ай бұрын

    amazing! thanks, like 👍👍👍

  • @shafiqr2000
    @shafiqr20002 ай бұрын

    Great video. Many thanks

  • @greggowaffles
    @greggowaffles2 ай бұрын

    Thank you!

  • @LG-pv8kr
    @LG-pv8kr2 ай бұрын

    Great video,but it doesn't paste the Pic...😅

  • @sundarsinghpthula
    @sundarsinghpthula2 ай бұрын

    How to attach only specific sheets in Excel

  • @Dexter101x
    @Dexter101x2 ай бұрын

    Can't VBA use anything other than Outlook? I find it very limiting, since I already have an email manager

  • @jorgettesantos711
    @jorgettesantos7112 ай бұрын

    Hi gregg, great video... is it possible to use the .SentOnBehalfOfMe function on Word mail merge?

  • @makubexho
    @makubexho2 ай бұрын

    great solution and coding in tackling the self-inflicted predicament by that poster - the intention of including such large amount of databody from Excel into the email body is beyond me - Do you not find it more appropriate and secure to store the data in an Excel file and attach it in the email for distribution? If I was the recipient of that email with a large table of content in the email body I would be like "WTH.."

  • @makubexho
    @makubexho2 ай бұрын

    use outlook and emails for its purposes that are originally designed best for - do not stretch its application to fit some "eye-catching" stunts some people are blindly searching for

  • @greggowaffles
    @greggowaffles2 ай бұрын

    Thanks for the feedback!! Gotta give the people what they want 😎

  • @maxwellelias5244
    @maxwellelias52442 ай бұрын

    Thank you very much, bro! This was exactly what I needed for finishing a project from work before going to the airport to finally be on vacation! :D

  • @greggowaffles
    @greggowaffles2 ай бұрын

    No prob! Happy to help!!

  • @greggowaffles
    @greggowaffles2 ай бұрын

    hello! check out this video if your'e running into issues when using large ranges: kzread.info/dash/bejne/pIWEyNmhpdW_YdY.html

  • @rhondarhocksExcel
    @rhondarhocksExcel2 ай бұрын

    Missed you GreggoWaffles. Fan of your videos. Could you do one similar to this but using Instr to find a partial string? I'm almost there and haven't been successful.

  • @shaikmohammed9971
    @shaikmohammed99712 ай бұрын

    Hey buddy, Thanks for the fantastic content. Just a quick question on font type/family. Though we selected Arial, draft is coming as Calibri. Can you please help?

  • @adarshVernekar-ez5tt
    @adarshVernekar-ez5tt2 ай бұрын

    You are great! Code works perfectly fine👍 thank you so much

  • @greggowaffles
    @greggowaffles2 ай бұрын

    Thank you!!

  • @suthamwintachai6559
    @suthamwintachai65592 ай бұрын

    thank you

  • @GGPG
    @GGPG2 ай бұрын

    hi sir, i came acrros your video, very help, but how do i change the size of the image pasted on the email please?? hope you can answer my question