Microsoft Office Forums Import Mail Content into Excel - With Attachment Button!

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-18-2019, 02:33 PM
Power_Peter Power_Peter is offline Import Mail Content into Excel - With Attachment Button! Windows 7 64bit Import Mail Content into Excel - With Attachment Button! Office 2010
Novice
Import Mail Content into Excel - With Attachment Button!
 
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 online now Import Mail Content into Excel - With Attachment Button! Windows 10 Import Mail Content into Excel - With Attachment Button! Office 2016
Advanced Beginner
 
Join Date: Jun 2018
Posts: 36
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
Import Mail Content into Excel - With Attachment Button! 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
Import Mail Content into Excel - With Attachment Button! How to import excel calender data into outlook - with a click of a button levrone Excel 22 10-05-2013 02:43 PM
Import Mail Content into Excel - With Attachment Button! 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
Import Mail Content into Excel - With Attachment Button! 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 01:19 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft