Computer Support Forum

Outlook reminder email via Excel macro.

Question: Outlook reminder email via Excel macro.

I would like to ask for an Excel macro which can send an automate email on a certain date every Month.

The dates would be as follows:

1st Monday: Email should be sent to [email protected] automatically
2nd Wednesday: Email should be sent to [email protected] automatically
3rd Tuesday: Email should be sent to [email protected] automatically
3rd Tuesday: Email should be sent to [email protected] automatically
3rd Tuesday: Email should be sent to [email protected] automatically

Subject line: ABC123D5679_Data transfer expected today

Details of the body of the text message:

"Dear All,
This is to remind you that we are expecting the data transfer to be posted in Novartis system today . This is just an advanced intimation.

Kindly let us know if you foresee a delay in the data transfer.

Kind regards,
Rohit"
Many thanks in advance for your help guys. This means a lot.

More replies
Relevance 100%
Preferred Solution: Outlook reminder email via Excel macro.

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Relevance 100.45%

Hi:
I am very new to Excel 2007 and macros. I have a spreadsheet that I am trying to get to send an email reminder to the point of contact [ col b ] 5 days prior to the closure document due NLT date [ col m ]. I am looking for assistance in writing a macro which will accomplish this if it is possible. I have attached the spreadsheet that I referenced.
Your assistance would be greatly appreciated.
Thanks in advance.

desantisj
 

Answer:Excel 2007 Macro to Send Reminder Email

desantisj, welcome to the Forum.
There are already 3 or 4 posts on this forum that have the VBA code (Macro) that you can modify for your Workbook if you can read the code. Zack has written the code so it is a bit complicated, but it should be a case of substituting your Cell references that hold the data for the ones that others have used.
Otherwise it is a case of waiting for an Excel guru to come along and help. If none of them come along I can probably help you, but I normally work with Access.
 

2 more replies
Relevance 99.22%

Hi

This is a tuffy........

I want a macro so that when i type a message into a cell it will put it into outlook as a reminder, or even a simple macro button that opens outlook in the scheduler.

Any ideas?

Thanks
 

Answer:Excel macro links to Outlook Reminder

Try this link.
 

1 more replies
Relevance 90.61%

hi !
I have a spread sheet of 100 of employees , i like every time the expiry date come for there id a notification email come to me , i attach the example excel sheet please help me with that, i am just learning VBA not very good in it i am using windows 8
 

More replies
Relevance 81.59%

Hi all,

I need to know if is it possible that a macro in Excel sends an email containing the visible cells using Microsoft Outlook.
btw, I saw some code on the internet, that saves the visible cells in a new excel file and attach it in a new email using Microsoft Outlook, but I don't want to have attachments in the email.

thanks for any possible help.
 

More replies
Relevance 75.85%

I have searched and read the topics on this, however I am apparently below beginner and need someone to walk me through the entire process. I need an email sent to myself and 2 other co-workers one day before an item listed in my spreadsheet expires. I have the expiration dates are listed in column F. I have not entered any email addresses yet.I would like, as I have read in previous threads, for the system to open and check itself daily. Any help is greatly appreciated, and I will need a very basic, step by step hand holding description.
 

Answer:Excel Email Reminder

Hi, welcome to the board.

I suggest the following link, there enough information and samples there too.

http://www.rondebruin.nl/sendmail.htm
 

2 more replies
Relevance 75.03%

I have a list of task (maintainance schedule) to do... and they are required to be done in a by certain different dates regularly (eg. every 14 days or every 28 days)

I have a specific maintance date for each task within the same row. Is there anyway i can make it to automatically send an email to remind me or another person a day before it's due??

thanks
 

Answer:Set email reminder base on Excel

16 more replies
Relevance 75.03%

Hello Everyone!

This is my first post here. I need your help in developing a mechanism to send an automated outlook mail, when the due date of a project is nearing 3 hours, 2 hours & 1 hour away from the current date & time. The script should preferably run automatically every time the PC is running when the excel file is open.

In the attached excel file, An email should go of to -email address (Col. F), with subject "number (Col. B) is due on Due date and time (Col. E)", and body "Dear Name(Col. F), please finish your project asap".

Also, the script should put a check mark on Reminder sent column (Col. G) after the mail is sent, the script should also check if the value of the cell is blank before sending email.

I have scoured the forum for similar problems, and although I found a number of of threads,I am not proficient enough in VBA to modify them to my needs.

I'd really appreciate any help,
 

Answer:Automatic Reminder email from Excel

Hi, I suggest you do some searching, there are quiet a few posts with the same questions and the necessary solutions.
I worked on one or two but cannot remember the names, so just do a quick search and you'll find the answres with the necessary code.
Always to glad to help on if you're still stuck
 

1 more replies
Relevance 75.03%

If I am doing an automatic email reminder when something is past due:

do I always have to open the Excel document for the macro to run and the reminder to sent out?

Thanks,
 

More replies
Relevance 75.03%

Hi guys,
I have a list of some certifications and their respective expiry dates written in Excel sheet. What I want is to be getting Auto reminder few days before, on and after the expiration date.
Attached is the VBA program that I tired to use but it was reading the whole data instead of being selective. Also attached is an extract of the excel sheet.
Pls I will appreciate any help
Thanks,
CJ
 

Answer:Auto Email reminder from Excel

Have you read the Thread under yours -
http://forums.techguy.org/business-applications/856705-automatic-email-excel-based-date.html
 

1 more replies
Relevance 75.03%

hi there,

I have a list of memberships that need to be renewed at different dates (eg. every two or three years depending on type of membership)

Is there anyway i can make it to automatically send an email to remind me or another person the day it's due to renew?

The list is on excel with expiration date in one of the columns
thanks
 

Answer:Set email reminder based on excel

Hi, take a look at some of the posts, there are quiet a few that do just that, they may need a little editting for your purpose but...
Here's a simple module that does just that, all you need to do is wriet a amcro that fills in the blanks

Code:

Function MailData(mSubject As String, mMessage As String, Sendto As String, Optional CCto As String)
Dim eSubject As String, Sendto As String, CCto As String, EBody As String
Dim app As Object, Itm As Variant
Set app = CreateObject("Outlook.Application")
Set Itm = app.CreateItem(0)

With Itm
.Subject = mSubject
.To = Sendto
If Not IsMissing(CCto) Then .CC = CCto
.Body = mMessage
' .Attachments.Add (NewFileName1) ' Must be complete path
.Display ' This property is used when you want
' .send
End With
Set app = Nothing
Set Itm = Nothing
End Function


P.S. You forgot to mention the Excel versio you're using
 

1 more replies
Relevance 75.03%

I have a real simple need. Well, it's probably simple for some. I have a sheet built to track employee hire dates and eval dates. I would like to assign excel to open everyday at a time and then evaluate the cells with the eval and raise dates to see if an email needs to be sent to the supervisor. If so a simple "there are employee items coming due" email is sent to the supervisor. The super will go to the document and take care of the rest. Dta is not real. The email with the employee name isn't the one I'll be sending to. The Team Manager at the end is where the email will be going to for all on the sheet. I would appreciate the help. Running windows 7 and office 2013.
 

More replies
Relevance 75.03%

Hello there,

First time posting and very average excel capabilities... Working on generating a code that will send automatic email reminders 7 days prior to the date within rows F-P. Recipients contact information is in column S.

Thanks for your time.

Tim
 

More replies
Relevance 75.03%

Hi,
I'm kinda new to VBA and excel programming and am looking for a way of sending an automated reminder 60 days before the expiry of training already completed. column G contains the email recipients, Column E has a title Asbestos Awareness and the cells in column E the expiry dates for employees.
I would appreciate if anyone has sample code I could try.


Thanks sooooooooooo much for any help or advice.
Regards
Vinny
 

Answer:Automatic Email reminder in excel

Hi Vinny,
welcome to the forum, you're the second one this week with the same question, and just like the other poster I do not think you took the time to search for similar posts.
I suggest you do hat, there are several posts with the similar questions and also with the answres and code provided.
 

1 more replies
Relevance 74.21%

hi there,

I have a list of memberships that need to be renewed at different dates (eg. every two or three years depending on type of membership)

Is there anyway i can make it to automatically send an email to remind me or another person the day it's due to renew?

The list is on excel with expiration date in one of the columns
thanks
 

Answer:Solved: Set email reminder base on Excel

you have another thread here
http://forums.techguy.org/business-applications/1055728-set-email-reminder-based-excel.html
please do not duplicate posts - closing this one
 

1 more replies
Relevance 74.21%

Hi Guys,

I have just joined this forum, I found some solutions given by Zack quite useful to me. Thank you so much.

But also need help in taking it further, as I have created a worksheet with lots of data which will have to be incorporated while sending auto email reminders to various admin officers depending on the dates, especially for Statutary payments like Telephone, Electricity etc.

If any body can help....... Please...............
 

Answer:Auto Email reminder from Excel Sheet

http://forums.techguy.org/business-applications/773873-how-make-excel-send-email.html
 

1 more replies
Relevance 74.21%

This is my first time posting on here so I hope this is the right place.

I have attached a spreadsheet I will need to populate and we would like to send staff members an email reminder before they need to do their task. Maybe a day or the morning of the day is fine, as long as they get the reminder. I was just wondering how I would go about doing that?

As the Excel file would need to be opened in order to work , I was also wondering how I would be able to set it to open on the start up of everyones machine. Even if it can only start up the programme then it will be obvious to people what they need to open.

Could the email or subject include as much info as it can. Like name, company, job title and contact number. and for it to be sent to the Asignee.

We will then change the next contact date once completed.

Any help would be appreciated!

Thanks
 

More replies
Relevance 74.21%

Hi everyone,

I have no prior experience with Macro/VBA and would need help in creating an excel spreadsheet where an email reminder would be sent 60 days, 30 days and 7 days respectively if the project is not completed to the email stated in the 6th column with information from its row. If its completed, the checkbox would be checked and no mail will be sent.

The email should look like:

To: <email stated in that row>
Subject: Reminder to complete project within (e.g. 60 days)

Body:
Dear all,
Reminder to complete IN1661234 by 31st Aug 2016.

<personal email signature>

Do I need to create a button where I have to click in order for those reminders to be sent or will it be sent automatically everyday as long as the spreadsheet is opened?

Also, is it possible to create 3 different email template for each reminder days, such as 60 days prior to the deadline, the subject of the email would be First Reminder, 30days would have Second Reminder and 7 days prior would have FINAL REMINDER and a urgent marked on the email?

And how do I change the email where those reminders will be sent from?

Any help with regards to the above would be greatly appreciated. Thank you so much.
 

Answer:Auto Email Reminder from Excel when project is almost due

16 more replies
Relevance 74.21%

I have a list of jobs (jobs schedule) to do... and they are required to be done in a by certain different dates regularly.

I have a specific jobs date for each task held in a colu. Is there anyway i can make it to automatically send an email to remind me or another person a day before it's due??

Another question - I have a basic dashboard when a job is overdue I want the cell to flash RED

thanks
 

Answer:Set email reminder based on conditions on Excel

10 more replies
Relevance 73.39%

Hi lovely people!

I hope you can help me out - I'm new to macros. In regards to the attached excel file, I need to achieve 3 main goals:
Automated pop-up message - For each phone that is overdue for delivery (ie current date is more than due date), I need a pop-up message upon opening the excel sheet. The pop-up alert should say which phone is due (stock #), and how many days overdue it is (current date minus due date)
Automated email reminders - emails to send to various email accounts (individuals in my team) to remind them of overdue phones. The email should include details like the phone, stock #, supplier, due date and how many days overdue. I want the first email reminder to be sent on the due date itself, then 2nd reminder on the next day, and subsequent reminders every 3 days.
Have a separate sheet listing all the overdue items that need to be followed-up.

Lastly, but is it at all possible to create two versions of the same stock list? I.e. one sheet in English, and the other sheet in French. And any edits in either sheet will update the other version.

Cheers!
 

Answer:Excel help! Automated pop-up box and email reminders, and reminder list

Hi, welcome to the forum.
Have you doen a search in this forum.
There are many posts that relate to triggering a mail message based on calculations and expiry dates, etc.
You will of course need to edit some solutions for your purpose, but I do suggest you take a look (search) and probably you'll find what you need.
The question about the two languages is custom macro coding and will take some time.
Your sample contains onle one row of data, but nothing more to go on.
Do some homework (searching the forum) and someone will be able to help
Please don't forget to mention the Excel version, as far as I cansee it's at least version 2007 but it could be 2010 or newer
 

1 more replies
Relevance 73.39%

Hello Everyone!

This is my first post here. I am using Excel 2013 OS win 7. I need your help in developing a mechanism to send an automated outlook mail, when the due date of a project is nearing 3 hours, 2 hours & 1 hour away from the current date & time. The script should preferably run automatically every time the PC is running when the excel file is open.

In the attached excel file, An email should go of to -email address (Col. F), with subject "number (Col. B) is due on Due date and time (Col. E)", and body "Dear Name(Col. F), please finish your project asap".

Also, the script should put a check mark on Reminder sent column (Col. G) after the mail is sent, the script should also check if the value of the cell is blank before sending email.

I have scoured the forum for similar problems, and although I found a number of of threads,I am not proficient enough in VBA to modify them to my needs.

I'd really appreciate any help,
 

Answer:Automatic Reminder email from Excel 2013 in Windows 7 pc

closing duplicated post
continue here
http://forums.techguy.org/business-applications/1141421-automatic-reminder-email-excel.html
 

1 more replies
Relevance 72.57%

Hi All,

My name is Diego.

Can anyone send me code to automatically send me an email when the date listed in "column J" is the same date as today. Also, it needs to email only once and even if I am not running excel or at my computer. I want to use Microsoft Outlook and use the ClickYes program as well if this helps that was talked about by Zack Barresse in

http://forums.techguy.org/business-applications/710581-solved-automatic-email-alerts-using-2.html
Essentially I have to be reminded of a reapplication for specific state licensures on healthcare courses I provide. I don't want to forget which courses I have to reapply for so I need to have a program that will look at a date which I have in column J and then email me to remind me of this.

BTW - I am using Outlook 2007 and Excel 2007 on Vista.

Thanks. I appreciate your help! Also, extra points and praise for the person who solves this problem!
 

Answer:Automatic Email Reminder from Excel based on Date in Cell

Please do not post duplicate threads.
One thread per issue.
Continue replies for this issue in this thread: http://forums.techguy.org/business-applications/856705-automatic-email-excel-based-date.html
Thank you.

Closing thread.
 

1 more replies
Relevance 72.57%

Hello Friends,I am leading the finance team. I need to create an excel worksheet which tracks all my invoices raised on different clients alongwith the due dates. I want excel to send an auto email to client after 2 days of due date and second reminder after 7 days or so.I am from finance back ground and thus do not have any idea of running any codes or macros.Can any body help me with this on priority basis?Thanks and regards,Manish

Answer:Excel worksheet to send auto email reminder to clients

Try here:http://www.rondebruin.nl/sendmail.htmLook under the section: Add-ins and Worksheet TemplatesMIKEhttp://www.skeptic.com/

2 more replies
Relevance 71.75%

For some reason there is a problem with this programme I have built (with help from Computerman) now I have transferred it to another excel file.

When I try to set a Callback Reminder (my terminology), once I have entered the details an error comes up for some reason. The programme has been tried and tested by itself and worked brilliantly but for some reason it doesn't now.

Please use password lfc1979 on the login screen
 

Answer:Solved: Excel outlook calendar reminder

9 more replies
Relevance 71.75%

Hi, this is my first post here and I will preface this by saying I am not familiar with VBA/VBScript language at all (only that it exists and perplexes me), which is why I'm requesting your help!
I have an Excel spreadsheet that I'd like to have send me an Outlook email reminder 6 months after the specified start date, without having to open the Excel file so the macro can run. The reminder email can be simple, just a short message like "Referral Alert: Check Spreadsheet"

I've attached a test file with the columns needed highlighted in yellow.

If this is too tall of an order, I understand!
 

Answer:Send Outlook reminder on specified dates from Excel

As far as I know, this is impossible in the given scenario. Macros only run once a file is loaded; therefore, not having the file loaded means any code won't execute.
 

2 more replies
Relevance 70.52%

Hi,

i have used the following to get automatic alerts setup when a due date is near:
https://forums.techguy.org/threads/...ue-date-reminder-based-on-excel-file.1129238/

but instead of this looking at the due date column, i would like it to look at a conditonal formatted column, which shows status as either "due" and "expired" depending on due date. i would like it send out to all those with "due tag and not "expired"

I have name in column A, details in column B, emails address in column C, status in column i, and reminder in column k
Somethng else i would like to do later on, if at all possible,is to get a particluar email from outlook be transfered to excel and and then emailed to specific people based on a status column. So if an email is recieved to say a project is extended or cancelled,, it contents is copied to excel and emailed back out to certain people.
Thank you for your support.
 

More replies
Relevance 69.7%

Hi Everyone!

This is my first post here. I need your help in developing a mechanism to send an automated outlook mail, when the due date of a project is 7 days away from the current date. The script should preferably run automatically every time the PC is running. without the excel file necessarily open.

In the attached excel file, An email should go of to -email address (Col. D), with subject "Project (Col. B) is due on Due date(Col. C)", and body "Dear Name(Col. A), please update your project status".

Also, the script should put a check mark on Reminder sent column (Col. E) after the mail is sent, the script should also check if the value of the cell is blank before sending email.

I have scoured the forum for similar problems, and although I found a number of of threads,I am not proficient enough in VBA to modify them to my needs.

I'd really appreciate any help,

Thanks
 

Answer:Automatic Outlook mail due date reminder based on Excel file

8 more replies
Relevance 69.7%

Hi Everyone!

This is my first post here. I need your help in developing a mechanism to send an automated outlook mail, when the due date of a payment is 10 days away from the current date. The script should preferably run automatically every time the PC is running. without the excel file necessarily open.

In the attached excel file, An email should go of to -email address (Col. Q), with subject "Vendor Payment (Col. C) is due on Due date(Col. M)", and body "Dear Name(Col. P), please update the payment status".

Also, the script should put a check mark on Reminder sent column (Col. Q) after the mail is sent, the script should also check if the value of the cell is blank before sending email.

I have scored the forum for similar problems, and although I found a number of threads, I am not proficient enough in VBA to modify them to my needs.

I'd really appreciate any help,
 

Answer:Automatic Outlook mail due date reminder based on Excel file

15 more replies
Relevance 69.7%

Hello all,

I'm receiving mail alert based on date only, it is not considering the month into the account.. Kindly suggest..

Attached the excel file with macro...
 

Answer:Automatic Outlook mail due date reminder based on Excel file

16 more replies
Relevance 68.88%
Question: Excel Email Macro

Hi

I am trying to write a macro in Excel 2003 to automatically send an email using Outlook to a list of individuals asking them to confirm their personal details using the attached template. Could someone show me where I am going wrong with the script please?

Many thanks
 

Answer:Excel Email Macro

16 more replies
Relevance 68.88%

Any way of controlling the time a email is sent via a excel spread sheet using vba?
 

Answer:Excel - macro email-

6 more replies
Relevance 68.88%
Question: Excel Email Macro

Hi All,

I have a spreadsheet and i am needing to create a macro that will opena new message in Outlook and populate the 'To' Field with one cell and then the 'CC' field with 2 email addresses, one from one field and the other from a different field. then the subject from another field and then the body from another. it then leaves the message window open so i can check it right and hit send.

I found the script the other day but can not find it anywhere including this site.

Any help on this will be great.

JPL

Any
 

Answer:Excel Email Macro

Hi JPL,

You could use this function, just pass the values to it
Code:

Function MailData(mSubject As String, mMessage As String, Sendto As String, Optional CCto As String)
Dim eSubject As String, EBody As String
Dim app As Object, Itm As Variant
Set app = CreateObject("Outlook.Application")
Set Itm = app.CreateItem(0)

With Itm
.Subject = mSubject
.to = Sendto
If Not IsMissing(CCto) Then .CC = CCto
.Body = mMessage
' .Attachments.Add (NewFileName1) ' Must be complete path
.Display ' This property is used when you want
' .send
End With
Set app = Nothing
Set Itm = Nothing
End Function

It's from one of the posts, I do not remember which one
 

1 more replies
Relevance 68.88%

I have an Excel model (office 2000) which has a range of cells that contain if/then statements. I'm trying to get Excel to automatically send an email if any of the cells within that specified range were to provide a value that was false. Is this possible? Thanks for any insight.
 

Answer:Email Macro in Excel??

16 more replies
Relevance 68.06%

Windows 7 --------------------------------------------------------------------------------First thing...I know nothing about macros!! I do know a very little about formulasI have created "IF" formula in excel 2010, based on a date it will create a send due in column "E", =IF(D5=$A$2,HYPERLINK(mailto:"&$K$1&"?subject="&A5&-B5&"&body="&$C$3,"sendworks great but, I have to go thru 86 rows in column "E" and hit "Send Due" numorous times,then hit send again on all the emails, can we automate this some how, like a macro that engadges when I open my outlook every morning?Thank u

Answer:Need Macro to automate email from excel

I have written code in Outlook, which is essentially a template, you fill in the details, all sorts of stuff happens accordingly to what you have selected, and you press send and it will send the emails to whoever it is you want. Iv done this in Outlook, so my question is, why do you need this to be done in Excel? is Outlook acceptable?

3 more replies
Relevance 68.06%

I have a user who wants to create a macro which will automatically send an excel spreadsheet into outlook and email it.
Any suggestions welcome. Thanks.
 

More replies
Relevance 68.06%

My sense is this is a pretty simple request, but I'm completely illiterate when it comes to VB.

I have an excel spreadsheet with a number of data points. I'm looking to export the entire sheet to a CSV file and send it via Outlook. Any suggestions?
 

More replies
Relevance 68.06%

Hello all;

I am new to this forum and also to Excel macros. I have a large Excel file detailing financial accounts with my small business.
Anyway, I would like to email any customer who has an overdue balance as per column V in my attached sample file (any customer with a greater than zero value in V). I would like to send an email; something like this:

Joe Wilson;
As of 2/28/11 (latest date in the row that is on/after the current date), your account is currently overdue and you owe $1500.00 (G3).
Thank you.
Treasurer
I found several other threads explaining how to send an automatic email from Excel, but I haven't found one for sending an individualized email to a list of recipients. If this question has been answered, please feel free to redirect me. Otherwise, I'd appreciate any suggestions. Please let me know if I can detail my needs any better.
Thanks!
 

Answer:Excel Macro: Auto Email

welcome to the board.

I put some code in the sheet

The macro name is CheckAndMail

Let me know if this is what you need

PS: I just corrected something I came accross and have re attached the corrected sample
 

2 more replies
Relevance 67.24%

Hi there,

I have a workbook which i would ideally like to send an automated mail when the date is within 30 days of "Todays date" .
I have found something similaar on past posts whichprints certain cells to an email but is triggered by a button press not date, but wondered if anyone could adjust it for me as my excel knowledge is very limited.
I really am struggling.

The password for the spreadsheet is Kalibratedbyme (capital K)

Best regards and many thanks!
 

Answer:macro to allow a date to send an email in excel

The content is different but why are you duplicating a post?
 

3 more replies
Relevance 67.24%

Hi - I have a list of names for a particular company where I have the first name and last name of the customer plus the email naming convention their company uses. For example the company's email naming convention is: [email protected] Is there a way I can create an Excel Macro that will automatically create the email from the available information? For example if I create three columns where one has the first name, last name and the @companyurl.com?I hope someone can help with this as it will save a lot of time!!Thank You!

Answer:Need Excel macro to creat email address out of just a name

This can be done fairly easily, but I'm not going to offer any suggestions.Since it appears that you do not work for this company, I can only assume that this will be for some sort of mass, unsolicited mailing. If your project was sponsored by the company in question, they would supply you with a distribution list and you wouldn't have to build your own.For all I know, I'm on that list of names that you have and I don't need any more unsolicited email.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 67.24%

Hello

I need to come up with a simple outlook macro (or script?) that fires off whenever a new email meeting certain criteria is received.

1. new email is received with "please refresh quotes" in the subject
2. outlook runs a macro that causes another macro to run (the second macro is located in a excel workbook which is already running in my office pc)
3. the excel (attached) is simply refreshing market prices and emails whenever the macro is triggered. because the quotes are obtained via a DLL feed I can only get it at work.

the purpose is simply to get live market quotes on my personal email from my work email whenever i need.
thanks in advance for your help.
 

Answer:Solved: Run excel macro when new email is received

9 more replies
Relevance 67.24%

Hi,

Is it possible for an email to trigger an Outlook macro and then for that Outlook macro to trigger a macro, which is external to Outlook (and Office)?

I'm using Outlook 2007
 

More replies
Relevance 66.42%

Hi
I need help writing a macro that takes an Excel file to email.

The Excel file is a data base, I wanted the Macro to take the email from a column of the Excel file, and send out the email to all the emails in the database, if possible also adding a column of the Excel file to address the specific person.

thank you.
 

Answer:need help writing a macro that takes Excel file to email

Can you post a sample file? Please remove any sensitive data.

Rollin
 

2 more replies
Relevance 66.42%

Hy guys

2nd time i am posting stuff for help, and as i was helped before i will again look forward the response.

I have a file of excel, in which i am sending emails to different candidates of admission, with scan letter placed in the same folder by name.

I want to edit this code, which could select attachment based on Column A list adjacent to the email address

I am attaching the file also pasting the code

Sub Test1()
'For Tips see: http://www.rondebruin.nl/win/winmail/Outlook/tips.htm
'Working in Office 2000-2013
Dim OutApp As Object
Dim OutMail As Object
Dim strbody As String
Dim SigString As String
Dim Signature As String
Dim cell As Range

Application.ScreenUpdating = False
Set OutApp = CreateObject("Outlook.Application")

On Error GoTo cleanup
For Each cell In Columns("B").Cells.SpecialCells(xlCellTypeConstants)
If cell.Value Like "?*@?*.?*" And _
LCase(Cells(cell.Row, "C").Value) = "yes" Then

Set OutMail = OutApp.CreateItem(0)

strbody = "We at Graduate School of Engineering Sciences and Information Technology are extremely pleased to know that you have selected Hamdard University as preferred choice for your graduate/post-graduate Studies. " & vbNewLine & vbNewLine & _
"Hamdard University is a pioneer Higher Education Institute (HEI) of Karachi producing Masters and PhDs in the fields of Engineering, Computer Sciences, Information Technology, Energy and Environment since 19... Read more

Answer:Attachment based on cell value in a excel email macro

anybody ???
 

2 more replies
Relevance 66.42%

I found this code in this forum.
i want to add recipient as CC or BCC. What is the correct code for that?
Thanks in advance!

Code:
Public Sub email()

Dim SubJ, Recip As String

SubJ = "Enter your suject"
Recip = "[email protected]"


ThisWorkbook.SendMail Recip, SubJ

msgbox "Email Sent"

End Sub

 

Answer:Send excel sheet ( email) through macro with recipient and cc

6 more replies
Relevance 66.42%

Hello,

My first post, sorry to be a leech right off!

I'm trying to automate some of my day to day emails. I'd like to get a macro set up that will send an email from Excel and paste the range I select in to the body of the email. Would be great if it would send to a list of addresses listed on the page as well.

Using the attached example, I'd like the macro to take whatever range I highlight on the table, copy it to the body of an email and send it to the group of emails listed on the right side.

I'm learning excel, this would help me a lot! I'll be editing this to fit a variety of other tasks. I hope it can be flexible. Thanks in advance.

Chris
 

Answer:Macro: Email Range/Selection to group from Excel

http://www.rondebruin.nl/mail/folder3/mail4.htm

I have done the looping attached.
 

2 more replies
Relevance 66.42%

Hi there - Using MS Access 2007.
I have a FORM with a macro that runs a query to generate ONE excel file and attaches to email using MS Out look to send out. - That Works great.

Problem: Multiple users to send email & attachment.
I would like for the macro to generate excel file (S) - based by the UID.

Can someone suggest a better way of handling this that is not time consuming?

Thanks In advance!
 

Answer:MS Access 2007 - Macro > Excel > Auto Email

Access can open Outlook and send an attachment to mutiple recipients either as a list or as individual emails.
So are the attachments all the same for the recipients?
 

1 more replies
Relevance 66.42%

Hey guys, I had some great assistance from computerman29642 earlier on this macro. It works perfectly on my own calendar; however, I need to target a specific shared calendar. Hopefully it could be user imput by a msg box. I am struggling to find information on how to do this.

The first thread was this
http://forums.techguy.org/business-applications/835748-solved-excel-macro-outlook-calendar.html

So, as for now the example works. But before it writes to the calendar I want a msg box pops up asking for the desired calendar(Sometimes more than one word), and then target that calendar and write the data. A simple little box that confirms or denies progress (I am pretty sure I can figure that one out) Any suggestions or directions where I can learn more fire away please. Ill attach a copy of my test again.
 

Answer:Excel to Outlook Macro

16 more replies
Relevance 66.01%

I found how to send an email from an Excel Macro (http://forums.techguy.org/business-applications/1056070-solved-excel-email-outlook-code.html)

Here is the code I'm using:
Code:

Sub Email_Test()
'
' Macro11 Macro
' Keyboard Shortcut: Ctrl+r
Dim eSubject As String
Dim Sendto As String
Dim CCto As String
Dim Body As String
Dim app As Object
Dim Itm As Variant
Set app = CreateObject("Outlook.Application")
Set Itm = app.CreateItem(0)
'Populate variables

mSubject = "Excel EMail Test"
Sendto = "[EMAIL="[email protected]"][email protected][/EMAIL]"
CCto = ""
mMessage = "You have received Knowledge Document Feedback for your domain."

With Itm
.Subject = mSubject
.To = Sendto
If Not IsMissing(CCto) Then .CC = CCto
.Body = mMessage
' .Attachments.Add (NewFileName1) ' Must be complete path
.Display ' This property is used when you want
' .send
End With
Set app = Nothing
Set Itm = Nothing
End Sub
Is there a way to format the message section with bullets? How about paragraph breaks?

Name: John Doe

Date: 6/15/2012
Doc #: KM123456
Etc:
Etc:
Comments:
I'm perfictly willing to look at how-to documentation if someone can point me in the right direction.

Thanks
firstshot
 

Answer:Solved: Formatting Excel Macro Email Message Section

Hi, I haven't really looked myself but instead of bullets I generally use a dash and a tab
Paragraph as such are not possible but you have the linefeed and carriage return

example to add to your macro code before calling the mail proc
Code:

Dim mytext as string
mytext = vbnullstring
mytext = "Dear Jon Doe" & vbclrf & vbcrlf
mytext=mytext & "-" & chr(9) & "Date :" & the date variable & vbcrlf
mytext=mytext & "-" & chr(9) & "Doc #:" & the dos variable & vbcrlf
mytext = mytext & "-" & chr(9) & "Etc :" "etcetera"
mytext = mytext & vbcrlf & vbcrlf
mytext = mytext & "Sincerely yours," & vbcrlf & vbcrlf
mytext = mytext & "Jane Doe" & vbcrlf

vbcrlf can also be replaced wij Chr(10) or Chr(13)

See it this helps.

Maybe html formattingis possible but this works just as fine.
 

3 more replies
Relevance 66.01%

Hello,

I have a list of email addresses that have either:
[email protected]
[email protected]
[email protected]
or no corelation to [email protected]

I'm looking for a macro that will take the emails with dots in them and put the first and last names into cells next to the email. The others I can do by hand. PLEASE HELP!
 

Answer:Solved: Excel Macro to convert email addresses to names

16 more replies
Relevance 65.6%

Hi,

I am an extremely basic user who has managed to get a basic macro together through multiple web searches and am now stuck...

I have dates entered into the following columns in excel: 14,15,16,26,27,28

I have managed to make the macro create appointments for 14,15,16 but not the rest. Also, every time i run the macro it creates a new appointment regardless if one already exists. I saw on this forum about adding a word to another column which the macro searches for and if found doesnt create a new appointment - or something to that extent. Here is what i have:

Sub POATEST()
' Create the Outlook session
Set myOutlook = CreateObject("Outlook.Application")

' Start at row 7
r = 7

Do Until Trim(Cells(r, 1).Value) = ""
For Each cell In Range(Cells(r, 14), Cells(r, 16))
If cell.Value <> "" Or 0 Then

' Create the AppointmentItem
Set myApt = myOutlook.createitem(1)

' Set the appointment properties
myApt.Subject = Cells(r, 1).Value & " " & "Update Due"
myApt.Start = cell.Value
myApt.categories = "Yellow Category"
myApt.ReminderSet = True
myApt.Body = "blah blah blah"
myApt.Save
End If
Next cell
r = r + 1
Loop
End Sub

Please can someone assist by:
1. making it apply for all the columns originally mentioned
2. making it search if an appointment for that item (ie that row) exists - if not, create appt, if so, do not create appt and insert "Yes" in column 29

Thank... Read more

Answer:Excel Macro - Add Appointment To Outlook

HI,

Check this code you may be able to modify it.
Have not used it in a long time but....

Code:

Sub AddAppointmentsToCalendar()
Dim OLF As Outlook.MAPIFolder, objItem As Outlook.AppointmentItem
Dim i As Long, lngItemCount As Long, r As Long
On Error Resume Next
Set OLF = GetObject("", "Outlook.Application").GetNamespace("MAPI").GetDefaultFolder(olFolderCalendar)
On Error GoTo 0
If OLF Is Nothing Then Exit Sub

Application.StatusBar = "Adding appointments to Outlook..."
With wsSheet1
.Activate
r = Range("NewAppointments").Row + 1
Do While Len(Range("A" & r).Formula) > 0
On Error Resume Next
Set objItem = OLF.Items.Add(olAppointmentItem)
On Error GoTo 0
If Not objItem Is Nothing Then
With objItem
.Start = Range("A" & r).Value
.End = Range("B" & r).Value
.Subject = Range("C" & r).Value
.Body = Range("D" & r).Value
.Categories = Range("E" & r).Value
.ReminderSet = False
.Save
End With
Set objItem = Nothing
End If
r = r + 1
Loop
End With
Application.StatusBar = False
Sheets("Appointments").Select
Range(&... Read more

1 more replies
Relevance 65.19%

Hi all

Looking for some help! Working on an excel document which contains a button I need to send to multiple people, that's fine what I need is for the subject field of the email to take the contents of a particular cell in the workbook and display that. My current code is;
Code:
Sub SendThis_ActiveWorkbook()

Dim Recip()
With ActiveWorkbook

ReDim Preserve Recip(0)
Recip(0) = "[EMAIL="[email protected]"][email protected][/EMAIL]"
ReDim Preserve Recip(1)
Recip(1) = "[EMAIL="[email protected]"]example[/EMAIL][EMAIL="[email protected]"][email protected][/EMAIL]"
.SendMail Recipients:=Recip, _
Subject:="Vacancy Authorisation " & Format(Date, "dd/mmm/yy")
End With

End Sub
Basically I want the subject to be "Vacancy Authorisation [cell contents] 01/01/2000" so I want the contents of a cell to appear in between the date and the "vacancy authorisation" part of the subject line. Assistance appreciated!
 

Answer:Solved: Excel email macro auto-populate subject line

Subject:="Vacancy Authorization " & Range("A1").Value & " " & Format(Date, "dd/mmm/yy")

Regards,
Rollin
 

2 more replies
Relevance 65.19%

Although decently experience with excel, I am quite new with VBA and I cannot "record" this macro, so any help writing this in VBA is much appreciated.

1) I need to create a macro that will take a number that is entered into a cell, and upon hitting a button in the excel sheet create an email where the subject line is the number that was in that original cell.

1b)I would like to do this without changing the name of the excel file though, or at least have another macro that resets the file to its original name.

2) Also, if possible, the same macro/vba as above, only with two cells, a number in one and a name in the other, which then shows up as "Number-Name" as the subject line in the email.

Thanks to anyone that can help - Mike
 

Answer:Excel Macro -> email created with field data as subject line

8 more replies
Relevance 64.78%

Hi all,

I'm looking to create an Excel document and I need to put cells with dates in that are linked to outlook calendar reminders.

I.e I need a macro that when I click the link it sets the reminder on outlook for the date allocated in the cell.

could anyone please help me with this as i have never created a macro and would greatly appreciate any help you could give me.

Thanks

More replies
Relevance 64.78%

Hey guys, I am quite new to creating macros. I do have some primitive experience with code. My goal is to take 3 or 4 colums of information and put them into Outlook Calendar.

A- Discription B- Start -C Finish

So, in the Calendar in outlook it would show a discription and connect the dates in B and C to the days in the Calendar. I don't know if it can be done. At my current state I can't figure out how to get even one to move over. Any suggestions on where to start??

I am running Outlook and Excel 2003 all updated. On Windows XP Pro Service Pack 2.
 

Answer:Solved: Excel Macro to Outlook Calendar

16 more replies
Relevance 64.78%

Moved from Software Development
Hi, We are a team of 25 who all use the same contact list (which contains addresses, organisation name, tel numbers, emails, contact names etc for approx 600 organisations). We regularly have to bcc all these contacts in to emails. We previously all held the distribution lists (sorted alphabetically by email) and had to let the rest of the team know when details changed so they could be updated by all. The problem with this was that the distribution lists do not hold all the information needed (e.g. addresses, organisation names) and contact information was not always updated as it should have been. I have updated an excel spreadsheet containing all the information and I would like to create a macro for all the team to periodicaly import this data in to Outlook Contacts and possibly create distribution lists from these. I trust this makes sense I am using Outlook 2003.
Thanks
 

More replies
Relevance 64.78%

I need a macro that will 1) create a new outlook folder, then 2) create new Outlook distribution lists from data in an Excel sheet.

The Excel sheet has columns:
A - ID
B - DEPARTMENT_DESC
C - STUDENT_LEVEL_DESC
D - MAJOR_DESC
E - PROGRAM_DESC
F - EMAIL_ADDRESS
G - LAST_NAME
H - FIRST_NAME

The first entry begins in row 2 with row 1 being the column title.

I need a new distribution list to be created for each department (column B) and each student level (column C). (Column B will only ever be one of 6 values, column C will only ever be one of 2 values. Therefore, the macro should create 8 distribution lists.)

I have looked at threads similar to this question but I can't seem to get anything working.
 

Answer:Macro from Excel to New Outlook Distribution List

I saw something you might could work with here: http://www.helenfeddema.com/CodeSamples.htm
scroll down for sample 61. I haven't used it but marked it one day. I'm assuming your wanting to make local distb list? Not in AD.
 

1 more replies
Relevance 64.37%

Hi,
I send multiple emails all with the same information in the subject field. No, I'm not spamming. I'm sending order confirmations. I would like to set up one of the function keys on my keyboard to automatically populate the Subject fields.

Example:
Open a new email
Curser is in the Subject field
Automaticlly populate "THank-you for your Order"

I found a section for Macros in the Tool bar but am clueless. ANy help would be much apprecaited. THanks!

PS: running MiccroSoft Outlook 2000 and Windows XP
 

More replies
Relevance 64.37%

I have created an evaluation in MS Word and would like to include a checkbox at the end of the evaluation in which once clicked on (using a macro), the form is sent via outlook as an attachment to a specific email address. I have looked through tons of macros and VB scripts but cannot come up with exactly what I am looking for. I'm pretty sure this is an easy code to come up with, but I am not that strong in using VB. If anyone can help, please let me know!!!
 

More replies
Relevance 63.96%

Hi there!

So I've found the code below here: http://www.google.com/support/forum/p/Calendar/thread?tid=5e4909ca64cffe90&hl=en - Full credit goes to user 'tpuiatti'

Code:
Sub Generate_ICS()
Dim rng1 As Range, X, i As Long, v As Long
Dim objFSO, objFile
Dim FilePath As String
FilePath = "G:\Service.ics"
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFile = objFSO.CreateTextFile(FilePath)
Set rng1 = Range([a5], Cells(Rows.Count, "H").End(xlUp))
X = rng1

objFile.write "BEGIN:VCALENDAR" & vbCrLf
For i = 1 To UBound(X, 1)
objFile.write "BEGIN:VEVENT" & vbCrLf & "DTSTART:" & Format(X(i, 2), "yyyymmdd") & vbCrLf & "DTEND:" & Format(X(i, 2), "yyyymmdd") & vbCrLf & "RRULE:FREQ=YEARLY" & _
vbCrLf & "SUMMARY:" & X(i, 1) & vbCrLf & "END:VEVENT" & vbCrLf
Next i
objFile.write "END:VCALENDAR"
End Sub

This code takes the info from 2 columns in Excel: A which is the event title and B which is the event date. Then it export these informations to an .ics file which will add the event dates to the Oulook Calendar.

The macro and the .ics work perfectly, however i wan't to make a few changes/additions to fit my needs. Additionally I wan't this macro to:

- Pick up dates from column &... Read more

Answer:Additional code to Excel macro - export to Outlook

7 more replies
Relevance 63.96%

Hi, I am looking for a macro to import contacts from excel. We are a team of 25 who all use the same contact list (which contains addresses, organisation name, tel numbers, emails, contact names etc for approx 600 organisations). We regularly have to bcc all these contacts in emails. We previously all held the distribution lists (sorted alphabetically by email) and had to let the rest of the team know when details changed. The problem with this was that the distribution lists do not hold all the information needed (e.g. addresses, organisation names) and contact information was not always updated as it should have been. I would like to create the macro for all the team so that they can periodicaly update their contacts. I trust this makes sense
Thanks
Moved to Business Applications.
 

More replies
Relevance 63.96%

Hi there,

I have to prepare several daily emails which are prepared using a range of data (for example B3122) from Excel 2003 and then have to be sent using Outlook 2003. Unfortunately, due to various management requirements I am unable to merely attach the Excel file as an attachment or paste the Excel data into the email as a straight paste - I have to paste as Unformatted text and then manually change various lines of the email to Bold and Underlined text.
I am trying to write a macro that will do this automatically but am unable to get the Excel data pasted into Outlook (as unformatted text or otherwise). I am assuming that for the font changes to bold I will have to use a Find function in the macro.

The code that I have got so far is as follows:

Range("B3122").Select
selection.Copy

Dim olApp As Object, olMail As Object
Set olApp = CreateObject("Outlook.Application")

Set olMail = olApp.CreateItem(0)
olMail.To = "[email protected]"
olMail.Subject = Range("B3")
olMail.Display

I am new to VBA and so I may be missing a really obvious solution but after trawling the net I have been unable to find an answer.

Many thanks to anyone that can help and make my work a lot less tedious!
 

More replies
Relevance 63.96%

Good Morning,

I have very limited knowledge when it comes to Macros and VBA.

What I need is one of two possible scenarios.

1. Information from a Training Assignment PivotTable exported to a shared calendar on Outlook.
2. Information from a Training Calendar bulit as a Macro in Excel exported to a shared calendar on Outlook and the ability to update either calendar if new information becomes available.

Don't know which is best using code via VBA or using the Export/Import functions.

Any help is greatly appreciated
 

More replies
Relevance 63.96%

Hello Everyone
I'm a pro atlete (quite iliterate in Biz Apps) that based on previous post (from Zack Baresse and computerman29642) has unsuccessfully tried to set up a code to merge my next year training calendar (xls format) into outlook. I herewith included the code I'm using and the test xls file I'd love to merge. Any help would be really appreciated
Sub ExportAppointmentsToOutlook()
Dim olApp As Outlook.Application
Dim olApt As AppointmentItem
Dim blnCreated As Boolean

'Read the table with appointments:
Dim arrAppt() As Variant, i As Long
arrAppt = Range("A2", Cells(Rows.Count, "E").End(xlUp)).Value
On Error Resume Next
Set olApp = GetObject(, "Outlook.Application")
If olApp Is Nothing Then
Set olApp = CreateObject("Outlook.Application")
blnCreated = True
Err.Clear
Else
blnCreated = False
End If
On Error GoTo 0
'Create the outlook item for the table entries:
'Rows:
' Row 1 = Startdate
' Row 2 = Finishdate
' Row 3 = Subject
' Row 4 = Location
' Row 5 = Body
For i = LBound(arrAppt) To UBound(arrAppt)
Set olApt = olApp.CreateItem(olAppointmentItem)
With olApt

.StartDate = arrAppt(i, 1) + arrAppt(i, 2)
.Finishdate = arrAppt(i, 1) + arrAppt(i, 3)
.Subject = arrAppt(i, 4)
.Location = arrAppt(i, 5)
.Body = arrAppt(i, 6)
.BusyStatus = olBusy
.ReminderMinutesBeforeStart = 5
.ReminderSet = True
.AllDayEvent = True
.Save
End With
Next i

Set olApt = Nothing
Set olApp = Nothing
End Sub... Read more

More replies
Relevance 63.96%

Hi, I have a macro in excel that automatically updates my outlook calender - I use it to keep track of actions/deadlines/etc...

The macro runs beautifully except... whenever I run it it creates duplicates of appointments it has previously made in my outlook calendar. Is there any thing that I can add to the macro below to ensure it doesn't duplicate?

Really appreciate any help on this one. Cheers.
Sub outlookexport()

Dim olApp As Outlook.Application
Dim olApt As AppointmentItem
Dim blnCreated As Boolean

'Read the table with appointments:
Dim arrAppt() As Variant, i As Long
arrAppt = Range("A2", Cells(Rows.Count, "E").End(xlUp)).Value
On Error Resume Next
Set olApp = GetObject(, "Outlook.Application")
If olApp Is Nothing Then
Set olApp = CreateObject("Outlook.Application")
blnCreated = True
Err.Clear
Else
blnCreated = False
End If
On Error GoTo 0

'Create the outlook item for the table entries:
'Rows:
' Row 1 = date
' Row 2 = starttime
' Row 3 = endtime
' Row 4 = Description
' Row 5 = Location

For i = LBound(arrAppt) To UBound(arrAppt)
Set olApt = olApp.CreateItem(olAppointmentItem)

With olApt
.Start = arrAppt(i, 1) + arrAppt(i, 2)
.End = arrAppt(i, 1) + arrAppt(i, 3)
.Subject = arrAppt(i, 4)
.Location = arrAppt(i, 5)
.Body = "Created by excel tool"
.BusyStatus = olBusy
.ReminderMinutesBeforeStart = 5
.ReminderSet = True
.Save
End With
Next i
Set olApt = Nothing
Set olApp =... Read more

More replies
Relevance 63.55%

I'm working in a ticketing system that requires me to copy and paste emails along with headers and whatnot to tickets. Right now I click "reply" and copy and paste and close the 2 windows. I was wondering if there's a way that copies all the data of an email into the clipboard to save myself a considerable amount of time on a day to day basis.

Answer:Outlook 2010 macro to copy email to clipboard

Copy email to the clipboard with Outlook VBATony

5 more replies
Relevance 63.55%

Hello
First time user of the forum.
I have a situation where I get these emails from [email protected] when somebody pays me for something they bought. I want to autoreply to that email so I made a template with a reply message and set up a rule to reply when that email comes in.

Here is the problem:
When i do this the email gets sent to [email protected]
When I look in outlook it says in the from column [email protected] and when I open the email and hit reply it shows the buyers email address in the to box and not [email protected] and when I look at the properties of the email the buyers email shows up as
From: "[email protected]" <[email protected]>

X-Email-Type-Id: PPX000600

Reply-To: One 506 Media <[email protected]>

If i open the email and select reply it will show [email protected] in the to field.

You think there is any way to prevent that so it goes to the buyer.

It seems to me that if it were possible to open the email and then auto reply it would go to the buyer and then close the email again.

Would it be possible to do with a macro so that when an email comes in it will run the macro, open the email, reply and then close the email ?

Regards
 

More replies
Relevance 63.55%

G'Day everyone,

Firstly, thank you for this super-awesome website. I can spend my whole day trawling through the gems here which make my life so much more easier!!

I have a question:

I am trying to write an Outlook 2007 Macro which has me a bit stumped.

We get a system generated email which tells us which staff is late for which department. The Managers then send an email to their departments only extracting the info from this email.

I have a rule currently set up which dumps this daily email to the "Sick and Lates" folder. I then go there everyday at 9:30 am, copy the names of the guys in my department and send an email to the DL.

I am trying to automate this so that whenever a sick and late email arrives, Outlook will pick up the names of the people in my department only, chuck them in a separate email addressed to a specific distribution list and fire away.

I had a look at other posts but am stumped.....help, please?

 

More replies
Relevance 63.55%

Hey everyone,

I was wondering if anybody on these forums could help me with the below task?

I run a backup program that generates email reports to a subfolder in my Outlook 2010 every 6-8 hours to tell me the status of every backup job that I have set up and have running. The email details the job name, the job start time, and the job status (running, completed successfully, failed, missed, cancelled etc).

At the moment, I sift through each and every one of these emails (I have over 100 backup jobs per day) and enter the relevant data manually into my excel spreadsheet. The spreadsheet looks like the following:

Job name Monday 1st Oct Tuesday 2nd Oct Wednesday 3rd Oct Thursday 4th Oct
Job_xxx SUCCESS SUCCESS FAILED FAILED
Job_yyy SUCCESS SUCCESS SUCCESS RUNNING
Job_zzz MISSED MISSED CANCELLED SUCCESS

What I&#8217;d like is to automate this process, so that each day, perhaps every 4 hours, a script would run that would search for certain values within each email I receive and update the excel sheet accordingly.

Example:

- Monday 1st Oct, 10am &#8211; email comes into inbox with subject/body containing &#8220;Job_xxx has started &#8220; >>>> update Excel sheet to record RUNNING under column &#8216;Monday&#8217; in row titled 'job_xxx'
- Monday 1st Oct, 1pm &#8211; email comes into inbox with subject/body containing &#8220;job_xxx completed successfully&#8221; >>>> update Excel sheet to record SUCCESS, ... Read more

More replies
Relevance 63.55%

Ok, just a bit of advice needed on this one for the time being...
I need a macro that will:

- Save all (Excel) attachments from the currently open email message (or a message selected in the Inbox) to a directory on the PC.

- Merge all the saved Excel files into a single file - they're all formated exactly the same - data in about 20 columns, no column headers or anything, just standardised data.

- Save the merged file with a standard name (i.e. every time this is ran, it needs to have the exact same filename).

- Delete all the files in the directory apart from the merged file.

I know there's probably a fair bit of code online for doing the individual parts of this. Can I do both from within Outlook? It doesn't particularly matter if I need to do this in 2 steps - an Outlook macro to save the attachements, and an Excel macro to do the file merge etc.

Cheers.
 

Answer:Solved: MS Outlook / Excel macro - extract attachments and merge

16 more replies
Relevance 62.73%

Hi,

We have a spreadsheet that keeps track of when our computer warranties expire. Would like to run a macro using the warranty expired date to create an appointment in Outlook. That part I understand. The problem is that when I go to run the macro again, it creates a duplicate appointment if the appointment already existed. Very frustrating!

This is the code below, any help would be appreciated!!!! Thanks
Sub AddToOutlook()
Dim o As Outlook.Application
Dim ai As Outlook.AppointmentItem
Dim r&, sSubject$, sBody$, dStartTime As Date, dDuration#

For r = 4 To 10

sSubject = Sheet1.Cells(r, 1).Value
sBody = Sheet1.Cells(r, 4).Value
dStartTime = Sheet1.Cells(r, 3).Value
dDuration = 30
Set o = GetObject(, "Outlook.Application")
Set ai = o.CreateItem(olAppointmentItem)
ai.Body = "Service Tag= " & sBody
ai.Subject = "Warranty Expires for Server " & sSubject
ai.Start = dStartTime
ai.Duration = dDuration
ai.Close olSave

Next r
End Sub
 

Answer:Solved: Excel Macro to Update Outlook Calendar Creates Duplicates

6 more replies
Relevance 62.73%

Good Afternoon,

I'm quite stuck trying to fix my code. I've scoured the internet looking for similar questions, but to no avail. I am trying to have excel create appointments in the outlook calendar and be able to run the macro multiple times without have duplicate appointments.

I could run my macro and create an appointment, which worked fine, but there was no routine to check if the appointment already existed. So I would have multiple appointment alerts for the same appointment if I ran the macro more than once. (If I were to add something and run the macro again to keep everything up to date).

So I tried to add a loop checking first the date of the appointment then the title (subject). However, now, I am getting the "Object doesn't support this property or method" error when I run the following code.

If anyone could help me with what the error refers to specifically in my code or any code I need to add or take out to make my loop work I would really appreciate it. Thank you very much in advance.
Code:

Sub ExportAppointmentsToOutlook()
Dim olApp As Outlook.Application
Dim olApt As AppointmentItem
Dim blnCreated As Boolean

Dim olCalendarFolder As Outlook.MAPIFolder 'use MAPI to loop through folder
Dim olMessage As Object 'items in calendar/inbox are messages
Dim olInboxMessages As Object
Dim olAppSession As Outlook.Namespace
Dim strSubject As String
Dim myDate As Date

Applic... Read more

More replies
Relevance 62.73%

I am currently trying to create appointments in a calender i have created in outlook using information from an excel spreadsheet. I have copied several codes from other forums to help with this Macro but have only been able to add the appointments to my calender.

The code i am currently using is:

Sub ExportAppointmentsToOutlook()
Dim olApp As Outlook.Application
Dim olApt As AppointmentItem
Dim blnCreated As Boolean

'Read the table with appointments:
Dim arrAppt() As Variant, i As Long
arrAppt = Range("A2", Cells(Rows.Count, "E").End(xlUp)).Value
On Error Resume Next
Set olApp = GetObject(, "Outlook.Application")
If olApp Is Nothing Then
Set olApp = CreateObject("Outlook.Application")
blnCreated = True
Err.Clear
Else
blnCreated = False
End If
On Error GoTo 0
'Create the outlook item for the table entries:
'Rows:
' Row 1 = date
' Row 2 = starttime
' Row 3 = endtime
' Row 4 = Description
' Row 5 = Location
For i = LBound(arrAppt) To UBound(arrAppt)
Set olApt = olApp.CreateItem(olAppointmentItem)
With olApt
.Start = arrAppt(i, 1) + arrAppt(i, 2)
.End = arrAppt(i, 1) + arrAppt(i, 3)
.Subject = arrAppt(i, 4)
.Location = arrAppt(i, 5)
.Body = "Created by excel tool"
.BusyStatus = olBusy
.ReminderMinutesBeforeStart = 5
.ReminderSet = True
.Save
End With
Next i

Set olApt = Nothing
Set olApp = Nothing
End Sub
I also have the calender location but have no idea where it would need to fit into... Read more

Answer:Macro/VBE to create appointments in Outlook from an Excel Spreadsheet (Office 2003)

16 more replies
Relevance 62.32%

Dear All,

I am using Outlook 2003 and receive many emails a day with huge attachments, you all know what that means.
I am looking for a macro that I can run on a specific inbox folder to store all attachements of that email inbox subfolder into folders on my harddisk. But the macro should create subfolders with the senders names so that I can easily find the attachments and asign them to emails. The makro should also add a comment to the email that the attachement has been stored on a certain date to the HD.

Does naybody have an idea how to solve this ?

Thanks
Andie
 

More replies
Relevance 62.32%

dear all
i need a macro to list out the email that received today n to show they are responded or not
thnks
mv
 

More replies
Relevance 62.32%

Hi all... I just joined this forum as past threads have been of great assistance... But now I have a immediate issue... I have wrote some code to pull info from a Excel report and create an Outlook appointment base on various commitment dates... This report is sent out daily therefore the macro is used daily... An issue that has risen is that everytime the macro is ran it creates duplicate appoinments which quickly bogg down the server... I saw an example on a closed thread and could not quite figure it out... Can anyone assist??? I am running 2003 versions of both Excel and Outlook and my code is as follow and thanks...

Sub ExceltoOutlookCommitDateSmithRenewalReport()
'
' ExceltoOutlookCommitDate Macro
' Load Excel Commit Dates into Outlook
'
' Keyboard Shortcut: Ctrl+o
'
' Create the Outlook session
Set myOutlook = CreateObject("Outlook.Application")

If MsgBox(prompt:="OK if YES / CANCEL if NO", _
Buttons:=vbOKCancel + vbQuestion, Title:="HAS PAA BEEN FILTERED?") = vbOK Then
MsgBox "MACRO WILL NOW UPDATE OUTLOOK CALENDAR WITH PROCLAIM COMMIT DATES."

Cells.Select
Selection.Copy
Workbooks.Add
Cells.Select
ActiveSheet.Paste

' Start at row 5
r = 5
Do Until Trim(Cells(r, 1).Value) = ""
If (Cells(r, 20).Value) = "" Then
' Create the AppointmentItem
Set myApt = myOutlook.createitem(1)
' Set the appointment properties
myApt.Subject = Cells(r, 2).Value
If (Cells(r, 5).Va... Read more

Answer:2003 Excel to Outlook Calendar appoinment VB macro creates duplicates appointments

Hi jayJay,

I'm not going to look through the whole code but what I think happens is that sinec you run the macro every time it will just add an appoitment, I think an options should be added, something like an extra column namen DONE and when the macro is run the cell in the column DONE should be given a value True() or a 1 to indicate it as done, so that when you run the macro again the column DONE cells where the valkue is not True() or is not 1 (dependign on waht you choose) is carried out.
This way you will avoid duplication.
Just an idea, happy coding.
 

1 more replies
Relevance 62.32%

Hi,

I need help with a macro. So far the macro is operating as it should , creating MS Outlook 2010 calendar appointments using data from an excel data spreadsheet (data base). The issue I&#8217;m having is that every time the macro is run for a new entry, duplicate calendar appointments are created for the already existing data in the data base. I would like to have the macro do a search to ensure an appointment does not exist before creating one. I have read a few threads with similar problems but have had major issues incorporating the solutions to resolve the issue I&#8217;m having.

I have attached the macro in txt. format for reference.

Thanks for your help.

kkfonty
 

Answer:Solved: Excel macro updating Outlook calendar is creating duplicate appointments.

Hi
You can use this function to check if an appointment exists based on the Start Day/Time

Code:

Public Function CheckAppointment(ByVal argCheckDate As Date) As Boolean

Dim oApp As Outlook.Application
Dim oNameSpace As Outlook.Namespace
Dim oApptItem As Outlook.AppointmentItem
Dim oFolder As Outlook.MAPIFolder
Dim oMeetingoApptItem As Outlook.MeetingItem
Dim oObject As Object

On Error Resume Next
' check if Outlook is running
Set oApp = GetObject("Outlook.Application")
If Err <> 0 Then
'if not running, start it
Set oApp = CreateObject("Outlook.Application")
End If

Set oNameSpace = oApp.GetNamespace("MAPI")
Set oFolder = oNameSpace.GetDefaultFolder(olFolderCalendar)

CheckAppointment = False
For Each oObject In oFolder.Items
If oObject.Class = olAppointment Then
Set oApptItem = oObject
If oApptItem.Start = argCheckDate Then
CheckAppointment = True
End If
End If
Next oObject

Set oApp = Nothing
Set oNameSpace = Nothing
Set oApptItem = Nothing
Set oFolder = Nothing
Set oObject = Nothing

End Function

For this to work you need to have Tools/References/Microsoft Outlook xx Object Library enabled.
Then alter your macro like this

Code:

Private Sub cmdOutApt_Click()
' Create the Outlook session
Set myOutlook = CreateObject("Outlook.Application")
' Start at row 2
r = 2
Do Until Trim(Cells(r, 1).Value) = "&q... Read more

2 more replies
Relevance 59.04%

I am using the MSN Stock Quote addin with MS Excel 2003. Prior knowledge of this should not be necessary, but I just thought I'd provide full context to my issue. I wrote a macro that essentially records daily stock prices. Because I don't want to store old quotes into perpetuity, i need to ensure that the update quotes button has been hit. I use sendkey() to accomplish this, and then the macro copies the quotes and pastes them elsewhere. My main goal is to have the task scheduler open this file daily so i dont ever have to think about this again, and i'm so close. Essentially my problem is that it takes a few seconds after the update button is hit for the add-in to fetch the new prices from the internet, and this process appears to be delayed until the macro is finished. This is a problem because the macro ends up recording un-updated quotes. I have tried the Application.Wait procedure, and I've tried time consuming loops, do while loops, etc. All of these approaches result in the same thing: Can someone please help me with this? I'm too lazy to hand update this spreadsheet every trading day for the rest of my life (or until i quit). Thank you in advance!
 

Answer:Excel Macro - Allow cells to update query before macro completes

Can't you just put the update macro code in a module of it's own and call it from the main macro?

Regards,
Rollin
 

1 more replies
Relevance 57.81%

hello all,

I'm kinda new at the more advanced features of Excel, so bear with me.

I'm using a pretty basic spread sheet with about 7 columns. One column contains various expiry dates, some dates are two years from now while others are in 6 months.

I was wondering if it is possible to create an alert that would generate an email when the date in the Expiry column reaches 30 days before the date.

Is there a somewhat simple solution? Or do I have to write some code?

Thanks in advance
 

Answer:Email Alerts from Excel to MS Outlook

You will need some VBA code to accomplish what you want. The code is not hard to write but you will need to select an event that will fire the code. In most situations like this the code would be triggered by the Workbook_Open event. This essentially means that the code would fired immediately when the spreadsheet is first opened. The only problem with this is that the code won't fire unless the workbook is physically opened. Is this a problem or do you need a script to automatically open the workbook and check the dates automatically?

Regards,
Rollin
 

2 more replies
Relevance 57.81%

I have a worksheet that I'm working on for work. It shows a list of trucks with different insurances and expiration dates. I'm far from savvy using excel and I need help creating a code that will alert myself and one other person if a trucks insurance is about to expire.
 

Answer:Sending an email with outlook through excel

Hi there, welcome to the board!

So, this is a loaded question. Let's first get all the information out on the table, then we'll be able to give you directions on how to best solve this.

See if I understand this correctly. You have a spreadsheet. This spreadsheet is located on your desktop computer. In this workbook you have a worksheet which contains data. The data is a list of trucks in some range (not yet specified), difference insurance information (not specified) and their expiration dates (in a range not yet specified). So from this we don't know the workbook name, worksheet name, data range where this data lies, nor a sample of the data housed in this mysterious range. In not trying to go overboard, can you please give us some specifics about this missing information?

Once we know the above information we'll know where we're starting from. This is only half the equation. The other half is what you actually want done. Also, this second part is easier if you fully define the first part. In other words, to properly describe an end point (e.g. solution) it's best to have a well documented/defined starting point (e.g. problem).

Let's say, for arguments sake (since we're not very well defined at the moment), that what you're looking for in a solution is to notify you + 1 other in the event of these expiration dates coming close to the current system date. Some questions I would ask is:

When should this list of expiration dat... Read more

1 more replies
Relevance 57.81%

Hello there,

I am pretty new to excel overall and facing a problem currently by setting up an automated process sending emails via Excel to Outlook.

*What*: I need to send out multiple cell values (which are calculated by formulas) on a weekly basis to 25 people.

Is there any (easy) automated process I could use? I've read online about using macros, but I am quite unfamiliar with that process.

I appreciate your help with this!

Thank you and best,

Regina
 

More replies
Relevance 57.81%

Hi ,

I am using outlook 2013. I want to copy mails from particular person to excel sheet automatically when it comes to inbox. I am using Excel 2013.

Can you help me to achieve this?

Thanks in advance.


Sathya.

Answer:Move Outlook email to Excel

Use a macro to copy data in Outlook email to Excel workbook

1 more replies
Relevance 57.81%

I need to set up a spreadsheet for loaning out products, but what I want is for Excel to email me or alternatively put an entry in my Outlook Calendar when the product is due to be returned. I have attached a simple example.

What I would like is to have either a Calendar entry that says XYZ is due back from Joe Bloggs today or an email sent on the due date to remind me.

Any ideas would be welcomed
 

Answer:Excel to outlook calendar or email

Panmanz said:

I need to set up a spreadsheet for loaning out products, but what I want is for Excel to email me or alternatively put an entry in my Outlook Calendar when the product is due to be returned. I have attached a simple example.

What I would like is to have either a Calendar entry that says XYZ is due back from Joe Bloggs today or an email sent on the due date to remind me.

Any ideas would be welcomedClick to expand...

This may be an alternative...I don't have Outlook, so I couldn't test this. You can assign due dates to tasks, so this may work for you- hope this helps.

This is from Microsoft Help-

Create an Outlook task for a workbook

These steps allow you to create a task for yourself. If you want to e-mail a task to someone else, use Microsoft Outlook rather than Microsoft Excel. For more information, see Outlook Help.

Open the workbook for which you want to add the task.

On the Reviewing toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, click Customize on the Tools menu, and then click the Toolbars tab.), click Create Microsoft Outlook Task .

On the Task tab, enter the subject, dates, status, priority, and reminder for the task.

For more information about task options, see Outlook Help.

Click Save and Close .

Note Once you create the task, you can open it in Outlook. For more information, see Outlook Help.
 

3 more replies
Relevance 57.81%

Good day,

This is my first time posting here.
I'm looking in automatizing my excel VBA to send out emails via Outlook on dates that i set in my excel workbook.

this is what i need this workbook to do.
Automatically run macro 7 days prior to date in column C.
not send email on due date (column c), but 7 days prior to due date.
change Font toArial, size: 10 , color RBG: (89,89,89))
add personal outlook signature at the end of email body.
Any help will be very much appreciated.
 

More replies
Relevance 56.99%

Hello all, I am trying a broader search since the forums I have been posting were specifically EXCEL. Below is the problem i am having and I hope to find someone here with a better understanding of outlook.



HI there, I have been working on this for awhile and although I have gotten help via other methods, none of them seem to work in the manner I would like for it to do so. Other methods include, looping, HTML and formatting the string b4 it is imported into

SO this is what I have done, I have taken recorder in outlook and supplied the body of the email with data seperated by commas. Then i recorded the next steps with recorder selected the tools and then tables within outlook. I am trying to make it where excel can control this code that I recorded in outlook. I assume i have to define an object or something but i am missing a step. anyone have any thoughts? thanks so very much in advance.

Ooops, also the code for creating the email was created by someone else, and I have been using it for years for converting a range into HTML and plascing in body of emails...but now, I cant use html


Code:

Sub email()


Dim TodayFile
Dim FileDate

'Sends a specified range to a Outlook message and retains Excel formatting

'References needed :
'Microsoft Outlook Object Library := msoutl9olb
'Microsoft Scripting Runtime := SCRRUN.DLL

'Dimension variables
'// ie. if Ol not installed then we need to Late bind & define as Obj
'// Use Late binding > Outlook.Appli... Read more

More replies
Relevance 56.99%

When someone sends me an email excel attachment and I open it, it does not automatically load to Excel, it says it cannot find the file (excel does open). However, I can save it and go to excel and find it that way. Also, if I go to my recent documents and click on an excel file, it says it cannot find the file either. However, once again if I go to excel and open the file there, it finds it. This has just started happening, but effects all files.
I have rebooted and run disk check. Anyone else have any ideas. Thank you in advance.
 

Answer:Outlook email problem with excel file

12 more replies
Relevance 56.99%

Hello,

I am trying to write a code for this workbook that will generate an email to my outlook account when the file is modified in anyway. I am not sure why my code is not working and welcome any assistance!

Additionally, it would actually be nice if the code were setup so that the email contained the information in columns B-F and was only generated when one of these columns is edited.

Thanks in advance!!

Ps. I tried to upload the file from my computer, but am getting a message that I am either not logged in/do not have access.
 

Answer:Solved: excel email to outlook code help

15 more replies
Relevance 56.99%

Hi Rollin,
Appreciate your help in this area of my project. I am new to this interface; have tried this vba script from your website and I managed to import the contacts and create the distribution list. In the Outlook address book; I notice I have duplicate record of the same contact e.g. Fitz Bob (email address) and Fitz Bob (Business Fax). During the creation of the Distribution List my Outlook display the email address on the Name and Email columns.
My objective is using the excel worksheet to import the contacts into the distribution list in Outlook.
Appreciate if you can let me know where my mistake is.
Thanks,
learner123

*** I have attached Excel worksheet file with vba macro script in it.
 

More replies
Relevance 56.99%

Hi all,

I am looking for help on VB script to send automated emails based on the dated column in excel sheet..
I need to send reminders to the email addresses in Column J & K to remind them that the vehicle registration in Column B is due an MOT on the date in Column M, also to send a reminder that the Tax is due on the date in Column P. these emails need to be sent 14 days before the due dates.
I also require Column N & Q to generate at date and time when the reminder was sent.
I would much appreciate any help with this as I am completely new to VB script, I have attached the file to aid in any help
 

Answer:Sending Email reminders from excel to outlook using VBA

11 more replies
Relevance 56.99%

Dear Friends,I work for a software/hardware distributor company. I have a raw data of my customers in excel sheet with their phone numbers and email ids in seperate coloumns.I want to extract only email ids and put to word or in my outlook (in BCC group) to inform them about a promotion going on in my company.Please help me to save my time and energy in copying and pasting email ids once at a time.Your help and guidance will be highly apprecited :)Raz

Answer:copy email ids from excel to word or outlook

coolraz, seems to me you just need to create a csv file to create a list. Perhaps a list in your mail handler would be even easier for your purposes? You can edit a list to add, subtract members and send the same promo to each member of the list, Use BCC to send the mail and none of the others in the list appear.Creating the original list may involve C/P, dunno. Are they currently in your address book? If so, you can simply click on them to put them into a list.HTH.Ed in Texas.

2 more replies
Relevance 56.99%

Excel not opening an attached in Outlook email

Here is a good one. I have an external hard drive hooked up via USB that I use as a backup.

Recently I can not open an attachment in excel that is attached in an email. If it does, it is a web page. If I save to the external hard drive and try to open it through Win Explorer I can?t.

However if I launch Excel, then do the open command and try that newly saved file it on external hard drive, it opens.

Anyone? What?s up?
 

Answer:Excel not opening an attached in Outlook email

file may contain a macro or virus. It might be protected, it also might be corrupted. Do you know the sender or creator?

Are your file associations good in your registry. Run CC cleaner registry repair.
 

2 more replies
Relevance 56.99%

I use Outlook Express 6.0 I receive emails in a fixed format & that format is:

===========================================================================
A new inquiry from Website has been posted
===========================================================================
Name :___________
E-mail :___________
Phone No :___________
Mobile No :___________
City :____________
Other :___________
===========================================================================
This mail should be responded within 48 hours
===========================================================================

Now I want to convert all these emails to MS Excel(2002) so that I can have all these fields in different colums. Is this possible? Can somebody help?
 

Answer:How to Convert MS Outlook Email data to MS Excel

16 more replies