Learn How To Automatically Send Outlook Emails & Attachments To Excel [Part 1]

In this week’s training, I will show you how to send emails received in Outlook.

⬇𝗗𝗢𝗪𝗡𝗟𝗢𝗔𝗗 𝗧𝗛𝗜𝗦 𝗪𝗘𝗘𝗞'𝗦 𝗪𝗢𝗥𝗞𝗕𝗢𝗢𝗞 𝗧𝗘𝗠𝗣𝗟𝗔𝗧𝗘 𝗛𝗘𝗥𝗘

TIMESTAMPS:
0:00 - Introduction
0:40 - Overview
10:10 - Startup Application
12:20 - Add Item

EXCEL COURSES:

EXCEL PRODUCTS:


#exceltraining #emailmanager #sendoutlookemails #emailmanagement

[DedManWarKing]

Hi Randy, thank you for a great tutorial. I can really see this Outlook/Excel integration really benefitting my work. Look forward to part 2.

[mandeepsinghmatharu]

Thank you so much. You just made my life so much easier. Amazing tutorial!

[zaydarendse]

You are amazing!! i so need to get accustomed to VBA

[wayneedmondson]

Hi Randy.. looks like another great video. Looking forward to getting into it. Thanks and thumbs up!

[michaelyoung]

Hi Randy, Love the functionality of your videos. I have 3 different applications based on your philosophies. Question on this email import. Is there a way to prevent the workbook from opening and closing multiple times when processing a lot of emails? I find it really intrusive when first opening Outlook to have the file open and close 10-100 times. Or, any way to have it work in the background?

[maltehartmann]

Great tutorial! Initially I had some trouble getting my code to get triggered after receiving a mail. However, after adding the Excel Object Library, thing work just fine!

[bigxsedo]

This is really nice. How would I go about setting it up for a shared inbox?

[markdayphotography]

Will you go on to explain how to handle (remove) ephemeral email containing attachments that do not require long term archiving?

[richardwing]

Thank you Randy for the great tutorials. I started watching this first video and I am curious if there is a way to pull images that are imbedded in the body of a email like you pull attachments and If so is it covered in this 3 part series anywhere? Is there a bit of code that can do both? Pull and store attachments and imbedded images in the same attachments area of the software? Thanks in advance for your time.

[DPK]

Hi,
I will follow all ur trainings and video in YouTube all the time those are very helpful for me.

I need some help like
Is there any way that I can get all the details of certain number or word from internet to excel automatically.

Example if I need weather information of a certain country like USA in excel A2 cell I will USA and I want weather information should reflect in B2 Cell automatically from the internet from certain website . If I change the country from USA to some other the data in B2 cell should also change. If it is possible please help me on it

[petardzopalic]

Dear Randy plase help me with advice,
how to use your code to refer also to both Inbox Items and Sent Items ?

[binhvu]

Many thanks for the amazing tutorial. I try following your tut, but it have the problem for the mail having pic in signature, it will record the pic as attachment and unable to SaveAs. Can you support to fix it.

[TheNabob]

Randy, nice coding. Your explanation and instructions are clear and well spoken. However, I am grasping for usefullness of pulling emails into Excel. Other than demonstrating the coding, why would someone want to pull emails into Excel? I have a work email and get lots everyday. I have had to learn Outlook to filter out emails from my boss to a separate folder with an alert set to go off when one arrives so that I don't miss anything important, unwanted 'solicitation' emails automatically to trash and so forth. Other than my interest in VBA and what it can do, is there a usefullness I am overlooking for this email manager?

[juhainaahmed]

Hi Randy.Thank you for the amazing video.How can I access the excel workbookm if its on a shared drive? The code didnt seem to work when i tried to access it from a shared drive, but its working when accessed from a local drive. I need it for my work, as Ill be using our shared office email and drive for the same.

[jacobrudy]

Great tutorial - I was actually trying to figure out how to copy a list (>600) of email addresses in an Excel table (cell a1 thru cell a600) into an email contact list (Yahoo or Gmail). I don't think it is possible. Thanks for the great lesson.

[downras]

Hello Randy, is there a way to just pull attachments from an outlook folder instead of inbox?

[pabeader]

Will you do one that is the other direction? E-Mail from Excel?

[petardzopalic]

Hi Randy, I have more then one mailbox in my outlook, what I need to modify to do this code for specific mailbox in my outlook? Thank you in advance.

[carolyap]

Hi Randy, its such a great tutorial. I've searching everywhere for this. However, the email were not connected to my excel file which mean no email pull into the excel file given .. really need your help as i've done the code checking however, still not working. Thanks in advance

[varunmatta]

Hello Randy, your video was a great help. Joined your FB group as well. you are doing a great job.
I have a question regarding this video. i have two email Ids linked to my outlook account. one is default and other is company's
this code only extract email from default inbox via Inbox= getdefaultfolder. I want to extract email from my alternate email which shows as a pst in outlook.
Any help will be highly appreciated.