Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 12-15-2011, 06:44 AM
Woolstar Woolstar is offline outlook - excel Windows 7 32bit outlook - excel Office 2007
Novice
outlook - excel
 
Join Date: Dec 2011
Posts: 7
Woolstar is on a distinguished road
Default outlook - excel

I have no idea if this is possible but if someone can help me it would be brilliant!

Can you export the information from multiple excel attachments from multiple emails in outlook (all with the same field headings) into one document (with the same headings)?

I receive loads of emails everyday and it would be amazing if I could just run a script that extracts the data and dumps it into the designated document.

Please help!!

Thanks
Reply With Quote
  #2  
Old 12-15-2011, 07:06 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline outlook - excel Windows XP outlook - excel Office 2003
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,920
Pecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond reputePecoflyer has a reputation beyond repute
Default

Hi
there seem to be a lot of solutions on the net.
Maybe this one works for you
__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
  #3  
Old 12-19-2011, 06:17 AM
Woolstar Woolstar is offline outlook - excel Windows 7 32bit outlook - excel Office 2007
Novice
outlook - excel
 
Join Date: Dec 2011
Posts: 7
Woolstar is on a distinguished road
Default

Hi,

Thanks for your suggestion,

Had a look at your link. It allows the user to save the attachments automatically however what I need is to be able to extract the data from within the excel document (attachment) into another excel document with the exact same field headings.

If you have any more suggestions they will be greatly appreciated
Reply With Quote
  #4  
Old 12-20-2011, 07:56 AM
Catalin.B Catalin.B is offline outlook - excel Windows Vista outlook - excel Office 2010 32bit
Expert
 
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default

You can try this add-in
http://www.rondebruin.nl/merge.htm
Reply With Quote
  #5  
Old 12-23-2011, 02:34 AM
Woolstar Woolstar is offline outlook - excel Windows 7 32bit outlook - excel Office 2007
Novice
outlook - excel
 
Join Date: Dec 2011
Posts: 7
Woolstar is on a distinguished road
Default

Thanks, that works perfectly!

You are a life saver
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Outlook Shared Calendar from Excel ReviTULize Outlook 0 12-07-2011 08:12 AM
Outlook Form to Excel Yagyesh Excel 0 07-05-2011 11:30 AM
Cannot open Excel attachments in Outlook Shawn76 Outlook 1 07-23-2010 05:42 AM
Outlook/Excel interface Michael333 Outlook 0 09-19-2006 01:31 PM
Excel document won't open from Outlook shinobi89 Office 0 06-01-2006 02:10 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:48 AM.


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