Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-12-2015, 06:37 PM
BusinessBuilder BusinessBuilder is offline Import Data From Outlook To Excell? Windows 8 Import Data From Outlook To Excell? Office 2013
Novice
Import Data From Outlook To Excell?
 
Join Date: Aug 2015
Posts: 8
BusinessBuilder is on a distinguished road
Default Import Data From Outlook To Excell?

Hi everyone,

I have a question. Is it possible to export data from an email into an excellsheet? I'm developing my
own transportation business and I would like to know if I can extract data from emailcontent and insert it into specific colums in excell sheet. The requests come through my website and I have created a system which counts the reuests and adds a number to the additional headers like Quote Request Ticketnr: 201500001. This number automatically increases by one every time.

The requests I get from my site will look something like this:

Company Details
Company: Test
Contactperson: bla bla
Phonenumber: 06-55555555
Email: test@gmail.com
Country: netherlands

Pickup Details
Zipcode / City: 2255dd / amsterdam
Country: netherlands

Destination Details
Zipcode / City: 5542de / rotterdam
Country: Afghanistan



Shipment Details
Cargo Quantity: 40
Weight (Weight in kilograms): 250kg
Dimensions (LxBxH in cm's): 250x15x14
Commodity: dsfvfvdsfv

Service Details
Shipping Service Conventional Shipping
Container Quantity 1
Container Type: Dry Cargo Container
Delivery Options: Door to door
Freight Insurance: Yes
Freight value: 25.000
Export Packing: Yes
Customs Formalities: Yes

All the parts I have bolded out is information I would to import into certain colums in
excell and now is my question is this possible and if so how do I do it? And I also would like to have the quote ticketnumber from the additional header inside a colum. Is this possible and if so how can I do this?

Can someone help me?

Regards,
BusinessBuilder
Reply With Quote
  #2  
Old 08-13-2015, 03:45 AM
BusinessBuilder BusinessBuilder is offline Import Data From Outlook To Excell? Windows 8 Import Data From Outlook To Excell? Office 2013
Novice
Import Data From Outlook To Excell?
 
Join Date: Aug 2015
Posts: 8
BusinessBuilder is on a distinguished road
Default

Is this actually even doable?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Import Data From Outlook To Excell? How to import excel calender data into outlook - with a click of a button levrone Excel 24 10-01-2021 05:33 AM
Import Excel spreadsheet calendar data into Outlook 2010 davesp Outlook 0 09-30-2013 09:26 AM
Import Data From Outlook To Excell? Data query import Gandalf Excel 9 02-12-2013 03:03 AM
Import Data From Outlook To Excell? Outlook data import Cunner Outlook 2 08-20-2010 02:03 AM
Import Data From Outlook To Excell? Importing Excell date into Outlook trouble geno368 Excel 1 05-15-2010 06:29 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:35 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