vba & outlook

Hi guys, I have a simple question, but I didn't find any answer anywhere. How do I set Outlook 2013 to offline mode (via vba)?! In Outlook 2010 (or earlier) I used the commandbar.findcontrol(,5613) but in Outlook 2013 this commandbar simply does not exist anymore. I have made a code to...

Hi, I’m trying to create a VBA code to Save the current work book and then send to a specific e-mail address. I’ve managed to get it to attach the file to an e-mail but can’t seem to get the other bits to work at all. Below is what I am trying to achieve. if sheet 1 O5 or R5 or U5 = “Not...

Good evening, I am trying to write a VBA macro to be used within outlook. The macro picks the recipient from an email within an outlook folder (variable "recip"). I then want to use this variable to look something up in a list in an excel file. The return values for the lookup are in range...

I’m not sure if this is possible but I’m curious to see if anyone has a solution or recommendations. I have a month end accounting checklist with various tasks assigned to different people. We have a consistent problem of people not completing their tasks on time. What I’m after is something...

I am new to VBA and MACRO's Can anyone give me help on writing a code to email a number of contacts automatically for when cells G5:G55 changes from 0 to 1? thanks

Hi I am looking to create a VBA code whereby it converts and sends selective excel sheets as PDF via Outlook mail. In order to avoid any errors and in order to make it easier, the sheet names are saved in range A1:A10. The user should be able to send all sheets mentioned on the above range...

Hi all, Not a Macro genius so will likely need a bit of guidance here. I'm trying to get a macro running whereby when our users click the button to run it, the file then attaches to an email with a new name convention (data from cell A2 & original file name), the email needs to then...

Hello, could you somebody help me with really hard vba code for me? Im beginner and I need to do replace an email with date ...and copy multiple ranges from excel to the body of reply email. Why my macro doesnt work? do you know it? thank you very much.... i tried RangetoHTML for first time...

Hi Guys, First of all, thanks everyone for help.. I have few columns in Excel sheet, what i need is that a BUTTON, where we press that button it will send an email automatically to three email address, If the internet is not working then it will say check your internet connection, I want to...

Sir, Please help me to write a Excel VBA Code or Outlook VBA Code to export my outlook Mails from specified folder to a specified place and make a list in excel containing following <tbody> From Date Subject Body Attachment (Hyperlinked) </tbody> If Possible to rename and save...

I found this code online, which works great for moving all excel files from my outlook subfolder, into a folder I have already have created on my C drive. I was wondering if there is a way to create a new folder on my C Drive based on the excel files in my subfolder. If the excel files in my...

I'm tracking user deadlines using a spreadsheet to keep an eye on what work is outstanding and make sure they don't miss their deadlines - theres other ways and means of doing this but this is the approaching I'm using now as a quick fix... Users have multiple entries and deadlines I want the...

I pretty much changed few variable names from my old code. and i got "Run-time error '5': Invalid Procedure call or argument" on the red line. Im very new to this website, so please help me. Thanks in advance. -------------------------------------------------------------- Public Const...

Hi Guys, Hopefully someone can help me with this issue - I'm fairly new to VBA. I found the following piece of code online which is meant to take data from an email attachment (csv) and paste to a certain sheet in a local Excel file. Code is below and I have highlighted where I am getting...

Hello. I'm a novice when it comes to VBA coding, and I have a question about why I might be getting a run time 91 error with the following code, specifically the argument reading "Else MailDoc.Body = DiscMarker". Any help that can be provided will be greatly appreciated...

Hi All, I'm having an issue with some emails that I send out automatically. I use Ron de Bruin's code to send with the Range to HTML function from Mail Range/Selection in the body of the mail My issue is when I view in OWA, all the formatting is lost. There is no issue viewing in Outlook...

Hello, I found this code on a blogspot belonging to Milos Holovsky. Macros in Excel | What is an Excel Macro?: VBA to send a Outlook Draft Email to a list of emails in Excel I am a complete beginner and I need your help. This macro will loop through a list of emails addresses and send a...

Hi, I'm working on an automation that will connect ms excel and outlook. I want a code to work on both office 2007 & 2010 versions. I'm getting a compile error "Can't find project or library" when i used a code taken from the below thread. VBA References I've given the code below which...

Any one know where I can get some help with VBA and outlook I wish to create a form in outlook that needs to capture data and with the data entered compile a e-mail message.Regards