Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import data from Outlook 2003 to Excel 2003
Hi I'm a newbie to groups but would like to get some code to import
data from the InBox of Outlook into an Excel spreadsheet. I'm imagining I would have a button in Excel to click to import certain fields from Outlook. In particular, I would like Excel to go to the current item in the Inbox (i.e. the selected item) and import details from that email such as "Subject", "From", "Recd Dt" etc. I would then go to the next email, which may not be the one underneath the current one, i.e. I select a mail item from somewhere else in the InBox, click the button, Excel retrieves the data from Outlook and puts it into the ActiveSheet wherever. I then pick another email and import it and so it goes. Any help with coding this would be welcome. Thanks in advance. Dave. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import data from Outlook 2003 to Excel 2003
Hi Dave
See http://www.dicks-clicks.com/excel/ol...rieving_E-Mail For attachments I have also a page http://www.rondebruin.nl/mail/folder2/saveatt.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm wrote in message oups.com... Hi I'm a newbie to groups but would like to get some code to import data from the InBox of Outlook into an Excel spreadsheet. I'm imagining I would have a button in Excel to click to import certain fields from Outlook. In particular, I would like Excel to go to the current item in the Inbox (i.e. the selected item) and import details from that email such as "Subject", "From", "Recd Dt" etc. I would then go to the next email, which may not be the one underneath the current one, i.e. I select a mail item from somewhere else in the InBox, click the button, Excel retrieves the data from Outlook and puts it into the ActiveSheet wherever. I then pick another email and import it and so it goes. Any help with coding this would be welcome. Thanks in advance. Dave. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import data from Outlook 2003 to Excel 2003
Thanks Ron, I'll check out the links you have included and try those out in
my code. -- Thanks David G Albury, Australia "Ron de Bruin" wrote: Hi Dave See http://www.dicks-clicks.com/excel/ol...rieving_E-Mail For attachments I have also a page http://www.rondebruin.nl/mail/folder2/saveatt.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm wrote in message oups.com... Hi I'm a newbie to groups but would like to get some code to import data from the InBox of Outlook into an Excel spreadsheet. I'm imagining I would have a button in Excel to click to import certain fields from Outlook. In particular, I would like Excel to go to the current item in the Inbox (i.e. the selected item) and import details from that email such as "Subject", "From", "Recd Dt" etc. I would then go to the next email, which may not be the one underneath the current one, i.e. I select a mail item from somewhere else in the InBox, click the button, Excel retrieves the data from Outlook and puts it into the ActiveSheet wherever. I then pick another email and import it and so it goes. Any help with coding this would be welcome. Thanks in advance. Dave. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 attachments open and show only empty cells when openedvia Outlook 2003? | Excel Discussion (Misc queries) | |||
Convert Excel 2003 spreadsheet into Outlook Contacts table 2003 | Excel Discussion (Misc queries) | |||
unable to paste Excel 2003 chart into Outlook 2003 | Charts and Charting in Excel | |||
import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? | Excel Discussion (Misc queries) | |||
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) |