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
 
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.
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
A New Outlook - Cannot drag IMAP emails to Task List in MyDay Using Outlook 0
L Android Outlook Doesn't Update PC Notification Changes Using Outlook 0
A How to open Excel file saved in Outlook folder? Outlook VBA and Custom Forms 4
D.Moore Outlook desktop client suggested searches question Using Outlook 16
Y Outlook 2016 (64-bit) Copy Local Cal. Events to Another Cal. with Modified Reminder time Using Outlook 2
T Outlook 2019 While connecting an IMAP account in "classic" Outlook 2024 I caused a massive duplication of emails on the server (death loop) Using Outlook 5
D Cannot logon to Outlook.com, or outlook on Mac, outlook not updating on ipad, iphone Using Outlook 1
J unable to get my new install of Outlook to display mailboxes in the single-line format. Using Outlook 1
D Legacy Microsoft Outlook for Mac Support will end in Oct 2025 Using Outlook 5
C Nasty Bug Lurking In Outlook For Years. The Trigger. Any Fix Or Workaround? Using Outlook 11
R Auto clicking Hyperlink in outlook Outlook VBA and Custom Forms 7
ughlook Open multiple contacts in NEW Outlook? Using Outlook 3
G Outlook translation feature is off Using Outlook 2
J Outlook 2010 does not let me put any account Using Outlook.com accounts in Outlook 3
P 3 of 5 PST files don't install from d:\outlook but only from D:\ Using Outlook 7
HarvMan January Windows 10 preview update force installs new Outlook Using Outlook 1
L Outlook 2010 - new installation on Windows 11 - aplzod32.dll is not a valid Add-in Using Outlook 12
J Outlook troubleshooting/logging - option grayed out Using Outlook 2
B Arrows missing from Outlook emails vertical scrollbar Using Outlook 0
G Outlook 2021 (New) doesn't respect default browser Using Outlook 9
B Outlook or iPhone turning tabs into spaces in Outlook Notes Using Outlook 1

Similar threads

Back
Top