Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

LinkBack Thread Tools Display Modes
Old 03-18-2019, 02:33 PM
Power_Peter Power_Peter is offline Windows 7 64bit Office 2010
Join Date: Mar 2019
Posts: 1
Power_Peter is on a distinguished road
Default Import Mail Content into Excel - With Attachment Button!

Hi all,

Hope you are doing great today!

I have a challenge, I haven't found the solution for. Hope you can help!

Basically, I just would like to import mails from a specific outlook-folder into an excel file:

- Import should include Time, Sender and the text, obviously.

- Furthermore, I would like to attach the whole mail to an icon (see attached file).
I will need that for a following step, where I extract certain data from the text. In case the information cant be found automatically, I would like to look it up, by simply clicking on the button.

- At last, a clearing code would be pretty helpful, which is added in the beginning, in order to delete old "import data".

I attached a dummy sheet, with the start of my code. I will be honest, I have no idea why it is not working.

Hope that anyone can help on this challenge )

Let me know if you have any questions!

Thanks a lot in advance,
Attached Files
File Type: xlsm Dummy_Project_Hit_Ratio_v01.xlsm (25.9 KB, 2 views)
Reply With Quote
Old 03-22-2019, 09:50 AM
Kenneth Hobson Kenneth Hobson is offline Windows 10 Office 2016
Join Date: Jun 2018
Posts: 27
Kenneth Hobson is on a distinguished road

I don't see the purpose of the shape/icon.

It looks like you would want an Import and Clear macros. Those can be called in command button controls or shapes.

The main issue with your code is that you did not define range names. I guess those would be the column heading cells.

You also need to add the Outlook object in VBEs Tools > References.
Reply With Quote

attached files, import outlook

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail merge: single label set-up/template set-up/Excel import/what am I doing wrong? brunofirst Mail Merge 7 02-27-2014 02:30 PM
How to import excel calender data into outlook - with a click of a button levrone Excel 22 10-05-2013 02:43 PM
email as pdf attachment - subject line and attachment named after mail merge Nexus Mail Merge 12 04-13-2011 11:34 PM
Word attachment on an E-mail-macro to open attachment & nablady Outlook 0 11-28-2006 03:00 PM
mail receipent with an excel worksheet attachment Office 1 11-14-2005 08:55 AM

All times are GMT -7. The time now is 10:09 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft