vba & outlook

I am trying to automate a template in outlook to automatically fill out certain fields based on data provided within the spreadsheet. The spread sheet is called "Progress Report" I want to grab the clients name, which is located in Column A I want to insert the clients membership number which...

Hi guys <tbody> I'm writing macro that finds and reply to mail from shared mailbox. Everything works with my personal mailbox, the problem is addressing the shared one in the code. I tried something similar to the solution from this question: How to...

Hi all. I am trying to use the code below to update my Outlook calendar from an Excel sheet. The code functions fine, but I need to save to a sub calendar rather than my default one. I've tried a few work around's I found online, such as...

Hello Everyone! I would want a VBA code to copy Selected range to Outlook Mail. I am already using this Code to Select my Range: Sub Selection() ' ' Selection Macro ' ' Sheets("XYZ").Select Range("B1:H23").Select End Sub I would want another Macro so that I can run both of...

Hi, this is my code; the error occurs here. Here are the references I've selected, it was working before but for some reason it doesn't now. Please help!

I put together code so that I could add my own appointments via an Excel tracking log to my calendar. This works great when I'm just putting basic appointments in. However, I'm often setting meetings with several people on my team throughout the week. I would like to expand the code that I...

Each week I have to email a range (C14:H42) of an Excel sheet in the body of an email but also attach the whole file. I have Office 2013 which makes this task a little annoying. Would anyone have some VBA code that could automate this for me? thanks

hi everyone,;-) I have 2 different code which one of this allows you to select multiple item from a drop-down list while the other code sends automatic outlook mail. You can find these two code following; As far as I know, to be able to run these code in the same excel sheet, ı have to merge...

Hi Guys, I have created a holiday calendar but at the moment the dates are only visable in excel and I was wondering if anyone knows of any code so that when the value "Booked" appears on the calendar I have created it updates the Outlook calendar. In Column A Would usually be the users Name...

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...

I am working on a project where I can send a text to a list of phone numbers (through outlook) and now, I want to import the replies into a new worksheet automatically. I found and edited some code that seems to work for importing emails from a specific folder, but I cannot figure out how to get...

Hi Excellers, I am trying to fetch my email data into excel. Some how I find the code from net but facing the error like object doesn't support. I investigate and got to know might be its just because of access of multiple accounts. Could you please help me with this: Below is the code...

Hello all - I am trying to search for a solution to my issue but have not had any success thus far. Firstly, I should admit I have only used VBA in Excel - and I have never used in Outlook. Now with that being said, let's get to some general information... I have a template email saved for...

I have a spreadsheet with recipients name in column A, recipients email in column B and mulitple others columns with the information to be emailed to these recipients. Each recipient has multiple rows, and the number of rows per recipient varies each time. The number of recipients also varies...

Good evening to all of you. It's my first post hence forgive me for any error I could make. I would like to register a macro INTO Outlook that, when I push the "send" button registers the sender's mail and all the recipient's email adresses into an excel file. I've encountered a problem. The...

I am a fresher in VBA, i request anyone to help me with the VBA for Outlook to Count the number of Unread emails & Read emails, date wise Seperately and give the output in excel. Your help will be highly appreciated.:)

Hi guys, I was just wondering if anyone knows how to copy a Outlook Calender into Excel using VBA so I can set up a holiday request form. Many Thanks Bloodmilksky

Hi Guys, I was just wondering if there is anyone out there that can help me please. I generate a report for customers which has order progress updates on it along with email addresses that are shown as hyperlinks in the first column. I was just wondering if anyone knew if there was a way of...

Hi there, This one's probably as basic as it gets for some users, but I've tried a bunch of how-to guides and can't get it working. Please see code below; the comment lines should explain what I'm trying to do. The problem is it's coming up with an error "Compile error: Assignment to constant...

I have never written VBA code from 'scratch' so needless to say I am a novice at the most. I have manipulated VBA code in Excel after I have recorded it but Outlook does not have the record function. So, I NEED HELP! lol. :help: I need a piece of code that would go to the subject line of any...