outlook export to excel in real time

Status
Not open for further replies.

chetz

Member
hello,

I want to export from outlook a mail to excel so that i cam use a macro in excel but the problem is that then i receive a second mail the excel is not uploaded.

I guess the problem is that the excel must be opened at all time. I tried to share the excel as workbook (autosave 1 min) but no result.

It is very important that the excel stays open all time and updated every time i get a new mail

Can u please help me ? :D
 

Forum Admin

Senior Member
Excel would need to be open for any macro or even odbc to pull Outlook data into Excel.

Does it have to be excel? If you could use Acess, the data can be shared easier.
 

chetz

Member
Hello,

OK. Can u please show me the how to import from Acess to excel (open excel)?

I have to export from outlook into acess but from here i think ill have the same problem with acess -> excel that i have with outlook -> excel. And yes it is a must that the end result to be in excel.

thx,
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
J Copy or Export Outlook Mail to Excel Outlook VBA and Custom Forms 6
W macro to export outlook emails to excel Outlook VBA and Custom Forms 6
N Export Outlook custom forms fields to excel Outlook VBA and Custom Forms 1
T Outlook 2007 Export tasks to Excel Using Outlook 2
M outlook shared calendar data export to excel sheet Using Outlook 1
Owl Export Outlook PDF Attachment as JPG? Outlook VBA and Custom Forms 4
O Export Outlook calendar appointments by filters and date range Outlook VBA and Custom Forms 1
J Export Zimbra to Outlook PST Using Outlook.com accounts in Outlook 1
C Export NSF Lotus Notes files in Outlook PST format? Using Outlook 1
C How to export Outlook data to csv? Using Outlook 0
T How to Export mailbox from Outlook 2019 to MBOX format? Using Outlook 1
R How To Repair OST File & Export OST File to Outlook PST ? Using Outlook 3
Diane Poremsky Export (Save) Outlook Contact photos Using Outlook 0
Q Outlook 2016\365 export specific rules to import in another system Exchange Server Administration 1
H How to export *all* fields from Outlook Using Outlook 2
M Outlook 2013/365 won't export 99% of my contacts to csv Using Outlook 2
Sarge USMC Cannot import/export Outlook 13 Using Outlook 6
L Outlook 2007 Codes Export and Import Using Outlook 9
L Outlook 2007 Toolbar Export and Import Using Outlook 7
F Export Outlook contacts by One Category Using Outlook 1
O Export (save) Outlook Contact photos Using Outlook 2
D Export Outlook Calendar Using Outlook 1
C Outlook 200? - Script Export Rules Using Outlook 1
K outlook 2007 Export/Import Distribution lists Using Outlook 1
P Cannot export contacts with Outlook 2003 Using Outlook 10
M Why msg files are differ after export from Outlook to filesystem? Outlook VBA and Custom Forms 4
R Export email from Outlook into Access... Outlook VBA and Custom Forms 3
Retired Geek Outlook for the MAC with Yahoo accounts now very broken Using Outlook 2
S Outlook 2002- "Send" button has disappeared. Help please. Using Outlook 1
L How Stop Outlook Nag Messages Using Outlook 1
TomHuckstep Remove Send/Receive All Folders (IMAP/POP) button from Outlook 365 Ribbon Using Outlook 1
L I Cannot Sign Into My Outlook Account? Outlook VBA and Custom Forms 0
icacream Outlook 2021 - Google calendar in the peek Using Outlook 0
e_a_g_l_e_p_i Question about installing my Gmail account on my iPhone but still getting messages downloaded to my desktop Outlook. Using Outlook 3
F Want to add second email to Outlook for business use Using Outlook 3
kburrows Outlook Email Body Text Disappears/Overlaps, Folders Switch Around when You Hover, Excel Opens Randomly and Runs in the Background - Profile Corrupt? Using Outlook 0
M using excel to sort outlook appointment items Outlook VBA and Custom Forms 4
e_a_g_l_e_p_i MY Outlook 2021 changed the format of the shortcuts for mail, calendar etc. Using Outlook 10
Z Outlook 2021 Outlook new emails notification not working Using Outlook 5
K Changing the Deleted Items location in Outlook 2019 Using Outlook 2
J Outlook 365 Outlook Macro to Sort emails by column "Received" to view the latest email received Outlook VBA and Custom Forms 0
V How to use Comas in a picklist in Outlook forms Outlook VBA and Custom Forms 3
e_a_g_l_e_p_i Question about reinstalling Outlook 2021 Using Outlook 5
A Outlook 365 Outlook (part of 365) now working offline - argh Using Outlook 5
M Outlook Macro to save as Email with a file name format : Date_Timestamp_Sender initial_Email subject Outlook VBA and Custom Forms 0
G LinkedIn tab missing in Outlook 365 (but working in OWA) Using Outlook 0
Jay Freedman Outlook forgets "not junk" marking Using Outlook 0
KurtLass Opening Graphics Attachments in Outlook 2021 Using Outlook 0
P now on office 365 but getting error messages about missing Outlook 2013 cache folders Using Outlook 2
B Outlook config download Outlook VBA and Custom Forms 1

Similar threads

Top