outlook automation

Guys need some suggestions/idea on how to get all mails from inbox folder(including sub folders-folders) of shared-mailbox. Current code I have will get me only inbox folder mails. Is there a way to get all the mails from inbox, other folders, sub folders of shared mailbox. thanks in advance...

Hi all, Every month I have to send several recipients an email with information from an excel table in order to confirm price and volume. Customers may have to confirm more than one item and might also have already settle others. So, I wrote a code in order to automatize this. It basically...

Hi all, I've got a lot in one post really. I know what I want, but not the best way to go about it. I'm trying to eliminate the whole copy and paste procedure when creating reports. There are Red, Amber and Green scores for each section and an overall percentage score. When items get a "Red"...

Hi Everyone, Here is a quick review of what is going on. Everyday I get an email with a file attached, and I have outlook rules set up to have this email sent to a specific folder each day. In an excel file I have code that checks that folder each day for a) an unread email and b) if there is...

This is the first time I have worked with Outlook within VBA, so go easy if I have any glaring mistakes. I get a report emailed every day in my standard inbox at 06:01, and I'm attempting to locate it based on that time criteria. There are no runtime errors, but when I step through and get to...

I am trying to get a selected range from a worksheet (a number of tables) into the body of an email. No issues actually getting the contents of the worksheet into the email. My problem is that the contents of the email need to be fully visible (width-wise at least) when the email is being viewed...

Hi all, I'm working on a project where I need to somehow access the contents of a table embedded in an Outlook invite programmatically. If it were in an email, I'd be dealing with an object of the class "MailItem" and I could call HTMLBody and use the "table" tags to get the contents...

This little gem work perfect as a stand-alone script running from my PERSONAL Workbook. It is designed to look at a hidden "white out" value in B1 of EACH worksheet and email to the person whose address is in that cell. As soon as I tried to attach it to a button and run it from another...

Hi there I am struggling with a bit of coding that hopefully someone can help me with. Basically I am trying to create an email using a template but I would like to populate parts of the template with data that is contained within cells in Excel. Now I have the code and can create the email...

Dear All, I am looking for a macro or add-in that will save an Excel sheet as a PDF and attach the PDF to an Outlook email. My idea is to have one sheet in the Excel file with a table of sheet names, recipient email addresses, subject lines for the emails, and customized messages for the...

Hi All! For my business I need to automate the handling of the emails that hit our default inbox in Outlook. The 'handle emails' script will be run every few minutes and do one of several things depending on the email. I thought this thread could end up being a nice - Outlook automation from...

Hello, I've been working on a macro that will create a meeting maker from a roster in excel 2010. I have a workbook where each sheet is a roster for training that multiple people use, for this reason and for learning reasons I'm doing this in VBA. In my roster I have several columns for...