outlook export to excel in real time

Status
Not open for further replies.
C

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
 
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.
 
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,
 
Since Excel is the requirement, try using Outlook VBA to push email to Excel. It can kick in everytime new mail arrives.




Does it have to be instantaneous? Would running a macro every few minutes work?
 
Status
Not open for further replies.
< Setting appointments in the past | Too many ' tasks' when checking email >
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
macdotcom Outlook 365 Outlook folder export to PST archival tool - close, but need a nudge Outlook VBA and Custom Forms 2
T How to Export & Import GMAIL Contacts into Outlook 2021 ? Using Outlook 4
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
Hornblower409 Outlook 2010 - Never ending update Using Outlook 0
V Outlook created new profile? Using Outlook 1
J Outlook inbox question Using Outlook 3
T How to Add AT&T Contacts to Outlook 365 Using Outlook 7
F Outlook 2021 outlook on iPhone Using Outlook 1
F Outlook 2021 Outlook on iPhone asks for password Using Outlook 0
P ics calendar entries suddenly open up new Outlook Using Outlook 3
P Outlook "forgets" password until system rebooted Using Outlook 2
N Why does Outlook keeping adding to the email address I have in my notes portion of a contact? Using Outlook 2
M Anyone integrated AI website builders with Outlook for automated client communications? Using Outlook 1
V Gmail in Outlook Using Outlook 2
T Where has the Copilot icon gone in my Outlook desktop client? Using Outlook 5
P New way by Microsoft to get people to use the new Outlook Using Outlook 4
C How to keep emails in account in Outlook after closing the IMAP account Using Outlook 1
cymumtaz IMAP calendars in New Outlook Using Outlook 5
T Constantly Have To Log In To Outlook On The Web Using Outlook.com accounts in Outlook 2
T Cannot Find Outlook Noted On Android Using Outlook 4
O Outlook 2024 not showing that messages are replied to or forwarded Using Outlook 3
C Outlook 365 send/receive takes FOREVER - as in 40 minutes Using Outlook 7
I Outlook 2024 LTSC syncing with iCloud calendar - can only make appt. in iCloud Using Outlook 2
Kika Melo Outlook ribbon customisations do not 'stick' Using Outlook 12

Similar threads

Back
Top