In Import data to Access from Excel and My first Access macro, I posted some Access macros that push data into Access. Here is some code that does both.
export
Extract Calendar data from Outlook, Redux
In Extract Calendar Data from Outlook into Excel, I posted a method for writing Outlook appointments to an Excel worksheet.
Here is an updated function that uses a bit less code, with one disadvantage: it doesn't extract recurring appointments. Use the original code if you have recurring appointments. Or use both; the original to get all appointments, and this one to get only originals (not the recurrences).
Export Excel Range to a Picture File
(See my followup post Export Excel Range to a Picture File, Redux for updated VBA.)
If you ever needed to capture a range, for pasting into a document or email, you'll need to save it as an image first. If so, you might find this routine useful. It takes a contiguous range, starting in A1, and creates a GIF file with a snapshot of the range.
Export Outlook Contacts to Excel
Here is the last of the add-in code I was working on. This piece extracts the properties from Contact Items into Excel, using early binding to speed up the code, but with GetObject/CreateObject calls to attempt to hook into an existing instance of Outlook. What, do you mean you don't leave Outlook running all day while you're in the office?
Exporting Comments using VBA
Reading comments is hard. Well, it is for me. You have to mouse around and wait for the comment to appear. But it's easy with a bit of programming. Here's how.
Continue Reading »