Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

Extract Email addresses to Excel - Word

Started by ptrex , Oct 20 2006 08:30 PM

Please log in to reply

6 replies to this topic

#1 ptrex

Universalist

MVPs
2,399 posts

Posted 20 October 2006 - 08:30 PM

Extract Email addresses to Excel - Word

Excel_UDF + Word_UDF = Outlook_UDF

For those who want to start an Outlook UDF, this is a start.

Outlook_Test.au3 9.62K 2818 downloads Script Updated 12/01/2007 for NEW EXCEL UDF

Credits to the Excel and Word UDF

PS : Open Outlook first before running this example

Enjoy

ptrex

Edited by ptrex, 14 September 2012 - 09:47 AM.

Contributions :Firewall Log Analyzer for XP - Creating COM objects without a need of DLL's - UPnP support in AU3 Crystal Reports Viewer - PDFCreator in AutoIT - Duplicate File Finder SQLite3 Database functionality - USB Monitoring - Reading Excel using SQL Run Au3 as a Windows Service - File Monitor - Embedded Flash Player Dynamic Functions - Control Panel Applets - Digital Signing Code - Excel Grid In AutoIT - Constants for Special Folders in Windows Read data from Any Windows Edit Control - SOAP and Web Services in AutoIT - Barcode Printing Using PS - AU3 on LightTD Webserver MS LogParser SQL Engine in AutoIT - ImageMagick Image Processing - Converter @ Dec - Hex - Bin -Email Address Encoder - MSI Editor - SNMP - MIB Protocol Financial Functions UDF - Set ACL Permissions - Syntax HighLighter for AU3 ADOR.RecordSet approach - Real OCR - HTTP Disk - PDF Reader Personal Worldclock - MS Indexing Engine - Printing Controls GuiListView - Navigation (break the 4000 Limit barrier) - Registration Free COM DLL Distribution - WinRM SMART Analysis - COM Object Browser - Excel PivotTable Object - VLC Media Player - Windows LogOnOff Gui -Extract Data from Outlook to Word & Excel - Analyze Event ID 4226 - DotNet Compiler Wrapper - Powershell_COM New

Back to top

#2 Zedna

AutoIt rulez!

MVPs
8,315 posts

Posted 02 December 2006 - 04:03 PM

very nice example

Resources UDF AutoIt Forum Search

Back to top

#3 ptrex

Universalist

MVPs
2,399 posts

Posted 06 December 2006 - 08:19 AM

@Zedna

Thanks !!

I know that the changes made to the latest Excel UDF made this example not work anymore for exporting to Excel.

If anyone is interested I can remake it again to get it working.

Regards

ptrex

Contributions :Firewall Log Analyzer for XP - Creating COM objects without a need of DLL's - UPnP support in AU3 Crystal Reports Viewer - PDFCreator in AutoIT - Duplicate File Finder SQLite3 Database functionality - USB Monitoring - Reading Excel using SQL Run Au3 as a Windows Service - File Monitor - Embedded Flash Player Dynamic Functions - Control Panel Applets - Digital Signing Code - Excel Grid In AutoIT - Constants for Special Folders in Windows Read data from Any Windows Edit Control - SOAP and Web Services in AutoIT - Barcode Printing Using PS - AU3 on LightTD Webserver MS LogParser SQL Engine in AutoIT - ImageMagick Image Processing - Converter @ Dec - Hex - Bin -Email Address Encoder - MSI Editor - SNMP - MIB Protocol Financial Functions UDF - Set ACL Permissions - Syntax HighLighter for AU3 ADOR.RecordSet approach - Real OCR - HTTP Disk - PDF Reader Personal Worldclock - MS Indexing Engine - Printing Controls GuiListView - Navigation (break the 4000 Limit barrier) - Registration Free COM DLL Distribution - WinRM SMART Analysis - COM Object Browser - Excel PivotTable Object - VLC Media Player - Windows LogOnOff Gui -Extract Data from Outlook to Word & Excel - Analyze Event ID 4226 - DotNet Compiler Wrapper - Powershell_COM New

Back to top

#4 ScriptUSER

Wayfarer

Active Members
62 posts

Posted 12 January 2007 - 10:13 AM

Excel_UDF + Word_UDF = Outlook_UDF

For those who want to start an Outlook UDF, this is a start.

Credits to the Excel and Word UDF

PS : Open Outlook first before running this example

Enjoy

ptrex

This script extracts just 4 items from outlook to a word document
dont work for Excel .
is there uppdated vrsion of this script ?

Back to top

#5 ptrex

Universalist

MVPs
2,399 posts

Posted 12 January 2007 - 02:46 PM

@ScriptUSER

Script updated in the first post.

Regards

ptrex

Contributions :Firewall Log Analyzer for XP - Creating COM objects without a need of DLL's - UPnP support in AU3 Crystal Reports Viewer - PDFCreator in AutoIT - Duplicate File Finder SQLite3 Database functionality - USB Monitoring - Reading Excel using SQL Run Au3 as a Windows Service - File Monitor - Embedded Flash Player Dynamic Functions - Control Panel Applets - Digital Signing Code - Excel Grid In AutoIT - Constants for Special Folders in Windows Read data from Any Windows Edit Control - SOAP and Web Services in AutoIT - Barcode Printing Using PS - AU3 on LightTD Webserver MS LogParser SQL Engine in AutoIT - ImageMagick Image Processing - Converter @ Dec - Hex - Bin -Email Address Encoder - MSI Editor - SNMP - MIB Protocol Financial Functions UDF - Set ACL Permissions - Syntax HighLighter for AU3 ADOR.RecordSet approach - Real OCR - HTTP Disk - PDF Reader Personal Worldclock - MS Indexing Engine - Printing Controls GuiListView - Navigation (break the 4000 Limit barrier) - Registration Free COM DLL Distribution - WinRM SMART Analysis - COM Object Browser - Excel PivotTable Object - VLC Media Player - Windows LogOnOff Gui -Extract Data from Outlook to Word & Excel - Analyze Event ID 4226 - DotNet Compiler Wrapper - Powershell_COM New

Back to top

#6 Juvigy

Experimental Drugs Abuser

Active Members
1,243 posts

Posted 24 November 2008 - 10:27 AM

Why do i get all the COM errors?Maybe i need to do:
; C:\_\Apps\AutoIT3\COM\COM Library Properties.au3 to Generate the Constants !!
But where can i find it?

Back to top

#7 MadBoy

Universalist

Active Members
829 posts

Posted 24 November 2008 - 06:57 PM

@ScriptUSER

Script updated in the first post.

Regards

ptrex

Ptrex you got any idea how to extract all addresses not from address book but from all emails in inbox/outbox in Outlook ? One of the employees want to send email with information about some change in company and she would like to get all emails from the list?

With regards,

MadBoy