outlook 2010

Every week, I send out several emails with updated reports and hyperlinks. To save time, I created a macro to write and send these emails for me. The generated email is exactly what I want when I display the message. However, I noticed that after the email is sent, my automatic signature appears...

Hi, I've had some code running in outlook for about 6 months at least now and been working fine however since about a month ago it stopped working and i cannot figure out the reason why... It keeps telling me that the file doesn't exist..., i've changed application visible to true and i can...

I have a stock function I use to test to see if Outlook is running before I attempt to draft an email. I've never had problems with it before, but today I ran the program and it doesn't acknowledge that Outlook is running. If I close/reopen the file, it seems to work and if I step through, it'll...

Hi All, Some help please. I'm trying to write vba code that runs on new emails that are already in a shared mail box or arrive at that same shared mailbox. The emails will have a specific subject such as "Output for PS2 model" in the subject line with a crucial difference being that part of...

I am trying to createa macro in excel which will send an email to a large number of people bycopying the contents of a word file as the body of the email. The list of emailaddresses is listed in column A of sheet1. I modified the code below from a post I found earlier. My problem istwofold...

I am trying to createa macro in excel which will send an email to a large number of people bycopying the contents of a word file as the body of the email. The list of emailaddresses is listed in column A of sheet1. I modified the code below from a post I found earlier. My problem istwofold...

Hi Guys, I hope you are all well. I was just wondering if anyone knows how to use VBA/Excel to Create a new all day event In A Specific Calendar in outlook. The name of the calendar would be "UK Customer Services Calendar" and The Date Range would be Defined in Cells A1 And A2. Any Help Or...

Dear Community, I need help with the following and would really appreciate any and all of your help. Currently I have 2 rules set up in my outlook inbox where whenever I send and email it 1)Automatically CC's me and 2) flags this email. Meaning that when I send an email it appears in my...

Hi I am in need of some expertise i'm trying to create a Macro that will be activated by the window scheduler, What i am after is a macro that a week before a date is reached it sends an email in Outlook to one fixed recipient with the workbook attached the dates sit in column F and there are...

Hi there, Below is the macro that I am using to export tasks from Outlook into Excel which I put together using various bits found while googling (See Macro 1). I am trying to merge Macro 1 & Macro 2, so that the user may use the "Save As" dialogue box to save the output file instead of having...

Hello Friday afternoon here and I've just made the fatal error of opening an email that contains work! :eeek: Generic Shared Mailboxes - Outlook I've got to come up with a set of rules/suggestions to put forward at our team meeting next week. Our team has expanded and there could now be up to...

I am trying to take a list of dates (specifically birthdays, anniversaries, etc.), and import them into my Outlook Calendar. I have seen a couple of articles and YouTube videos on this, but I can't get it to work. Using 2010 on both. Does anyone have a sure fire way to do this?

Hi All, I need help with VBA code to send the PDF copies from the folder through outlook using the Excel Distribution list that when I run, would look for the path, grab the file that starts with the client name/Invoice number in Col A, and attach to the email, along with a predefined...

Hi, First posting on this forum so please be patient with me lol. I will include as much info as possible. My aim is to create an excel spreadsheet that holds numerous (2,500 approx) email addresses in column A of a worksheet called "Email Addresses" in a Workbook called "Distribution.xls" I...

Hi, I want to copy a table from an email in outlook to excel automatically whenever I get a mail with subject "Tasks - <currentdate-month>" using VBA/macros I get at least 10 mails each day throughout the month with the same subject. The email body contains a table in the following table format...

Hello, [(Executive Summary) I create a 2x2 table in MS Word. Column 2 is check boxes. I protect the MS Word doc to use the check boxes. But while protected I can not copy and paste it into a Task...where I would save it as a quick table] Where can I look to find some answers for a puzzle I'm...

Hi everyone, I am trying to send email to responsible person in Excel file by creating new workbook with some details and sending to responsible prerson but my code is not saving file and poping up window for email. Please tell what is the error in file and how i can optiomise it Sub...

Hello all, I really hope I can explain myself here: I have this file that I'm working on and need to add a feature in which it takes a fixed cell range, copies it and pastes it in a new outlook email message window. However, I need it to paste the date as an image. I also will need that it...

Excel friends, I have 500 Excel workbooks that I need to email to an email address located inside each workbook, first sheet, cell C2. I need to write the same subject, and body text in each email. I use Outlook, and Excel 2010, and all the Excel workbooks are located in the same folder. How...

Good Morning, I have created the following macro which is supposed to loop through all the data points and create Outlook calendar entries for each line of data in my Spreadsheet. At the moment it looks like it only enters the first line as an entry to Outlook before stopping. What do I need...