Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 03-18-2019, 02:33 PM
Power_Peter Power_Peter is offline Windows 7 64bit Office 2010
Novice
 
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,
Piet
Attached Files
File Type: xlsm Dummy_Project_Hit_Ratio_v01.xlsm (25.9 KB, 2 views)
Reply With Quote
  #2  
Old 03-22-2019, 09:50 AM
Kenneth Hobson Kenneth Hobson is offline Windows 10 Office 2016
Novice
 
Join Date: Jun 2018
Posts: 27
Kenneth Hobson is on a distinguished road
Default

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
Reply

Tags
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 jburke@holidayinnislip.co 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.
MSOfficeForums.com is not affiliated with Microsoft