outlook and excel

I have a query/table that updates data when the workbook is opened. The table shows the names of team members by function (each column is for a specific function); sometimes there is no team member so the cell is blank under that function. I added columns at the end of the table to convert the...

Hi group, Please advise me if this is the wrong forum to post to. I've been working to have the VBA code inside an Excel spreadsheet to create a new Outlook email and then paste some copied data from that spreadsheet into this new email. It seems to be doing everything I need it to do except...

Hi all, Im not the greatest with Excel VBA but i have put together a small programme to send an excel range via an Outlook email using send keys and then to return to excel and do something else. The progamme works perfectly in isolation (Excel to Outlook -End) But when i add excel code to...

Hello everyone. Long time reader, first time poster here. I have read the forum rules and the guidelines, and I think I'm good to go but please let me know if I'm messing anything up here. I'm using Excel 2013 and have some experience with VBA but I would still consider myself a newb. I...

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

Reminder Emails via Outlook I'm new at this and been looking around for ages to get the right code and wondered if someone can help please? I have a sheet that I've setup to auto send a email when column "M" has the word "Reminder" inserted by another VBA command. What I want to do is copy...

Good Morning All, I'm trying to make a macro that links an excel list of meetings with an outlook calendar. I have created a macro so far that is able to create the entries and check to see if the entry exists by a specific date (which doesn't allow for any flexibility). I now need to make it...

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

Hi I'm trying to modify the excel program to copy customised worksheet in new workbook, saving it as temp then mailing this workbook and then deleting it. I am having following difficulties: 1. If- else if statement not working 2. Showing object error Sub Send_sheet() Dim OutApp As...

I pretty much changed few variable names from my old code. and i got "Run-time error '5': Invalid Procedure call or argument" Im very new to this website, so please help me. I dont even kno how to make that Code box. Thanks in advance...

I pretty much changed few variable names from my old code. and i got "Run-time error '5': Invalid Procedure call or argument" Im very new to this website, so please help me. I dont even kno how to make that Code box. Thanks in advance...

Looking to be able to set up an outlook rule that sends emails based on a number found in the body of an email. That number corresponds to a particular email address. For example: An email comes in that contains "800000" in the body. Outlook would then reference a spreadsheet that says 800000 -...

I have a file where the names of about 500 employees come up that have not taken a course. I have a total of 10 columns in the file with the information needed to send the employees reminders of the courses that need to be completed. Basically in column "B" we have the names of the employees and...

Hey all, I have a partly working macro that will 'write' the email content to an excel sheet however it only seems to work on Select and cant for the life of me correct it. I am also using mail through exchange server and i want to see if I can have this macro run when outlook is freshly...

Hello all, I am running excel 2010 and outlook 2010 on a Windows 7 machine at work. What I am attempting to do is write a macro that will open an .oft file and copy data from a spreadsheet into the .oft file. I have a very basic understanding of VBA and have had a hard time adapting any code I...

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

Hi Everyone, I have emails in column C and the criteria in column D would be a "Yes". So I want to email everyone in column C when there's a Yes in column D in one big email. Also I'd like the subject to be in cell D1 and the body of the email in D2. Doable? Thanks, Michael

Hi all - I have been playing around with creating a master book for out daily reporting distributions. As several of the reports are still being reviewed prior to sending, we (the reporting team) wanted to create a master file with the different distribution lists and email bodies, etc. in one...

I need to create a database out of daily emails dropping in a specific folder. 1> Emails seggregated into folders upon arrival with the help of RULES, 2> Upon arrival, same emails are Exported to Excel file 3> Excel file on Auto Save & Auto Update mode 4> all exported data is formatted as...

I am using a VBA macro in Excel 2007 to send emails from Outlook 2007 using info in the excel sheet. I wanted to be able to send from a different mail account than the default and added the following line to the macro before the .send command .SendUsingAccount = OutApp.Session.Accounts.Item(3)...