outlook to excel body of information

hi guys,

not sure if this is possible,

I want to know is it possible to export certain emails that have the subject Appointment to a excel spreadsheet.

I keep track of members appointments through a excel spreadsheet.

They provide the following information to me in a email,

Name - Henry

Date - 20 Dec 2017

Time - 15:00

Type - Upper Body

Location - Hospital


I have attached a spreadsheet I use to keep track.

I have over 40 people emailing me so the appointments keep adding on one after the other.

I use a macro in excel to delete the appointments when they have been competed.

Yes. When you say export, do you mean export the email as MSG or just read the body of the email and parse it to your sheet?

What folder do the files come into, inbox? Is it Exchange or Gmail?

I would recommend moving the emails to a folder once "exported". What is the name of that folder?

If you know how to run a macro in Outlook, I can show you an Outlook macro that will get an Outlook folder's path if not one of the defaults.

Hi,

read the body of the email then copy it to my spreadsheet, Once it has done that I dot need to email anymore so if there is a code to delete the email maybe?

I am using Exchange.

The emails just come into Inbox

I'll check back tomorrow and show you how if no one has done so by then.

While I could have deleted the email in one loop, I wanted to make sure that the data was imported without error before that. So, I changed the Subject line and deleted it later. Of course it is still in your Deleted Items folder.

Please Login or Register  to view this content.

Hi Kenneth

Is this code run in outlook or excel ?

Excel, VBE Module.

thanks Kenneth,

Is there a way to change the code as I am looking at merging two of my spreadsheets into one if this can be achieved I will be starting my appointments from A98, B98, C98, D98 and E98

Does anyone know why I would get this error
Run-time error ‘287’:
Application-defined or object-defined error

Then when I click debug

B = Split (.Body, vbCrLf) this comes up in yellow

Also in the code is it possible to designate the actually cell I want it to go to?

and last of all is it possible

when a appointment has past to be deleted and the new appointments fill up from the top?

hi Kenneth

sorry for the delay

Fill up from the top,

I was referring to when a appointment has past and been deleted I would like the next appointment that is sent to me to be filled in that position

this is what I have.

Please Login or Register  to view this content.

like you said in the previous messages Kenneth when someone else sends me a appointment it deletes other peoples appointments even if they have not been yet.

Appointments start from row 98 on my spreadsheet

Hi everyone

Anyone know why when I run the above code at my work it comes up with this message and does not work

Run time error 287

Click debug and it’s coming up with

B = Split(.Body, vbCrLf)

In outlook the email turns to Delted - Appoitment but does not delete as well

Hi Kenneth,

This was the spreadsheet I was referring to in one of my last messages starting from rom 99.

Hi would anyone know if this error is the result of my work computer using outlook 2010 running exchange

The code works fine on my computer at home using outlook 2016 no exchange

I have posted this question on excelguru as well

https://www.excelguru.ca/forums/show...dsheet&p=35844