Computer Support Forum

Solved: Send an automated email (outlook) from Excel spreadsheet dependent upon comle

Question: Solved: Send an automated email (outlook) from Excel spreadsheet dependent upon comle

Hi,

Im quite new to this excel programming thing and could really do with some help.

I need to send an automated email to 3 recipients (always the same 3 email addresses) when a number (formatted from a countdown of days to go) is 10 or less. Also i need a different automated email to be sent when a date is manually entered into a different cell.

I have managed to get the current date and time on my spreadsheet and used the format to work out the days to go to the deadline.

I have looked over all different types of forums but unfortunately because i'm still very green when it comes to excel i get lost and confused when trying to do this.

Is there anyone out there who can treat me as an alien and help me through this step by step.???

Relevance 100%
Preferred Solution: Solved: Send an automated email (outlook) from Excel spreadsheet dependent upon comle

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

Answer: Solved: Send an automated email (outlook) from Excel spreadsheet dependent upon comle

10 more replies
Relevance 76.56%

Hi,
I am a summer student for a concrete company and I am responsible for keeping all of our MSDS up to date. I have a spreadsheet set up to summarize it and that includes expiration dates. Currently the dates change color when it is within 30 days of expiration and to red when it has passed the expiration date. My problem is I have other jobs to do at the same time and don't check the sheet daily. Is there a way I can have Excel email my outlook account when the msds hits 30 days before the expiry?

P.S. I'm running excel 2010
 

More replies
Relevance 100.04%

Hey everyone,

I'm trying to stretch my resources and minimize some data entry, using the tools at hand. However, I've hit a bit of a wall on inspiration - looking for some ideas.

I have an Excel Spreadsheet (about 8 worksheets) that I use to log some daily activities - however, because I have a lousy memory, I like to email myself from the road with the notes for my Log. Then, when I return to the office, I either re-type (or copy/paste) my email notes into the appropriate sections of my log file.

What I'd LIKE to do is create a form and rule in Outlook that would auto-fill my Excel worksheets based on the text of my email. I'm not worried about Triggers (the rules setup on that end is simple enough for me), I'm more looking for the best way to have Outlook interact with Excel in this way.

I send emails from the road on my Android phone.

Any ideas? Thanks!
 

Answer:Solved: Outlook Email to Auto-Fill Excel spreadsheet

8 more replies
Relevance 90.2%

whenever I try to send a spreadsheet using th "send to > mail recipient" excel freezes up?
 

Answer:Solved: Excel freezes up when trying to send a spreadsheet

How about other programs? Does Word do the same thing? What is your email client? Do you have any add-ins installed? Try opening Excel in safe mode (using the switch "/safe" from the run prompt: hit the flying windows button, click Run, type "excel.exe /safe") and trying it.
 

1 more replies
Relevance 88.97%

Hi Forum,

I'm having a problem piecing together the various bits of VBA I've been finding on the internet in to something I am able to use on a worksheet laid out as follows:

Column A: Date
Column B: Item Description
Column C: Item #
Column C: Customer
Column D: Customer Email address (each cell contains multiple email addresses)

What I would like to do is have the VBA search Column A for any date greater then 6 months in the past from Today, then forward an email to the address in Column D.
The body of the email would need to contain information from Column B and Column C.

Potential problems:
I need an attachment to the email as well.
Customer ABC may be listed several times (once for each item they purchase) and I would like the email to only be sent once (with all the items) versus many times (once for each item that they purchase).
Would like to bcc the sales team and cc the operations team on the emails that go out. Those email addresses would be static - the "To" part would need to change based on the customer.

I've gone to Ron DeBruin's site but ran in to some problems with the codes that I was trying to change to meet my requirements - so I tried downloading the add in and unfortunately, I am unable to do so from work.

Can anyone help or am I doomed to sorting manually?

Thank you in advance!
 

Answer:Solved: Excel - VBA Automated Email

12 more replies
Relevance 88.56%

I have searched the net but cannot find anything specifically what I'm trying to accomplish.

I have a timesheet, of sorts, that I added buttons to move around and I would like to add a button for the user to click and it will send the Excel spreadsheet to me when they're done entering their data. I can get the email to open a new email message with the file attached but I'm stuck on getting my name in the To field, as well as a subject and body. Then I would like for it to send and display a message that the email was sent.

I am using Office 2003

Any help would be appreciated.
 

Answer:Solved: Macro to Send Email with Spreadsheet as attachment

7 more replies
Relevance 87.74%

Good Day,

I would like assistance in creating a code that will generate a automated email to specified receipients when a date is entered into a specific cell. I have attached a sample spreadsheet. When a "date" is added in column M, it automatically generates a email to specific recepients notifying the receipients that the specific unit number in column A has been completed.

For Example:

Good Day,

This is to notify you that unit *** (from colum A) is complete and ready for your team.

Thank You,

xxxx

Thank you very much for the assistance!
 

Answer:Solved: Sending a Automated Email Through Excel

8 more replies
Relevance 87.74%

Hello. I need help finding a solution to a specific problem I'm facing. I need to import data automatically from an Excel spreadsheet into a web-based form multiple times (over 300 times in fact) The data is neatly organized in the spreadsheet and each field in the web form directly correlates to a column in the spreadsheet. So I don't think this should be too terribly difficult to accomplish. The only problem is that in addition to text fields, the form also features drop down menus. But like i said, there is data in the spreadsheet that directly correlates to a selection in the drop down menu.

So, to put if briefly the following needs to happen:
1. The data is input from the spreadsheet to the web form.
2. A button needs to be clicked to submit the form.
3. A link needs to be clicked to bring the form up again.

This needs to be repeated until all the data is entered.

I think I've covered everything. I hope I've made it as clear as possible. Thanks a lot for your help! This would be saving me hours upon hours of work.
 

Answer:Automated web form data entry from Excel spreadsheet?

You could write an AutoHotkey script to do that. You would need to:

Activate the Excel spreadsheet window. (WinActivate)
Go to a particular cell in the spreadsheet. (Send tabs)
Copy the data. (Send Ctrl-C)
Activate the browser window. (WinActivate)
Go to a particular box in the web form. (MouseMove)
Paste the data. (Send Ctrl-V)

Then put all of that into a loop to run as many times as the number of cells to be copied. (Loop)

Submit the form. (MouseClick)
Bring up a new form. (MouseClick)

Then put all of that into a loop to run 300 times. (Loop)

The terms in the parenthesis like "WinActivate" and "MouseClick" are the actual AutoHotkey commands you would use.
 

2 more replies
Relevance 82%

I am attaching this excel sheet which has codes on sending email automatically on due date once the file is opened and then closes it as well. However there seems to be a problem as it doesn't send emails automatically and comes up with a error. It would be grateful if someone could correct the codes in the file.
Thank You
 

Answer:Send Email using Excel and Outlook Automatically

7 more replies
Relevance 81.59%

I have a sales report that automatically updates daily. Is there a way to setup automated emails from excel to different individuals? It would save so much time and effort. Any help is appreciated!
 

Answer:How to send automated emails from Excel?

There are quite a few similar threads with sample files and more.
Check these out.
There are two I helped with, one on October 13 was asked by vasu0505 and one from June 22 placed by truec
Search for posts by these posters and you'll come across them,

With the information you have given (Excel version missing) and no data explaining it's an open guess and guessing is no option

When you open this post similar threads are displayed below so you can directly click them.
Happy hunting
 

1 more replies
Relevance 81.18%

I created an excel workbook and would like to have excel automatically send me a reminder to my Outlook email when certain due dates are coming up.

Is this possible? I tried playing around with Macros but I'm not good at it. Any assistance is greatly appreciated.

respectfully,
Edward
 

Answer:How to make Excel send email alerts to Outlook

7 more replies
Relevance 81.18%

Hello,

I am trying to figure out how to get MS Excel to send a few cells of data to an email address. We are a fire department whose dispatch is using an excel spreadsheet as the dispatch log. The goal is for the data to be entered into a few cells. Column H1 would ask to "send page". If 'Y' is put into the cell then an email automatically be with the data in this format:

c1 d1 e1 f1 g1
type;location;street address;details;report #
The email pushes an alert to responders smart phones through an ap.

Thanks!
 

Answer:Need to send some cell data from Excel to Outlook Email

7 more replies
Relevance 81.18%

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

Hi All,

I am new to VBA and although there are many links in the forum regarding the topics of using Excel to send Email reminders to Outlook, my requirement requires an additional option which i do not know how to program to make it work. I hope I can be assisted.

I am currently using Outlook & Excel 2010, Windows 7.

Using the attached test example, I have created a spreadsheet which is used daily. It requires a reminder email to be automatically sent out ONLY if the following is triggered.

Row H (Send Reminder) must show YES, then it will only send on the date shown on Row G (Due Date). However, if Row H shows NO, it will not send even though Row G has Due Dates.

The body of the reminder message would say:

Subject: Reminder

The project assigned to you under reference number, "cell D3" in the name of "from cell E3" for the confirmation date of "from cell N3" is now G3 - C3 days old.

If this has been completed, please ignore.
 

More replies
Relevance 80.36%

Hi I would like to get VBA/macro codes to send an automated email to the email IDS mentioned in the file when the invoice due date is less than 2 days of current date. please help me
 

Answer:Excel 2016 to send Outlook email reminders on various dates

Here's a similar thread on the forum. If you can follow the code, then you can adapt it to suit your needs.
 

1 more replies
Relevance 80.36%

Hi,

I need to send an email notification(To Outlook Inbox) to specific users that, the excel/Access database has been updated and saved by an user with his name.

This notification should be sent everyday at a specific time.

Can anybody help me out in achieving this using macros or by any means.?

Thanks in advance!!!

Regards,
Krishna
 

Answer:Send email notification from Excel/Access Database to Outlook

Have you looked at the "sendObject" method?

DoCmd.SendObject , , , "YourEMAIL", , , "TEST"

Leave the Object name /format blank and you can send without attachement, you can do with a macro or VBA....this is from Access only, if you need Excel let me know, it is different.

Not clear on how you want to trigger, because essentially the UPDATE, should be the trigger, but you mention same time everyday...that may not be relevant because what ever action does the update maybe able to trigger the send.

I also use this to get around Outlook security...
http://www.contextmagic.com/express-clickyes/pro-version.htm
 

3 more replies
Relevance 80.36%

I'm in HR and I have a spreadsheet that incorporates staff information commencing, with each month in a new sheet. Unfortunately, department managers are forgetting to do staff reviews at 3mth, 5mth or the 6mth probation. I've entered formula to calculate these dates from the staff commencement date.
Now I need to find out if I can have some sort of Macro or VBA coding to email me a reminder to contact the managers a week prior to the the review/probation dates.

Please help! I have no idea with coding/programming etc.
 

Answer:Excel 2016 to send Outlook email reminders on various dates

Try the attached, one thing to note that you had the probation dates in the wrong place

6mth, 3mth and 5mth

so I changed it to 3\5\6

when you open the workbook the macro will run and generate an email IF any dates is below or equal to 7 and above or equal to zero. Meaning that there is a week until the review is required. This code will fail if the review date is in the past, this can be changed to tell you that a review date has been exceeded.
 

1 more replies
Relevance 79.54%

Hi all,

I am looking for help on VB script to send automated emails based on the date column in excel sheet..

Uploading the excel sheet as well. The email should trigger on dates in column F to corresponding email addressed in column E ..

The email body should say :
Hi,

Your employee "Column C" is approaching his probation period on "Col D". Kindly confirm if you want to confirm on the date of "Column D" or modify it.
 

Answer:Need help to send automated email based on the date field

Have a look at the attached I have written the code necessary however if you have any changes you would like made let me know.
 

1 more replies
Relevance 78.72%

I have an Excel Spreadsheet open.

I then click "FILE", "SEND TO", "MAIL RECIPIENT(AS ATTACHMENT)"- an Outlook dialogue box opens with the attachment.

I then choose the recipient from the address book and click send.

This is the normal way of sending a file. HOWEVER, when I look in my sent items, THE EMAIL IS NOT THERE.

The recipient does not recieve the email.

Please assist,

Thanks,

Regards
C Jones
 

Answer:Send Excel Spreadsheet as Attachment

8 more replies
Relevance 77.9%

In the attached xls file, the user would have this file open and would populate all the fields that are marked "User". When a date is entered into Column C, the Status (Column D) changes to "Resolved" and Send Email? (Column D) changes to "Yes".

Here is where I get confused looking at some example vba to send a selection from the worksheet to a specified email address in the same worksheet.

I would like to send the following to the email address in that row:

"Your issue {row A#} regarding UWI {row G#} has come off confidential."

When the email is sent, the Email Status (Column F) changes to Sent. Only rows with a null email status will be processed. This will prevent multuple emails from being sent.

Hope this makes sense.

Mike

PS - All data is just sample data.
 

Answer:Solved: How to send email from Excel

16 more replies
Relevance 77.08%

Hi all,

I have 3 columns in my spreadsheet - customer name, expiry date, and days till expiry

What I would like is for an automated email to be sent once an expiry is 90 days away. Within the body of the email it would include customer name.

Please would someone be able to tell me if this is possible.

Thank you for your time!
 

Answer:Automated Email From Excel

8 more replies
Relevance 77.08%

Hi

I have a problem in my office that two systems are taking long time to send Excel attachments in MS Outlook 2003.
Even a 35 kb of excel attachment takes 2 minutes to send email.

The system I have WIN XP operating system
Symentec Antivirus client 10.1.5

I reinstalled the symentec and outlook 2003 but the problem remains the same
Please help
 

Answer:Symentec email scanner taking long time to send Excel attachments in MS Outlook 2003

You could turn off your email scanner.

Why you don't need your anti-virus to scan your email:

http://thundercloud.net/infoave/tutorials/email-scanning/index.htm
Email scanners can be bypassed:

http://www.virusbtn.com/news/2006/12_11a_virus.xml
 

1 more replies
Relevance 77.08%

Hi

I have a problem in my office that two systems are taking long time to send Excel attachments in MS Outlook 2003.
Even a 35 kb of excel takes 2 minutes to send email.

The system I have WIn XP operating system
Symentec Antivirus client 10.1.5

I reinstalled the symentec and outlook 2003 but the problem remains the same
Please help
 

More replies
Relevance 76.26%

Hi Guys,

I'm new on the forum so wanted to firstly say a quick Hi!!
But I wonder if you can help as I just cant get an issue solved and I'm sure you wizards of the Excel world can help me.
I am trying to get a spreadsheet to send automated email based on a trigger to say If todays date is within 7 days of the due date Then email a list of people in recorded another cell range

I found the following thread which looks really useful but I am getting constant errors when I try to apply the principle to my sheet.
https://forums.techguy.org/threads/...ue-date-reminder-based-on-excel-file.1129238/

I have table which starts in Cell B3.. (Headings in row 2)
Column A is Blank
Column B is Date Raised - this isnt used for anything
Column C is the Topic Of Work
Column D is the Notes from the meeting
Column E is the names of who the topics are assigned to
Column F contains the list of Email address to send that topic to
Column G is the due date (which I want to email out 7 days prior to)
and Column H is where the macro should make that it has sent the emails

The code I have tried is as follows... but I continually get a "Subscript out of range error"
Sub eMail()
Dim lRow As Integer
Dim i As Integer
Dim toDate As Date
Dim toList As String
Dim eSubject As String
Dim eBody As String
With Application
.ScreenUpdating = False
.EnableEvents = False
.DisplayAlerts = False
End With
Sheets(OpenActions).Select
lRow = Cells(Rows.Count, 2).End(xlUp).Row
For i = 3 To lRow
toDate... Read more

More replies
Relevance 76.26%

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 76.26%

Hi Guys,

This is my first post here. I need your help ASAP in developing a mechanism to send an automated outlook mail, 30 days prior to deadline as first reminder and then another reminder at 7 days prior to the deadline. The script should preferably run automatically every time the PC is running. without the excel file necessarily open.

I have searched the forum for similar problems but I am not proficient enough in VBA to modify them to my needs.

In the attached excel file, An email should go to email address (Column D-Some will have more than 1 email entries ), with subject "Task (Column B) is due on Due date(Column C)", and body "Dear Name(Column A), Please complete the task".

Also, the script should put a check mark on Reminder 1 sent column (Column E) (30 days) after the mail is sent, the script should also check if the value of the cell is blank before sending email. The script should put a check mark on Reminder 2 sent column (Column F) (7 days)

I'd really appreciate any help,

Thanks so much!
 

Answer:Automated Email Reminders through Excel

Hi, welcome to the forum.
Have you done a search, there are quite few posts with similar questions and posted solutions, I'm sure your answer is there too.
 

1 more replies
Relevance 76.26%

I have a project planner (excel 2003) and would like the spreadsheet to email (outlook 2003) me when I have an upcoming due date (preferably the day before).

E.g. Due Date 13.03.2013 would induce a reminder today (12.03.2013)

I won't be viewing the sheet daily and would therefore like this to happen even if the sheet isn't open. Is this possible?

The Due Date is listed in a column.

Are these actions possible? If so, how?

Thanks for your help.
 

More replies
Relevance 76.26%

Hi again,

I've read through numerous posts relating to this topic, but I'm having challenges. What I would like is to create a macro that will send an email to defined recipients IF a range of cells have values that meet a certain criteria (either the colour code or the value).

I'll make a button to run the macro manually.

Any help would be appreciated. Perhaps someone can look up a specific post that relates to my question...cause there are so many, I can't find one.

Thanks!

TBaker14

 

Answer:Solved: Excel send email with selected cells

16 more replies
Relevance 75.44%

Hi everybody,

First time poster. I currently have 9 tabs open and hours of researching trying to figure this out. I can say I'm more educated now with excel than I was this morning. Very powerful software.

I seen current thread that were very close to what I need but was unsuccessful with achieving what I needed.

I'm trying to set an email reminder sent to my team when a task has not been completed (Column D) by the due date (Column C) and some indicator on column H when completed. It would be most ideal if the subject had the part number "123453 Rev 06 Doc Control Update" and body said Dear Andy(Task Owner) reminder, please update documentation related to your department. Thanks.

I currently have a macro for 'Task completed' be filled in a green color when complete. I'll copy and paste below what i currently have. I know this is probably a long shot but I am getting somewhat stressed and losing hope with this, please please please help. function is more critical for me then the looks, if i have to move some cells around I don't mind one bit.
Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("D2:D100")) Is Nothing Then
With Target(1, 2)
.Value = Date & " " & Time
.EntireColumn.AutoFit
End With
End If
End Sub

Sub eMail()
Dim lRow As Integer
Dim i As Integer
Dim toDate As Date
Dim... Read more

Answer:Automated email in excel, driven by due date

Code:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count > 1 Then Exit Sub
If Not Intersect(Target, Range("D2:D100")) Is Nothing Then
With Target(1, 2)
.Value = Date & " " & Time
.EntireColumn.AutoFit
End With
End If
End Sub

Sub eMail()
Dim lRow As Integer
Dim i As Integer
Dim toDate As Date
Dim toList As String
Dim eSubject As String
Dim eBody As String
With Application
.ScreenUpdating = False
.EnableEvents = False
.DisplayAlerts = False
End With
Sheets(1).Select
lRow = Cells(Rows.Count, 4).End(xlUp).Row
For i = 2 To lRow
toDate = Replace(Cells(i, 3), ".", "/")
If Left(Cells(i, 5), 4) <> "Mail" And toDate - Date <= 7 Then
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
toList = Cells(i, 4) 'gets the recipient from col G
eSubject = "Document Control Status update "
eBody = "Reminder," "Please update your project status."

On Error Resume Next
With OutMail
.To = toList
.CC = ""
.BCC = ""
.Subject = eSubject
.Body = eBody
.bodyformat = 1
'.Display ' ********* Creates draft emails. Comment this out when you are ready
.Send '********** UN-comment this when you are ready to go live
End With

On ... Read more

1 more replies
Relevance 75.44%

Hello,

I am currently attempting to setup an inventory file in excel to send myself and another colleague anytime an item in that inventory is to expire. I have found a command set from an old comment thread that I have been using as a template but I am not well versed in basic and cannot find where the all of the errors are occurring. So the worksheet utilizes columns a-q, with column Q where the date and time of the sent email will go. I have column A as the item to expire, and column K as the date of expiration.I currently have column p as the location for the email address to be sent but I would rather build the email address into the code since it will only be two email addresses used for the notification. Below is the code that I have been working on but it isn't working for me. Thanks in advance for any and all help.

Sub eMail()
Dim lRow As Integer
Dim i As Integer
Dim toDate As Date
Dim toList As String
Dim eSubject As String
Dim eBody As String

With Application
.ScreenUpdating = False
.EnableEvents = False
.DisplayAlerts = False
End With

Sheets(1).Select
lRow = Cells(Rows.Count, 16).End(xlUp).Row

For i = 2 To lRow
toDate = Replace(Cells(i, 11), ".", "/")
If Left(Cells(i, 17), 16) <> "Mail" And toDate - Date <= 7 Then
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)

eSubject = "Test Article " & Cells(i, 1) & " expires " & Cells(i, 11)
eBody =... Read more

Answer:Automated Email for Expired Inventory in Excel

16 more replies
Relevance 75.44%

Hi Guys,

This is my first post here. I need your help ASAP in developing a mechanism to send an automated outlook mail, 30 days prior to deadline as first reminder and then another reminder at 7 days prior to the deadline. The script should preferably run automatically every time the PC is running. without the excel file necessarily open.

I have searched the forum for similar problems but I am not proficient enough in VBA to modify them to my needs.

In the attached excel file, An email should go to email address (Column D-Some will have more than 1 email entries ), with subject "Task (Column B) is due on Due date(Column C)", and body "Dear Name(Column A), Please complete the task".

Also, the script should put a check mark on Reminder 1 sent column (Column E) (30 days) after the mail is sent, the script should also check if the value of the cell is blank before sending email. The script should put a check mark on Reminder 2 sent column (Column F) (7 days)

I'd really appreciate any help,

Thanks so much!
 

Answer:Please Help ASAP: Automated Email Reminders through Excel

Hi, welcome to the forum.
Have you done a search, there are quite few posts with similar questions and posted solutions, I'm sure your answer is there too.
 

1 more replies
Relevance 75.44%

Hi,

I have multiple Excelsheets where in I use it for day today activites & tracking.
I have attached one of the simple one so that I can know the codes for sending mails & I can do it my self for the rest of the workbooks.

There is a sheet(dash board) where in all the details get updated.
When there are any changes to the value in column F, a mail should automatically sent to me giving the detials of the row. The file will be always live in the server.

I am very poor in coding & I need someone to help me in doing this.

Thanks in advance.
Rgds
Ganesh Hassan
 

Answer:Solved: Automatically send email from Excel based on the conditions

8 more replies
Relevance 74.62%

hi
we are having problem with outlook nowadays. we cant send emails among us in the office. we can send and receive emails from outside of the office but we cant comunicate in the office. and when we do test acount settings everything looks fine (it ticked all of them) but i dont receive test email. we have some other users ,with same domain name, they can send from the other office. it looks the problem is related with ISP but we didnt have this problem till last friday. we didnt change any settings and we turn off all firewalls. still got the same problem I installed Mozilla Thunderbird and it works fine with it. what is wrong with outlook
any idea?
 

Answer:Solved: cant send email with outlook

Have you checked with your ISP tech support? If they have started blocking ports to reduce spam, etc. then you should have been notified that you needed to make a change in your email account settings. Check with your ISP first.
 

2 more replies
Relevance 74.62%

Hello Everyone,

Let me tell you about myself, I am Rajesh, working in a private organisation. I am doing my MCA post graduation. I have to do a repeated task everyday in my office, that sending an excel sheet to all my team members in TO field and two members in CC field. I use Outlook 2007 and Excel 2007. I searched the forum for similar threads they exist I think, but I couldn't get what I need. Let me explain you all what I am going to do everyday

There is a network drive in which I need to take list of sub folders available in four different folders and create four text files and I need import it in a single Excel sheet, after completing this the excel sheet must be saved as "<DD MMM YY> Archive" (Current date, month and year) and emailed to 9 team members(TO field) and 2 members(CC field). It is not necessary to create a new excel file everyday, just overwrite it with previous one.

I have found how to get data automated to excel from a network drive, that is I use batch file that runs commands to get the text files using a VBS(windows scheduler).And then get the data by using Import Data from Text option in excel, But I don't know how to make automated emailing as easy as possible with current date, month, year in excel sheet name.
I hope I am clear in my question, please ask me If I need to provide more information. Any help would be appreciated.

And I found this forum by googling for the above task, I read many posts and seen here member... Read more

More replies
Relevance 74.62%

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 74.62%

Hello everyone,

I'm hoping that I can get help with my issue at hand. I have a problem that from the looks of it has been asked a few times. However my understanding of excel and visual basic is to very limited to solve my problem without any help.

Here is what I'm faced with:

I made a workbook for keeping track of maintenance and DOT requirements for the trucks in our yard. Each sheet is set up with service date or inspection date visual reminders based off of conditional formation. I get a visual warning (X) amount of days before and a past due warning 1 day after, all depending on my requirements.

After searching the forms I found a thread that looks to be the closest that I can find to my needs. http://forums.techguy.org/business-applications/636786-set-email-reminder-base-excel.html

Since I have multiple dates and need for an email reminder the coding gets confusing to me. I have a very basic understanding of coding principals but have never used visual basic.

What I would like to happen based off of my understanding of the other thread:
Using task scheduler run a VB file that would then open the Excel file everyday at (X) time and check my date parameters and send an email with a warning that a due date is coming up or if past due then an email saying it is past due. The close file.

I'm sure more information will be need to give me any type of help. I have attached the workbook for reference and so my explanation will make more sense.

I'm ... Read more

Answer:Excel: Automated email based on Conditional Formatting

Hi there, I noticed that your post has gone unanswered, you posted on March 25th an looks like nobody has taken a chance on it.
You mention you're using office 2013 but your file is Office 2003 or earlier; I assume this is a file you've been using for quite some time.
What you're asking is in a certain way not that complicated but needs to be thought about very carefully. Usign the scheduler to open the Excel file, check it and then close it is not that muvh of an issue but you do have to realize that if you're using Excel for something else and all at once the scheduler triggers it you could run into some problems and might loose the data you're working on.
In the 'Abq Truck & DOT Reguirements' sheet you've got 4 columns with dates, which one is the one you trigger the mail on, all four? What email address?
Conditional formatting is nice for visual triggers but will not trigger a macro so that all together will be some vba code which needs thinking and writing.
The samples on other posts can of course be used and like you say some coding / vba knowledge is required to adapt it to your needs.
Think about it and update with some extra information, maybe some simple code can be written and used
 

1 more replies
Relevance 73.8%

Could someone help me as I have both Outlook Express and Widows Mail. I can send mail from Windows Mail but when I click on a link in a webpage, Outlook Express always opens. When I type my email and press send it appears to send it. However I recently found that all my emails were sitting in the outbox and there is no way I can get Outlook Express to send them. Perhaps I can only have one email program at a time?? If someone could advise how I get Outlook to send emails I would be very grateful. Judy
 

Answer:Solved: Outlook Express will not send email

10 more replies
Relevance 73.8%

I configured outlook express exactly the same way as thunderbird. Thunderbird is working flawlessly but im getting an error message saying "the host blablabla could not be found. Please verity that you have entered the server name correctly, socket error: 11004, error number 0x800CCC0D." I triple confirmed that I entered the server name correctly and all the settings are identical to thunderbird's.
Im using windows xp sp3 connecting to a exchange 2003 server. Please advise, thanks.
 

Answer:Solved: Cannot send email with outlook express

nevermind... they were doing something on the exchange server. that explains why.
 

1 more replies
Relevance 73.8%

I had an email with an attachment the other day that would not send; it was small, under 100 KB. So I turned off wifi and deleted it. Outlook now keeps trying to send a non-existent message - presumably the same one though my Outbox is empty - and then gives error messages. Is there a way to clear this blockage?
 

Answer:Solved: Email in Outlook stuck trying to send

11 more replies
Relevance 73.8%

Hi all,

I know this has been posted a few times already, but I am a programming noob and I'm having a bugger of a time altering the code that forum members have already given to others to suit my needs.

What I'm looking for is this: I have a master excel (Office 2013, operating on Windows 7) sheet with numerous tabs (one tab per customer) that has a) their requested dock date for their parts and b) the date I sent them their final invoice, which they need to pay within 30 days. I am trying to get excel to send me an e-mail (to Outlook 2013):

1. 5 days before their requested dock date (so I can make sure our production staff have everything under control and it will be shipping out as scheduled)
2. 5 days before their payment is due (so 25 days from the date I said I invoiced them) and
3. If possible, it would be great to receive an e-mail on the date payment is due as well, as well as in 5 day intervals until payment is made.

Another difference is that I would like all e-mails to go to me, not directly to the customer (so no variable e-mail addresses).

Is this possible at all? I've attached a example of the spreadsheet I'm working with if anyone would be able to help.

Thanks!
Arianna
 

More replies
Relevance 73.8%

I'm trying to Merge an Excel spreadsheet to Outlook and provide alerts for critical dates in said spreadsheet in the Outlook calender !
 

Answer:Excel - Merge Excel spreadsheet to Outlook with Alerts

Welcome to TSG faithtronic.

I've never done it but your thread has been setting here a while. A method to do this here http://www.ehow.com/how_5685419_create-calendar-excel-data.html

I would start with a couple of dates so not to screw up the whole calender! There are some sharper excel folk on this site that might provide a better answer. But this is a starting point?
 

1 more replies
Relevance 73.39%

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 73.39%

I am trying to help a client with a outlook email issue. He has two computers in the house and two email accounts. A desktop and a laptop that both connect to the same network just one LAN and one wireless connection. he has a verizon email account and an outboundlcc.com email account. The verizon email address can send and receive on both computers. His nboundlcc.com email cannot send from the desktop or laptop and gets a smtp error when trying to send out. This does not happen on the laptop when he uses a USB verizon wireless adapter. He thinks the problem started when he switched his router to a netgear Dual Band router. Could the router have something in the settings preventing his email from sending. Why would it not happen with his verizon email and does happen with his nboundlcc email. He also has Norton on the computers, which might be blocking the emails from going out. I am just speculating and am unsure what this error could be caused from. I checked both computer outlook settings for the nboundllc.com email and they are identical. Any ideas?
 

Answer:Solved: Outlook Email will not send (SMTP error)

7 more replies
Relevance 73.39%

I've just had a problem with Outlook Express that I've never encountered before. When I right click on a document and select Send To, and then Mail Recipient, I get a message now that says-

No profiles have been created. To create a new profile, use the Mail icon in the Contro Panel.

Could this have been caused by any of three new security updates from Microsoft yesterday?

I tried to remove them but it cautioned me that several programs on my computer may not work properly if I uninstall them. I send files to lots of people and I don't want the hassle of of creating a new profile every time I do.

Thanks in advance.
 

Answer:Solved: Outlook Express 6- can't send files by email

You could try the fixes suggested here:
http://windowsxp.mvps.org/sendtomail.htm
Watch you get the spacing right.
 

2 more replies
Relevance 73.39%

I need some help to help me fix my Outlook Express. My main problem is when I send email. Whenever I hit the send/receive button to send my email, an error message comes up. The error message is An unknown error has occured, Protocol: SMTP, Port: 0, Secure (SSL); No, Error Number: 0x800C0131. However, it will receive my email (most of the time). Before I can send the email, I have to get out of Outlook Express and restart my computer. After I restart the computer and go into Outlook Express and hit send, it will send my email, buy if my sent folder and deleted folder read Folder can not be displayed, I have to shut down all the way for about 5 minutes. Whenever my sent folder and deleted folder have this message, I can not get email either. It just flashes by real quickly when I hit the send/receive button. Even after I get out of Outlook Express and it asked me if I want to send the emails in my outbox and I click yes, it will never send the messages.
I have to restart the computer. I have Outlook Express 6 plus Windows 98.
My computer is the AMD Athlon XP-1800 1.53GHZ made by CyberPower Inc. I am networked to 3 other computers in my office. We have Bellsouth DSL.
My Internet Options-Programs is selected Outlook as my email. My boss even tried reinstalling Outlook Express, but it did not help. Hopefully, I have given enough information for someone to help me because I am getting very frustrated with my computer.
The constant restarting I have to do every time I send email i... Read more

Answer:Solved: Problems with Outlook Express when I send email.

9 more replies
Relevance 72.98%

Hello.
I have been tasked to keep track of follow ups for Implementation dead lines.

This is my first post here. I need your help in developing a mechanism to send an automated outlook mail, when the due date is 14 days away from being implemented/addressed. 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. J), with subject "Audit Follow Up_Audited Function (Col. A) is due on Due date(Col. I)", and body "Dear Name(Col. K), Reminder - Audit Follow up on Implementation Date"
Also, the script should put a check mark on Reminder sent column (Col. L) 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. I've attached my sample spreadsheet.

Thanks
 

Answer:Automated Reminders excel 2007 thru Outlook

10 more replies
Relevance 72.98%

Hi all,

I know there has been a lot on this subject (so apologies) but as my knowledge in this area is limited and as I can't find anything that matches my exact needs I am struggling.

Basically, as part of my job I manage records in the office but I sometimes forget when things needs renewing etc.

What I would like is a for an e-mail to be sent through and to my outlook when a date has been reached.

Please see the attached: CSCS.xlsx

If CSCS tests had to be done every year for example, Paul Smith would be due another on 01/01/2014. I would like to set up a code so that when it got 2 weeks before that time, I got an e-mail saying 'CSCS Test due' and 'Smith' (i.e.. cell C1 and Column A for reliant person, in this case A3).

Is this something that is do-able and easy to set up?

Thanks, charli
 

Answer:Solved: Excel Send E-mail (via Outlook) When Date Reached

10 more replies
Relevance 72.57%

How to Extract Email Addresses From Excel Spreadsheet. How to extract emails from different cells into a new sheet.

Answer:How to Extract Email Addresses From Excel Spreadsheet

Without knowing the layout of your spreadsheet, it is impossible for us to answer your question. You need to supply some more details.If you are going to post any example data to show us how your spreadsheet is set up, please click on the following line and read the instructions found via that link.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 72.57%

I have saved my contacts to an excel spreadsheet. I opened my windows live mail and clicked on import, and followed the directions. out of the 5,000 email addresses, only 233 imported into my contacts. why is this? is there a limit on how many email addresses you can import at a time or is there a limit to how many contacts you can actually have in windows live email?
 

More replies
Relevance 72.57%

Hi,

My company uses an excel spreadsheet to record when we are providing information to clients. Mmy colleagues enter this into the spreadsheet and should tell me when we have finished providing the information - which means that I then raise an invoice to the client for the number of days' work we have done. Unfortunately, they can forget - so I then have to go through the spreadsheet daily to double check that my invoices are right. I'm sure there must be a way of inserting some sort of code into the spreadsheet so that I get an email automatically when I should raise an invoice. I know very little about excel though and don't have a clue how to understand or manipulate any of the codes posted for similar sorts of queries! My initial thoughts were:

1. Put a column in the spreadsheet whereby the colleagues enter the value "0" if providing info that day or "1" if the info supply has stopped.

2. I could put in a conditional format so that the client's name cell becomes red as a visual clue - but there is still a risk that I miss it, as the column would gradually become more and more red (or I enter value "2" once I have raised the invoice which then turns it blue).

However, what I would really like is that Excel spots that the value has been changed from 0 to 1 and then emails me to say that it is time to invoice the client (and which client it is that needs to be invoiced).

Could someone please provide clear, step by step... Read more

Answer:Email me when colleague changes value of excel spreadsheet cell

Hi, and welcome to TSG forums

I had several thoughts upon reading your post. Preparing an email message with Excel is an easy task. Preparing and sending it is a bit more difficult, but no problem either. However, choosing the event that triggers email sending requires a thorough planning.
I'm not sure I understood completely the situation, but it seems that either way, the notification will depend on other users (i.e. your colleagues), who either call you by phone, or send you an email, or change a cell's value from 0 to 1 (which latter would then trigger a mail sending), etc.. And there comes my problem. If you colleagues can forget to call you, even though it is a strict part of their workflow, how can you be sure they won't forget to put 1 into that cell? Or, even if they do put 1 into that cell, will they do it when they will have already filled the other cells? Or maybe someone will think: 'I'm gonna deal with these clients today, and I'm surely gonna close their cases, so let's put 1 into those cells right now, before I forget to do it.' And her computer sends you a bunch of emails, signaling that you can raise the invoices, even though she hardly even started to fill the spreadsheet.
Maybe I'm getting it wrong but the bottom line is that when you depend on others, who are also typically non-expert Excel users, there's always a chance that they will fail you.

So maybe it would be a better approach to create a code th... Read more

3 more replies
Relevance 71.75%

I am having a problem figuring out how to email an Excel 2007 spreadsheet in the body of an email. I cannot do it as an attachment as the owner of the company is just not that computer literate. I recently got a new computer at work and they installed Office 2007. I am getting use to it but I cannot find the way to do this simple thing. Copy paste does not work and the only command I have found so far is "Send Email" in the file menu when you click on the Office Icon but this opens an email with the spreadsheet as an attachment. Can someone help?
 

Answer:Emailing an Excel 2007 spreadsheet in the body of an email

Don't have Office 2007 and can not test this, but ...

First, are you sure you are composing the new e-mail as HTML formatted when you tried the copy and paste?

Does Excel give you the option to save the worksheet as an HTML file? If so, try opening the saved HTML file in Internet Explorer and then copying and pasting from IE into your HTML formatted e-mail message.
 

2 more replies
Relevance 71.75%

Hi, this has been bugging me for a while, no probs with explorer, mozilla, p2p etc. Only when opening OUTLOOK EXPRESS V6. Hangs up browser connection, Brings up standard Dial-Up box. Connects fine but doesnt seem to re-check send/recieve after the 1 minute time set. And when I do that manually it hangs up again with the Dial-up prompt.?

Any suggestions welcome.
 

Answer:Solved: Disconnects opening Outlook Express and again when trying to send/recieve any email.

9 more replies
Relevance 70.93%

Excel XP
Trying to import a spreadsheet with lots of email addresses (Import | Export) into
a contacts folder, error:
An error has occurred in the Microsoft translator while getting the contents of a file system
The Microsoft Excel file “C:\...xls has no named ranges. Use Microsoft Excel to name the range of data you want to import.

Note this has multiple sheets, if I copy the one sheet into a new file and then try the import then I receive error:
An error has occurred in the Microsoft translator while getting the contents of a file system
The File “C:\..xls was not recognised. The Microsoft Excel translator was unable to recognise this file. It could be the wrong file, a version of the file type which is not supported by this translator, or the file might be corrupt

I have saved the “one spreadsheet” as a txt file and tried to import this into contacts, but receive error saying that Microsoft outlook translator is not installed, when inserting my disc doe not seem to find it? (when going into control panel to see options Add | Remove in Microsoft Office I don’t see it here either?)
 

Answer:Excel XP Trying to import a spreadsheet into Outlook

Well.. managed to run this install (translator) from disc (kinda hung for a while?) anyhow I saved the spreadsheet as a csv file brought into outlook all ok (mapped the fields) all look good in the contacts folder. The reason for all this was to create a DIS list (80 email accounts) Now when going to File - New Dis List and selecting the members (button) and selecting the drop down box for my new contacts, which are all showing and clicking add all I see being moved accross to the other side is the , or ; symbol??? this is for all the contacts?
 

1 more replies
Relevance 70.11%

Hello All,

Looking for some help setting up a spreadsheet to help notify my colleagues (through an outlook email) when our lab sample deadlines are overdue.

My excel capabilities are average at best, but I'm pretty good at taking instructions and applying them. I've spent some time looking online for a coincidence and have found several decent threads, however I need help specifically applying to my application.

I've attached a sample spreadsheet that I've just begun working on. I've used a datedif() >7 or >10 to highlight the samples which are 7 or 10 days overdue. I'm looking to send a notification to the emails provided when the datedif() becomes true (when the samples are overdue).

I'm also willing to totally start over if there is a better way to set the spreadsheet up in the first place.

Let me know what information you need from my end. Any help is much appreciated.

Emanuel.
 

Answer:Automatic outlook emails from excel spreadsheet

Have you already taken a look at the many similar post with answers and solutions?
I suggest you start there
 

1 more replies
Relevance 69.29%

Hello all,

I am using Office 2003 (and MS Exchange 2003). I make use of the public folders to manage office contact lists.

My goal: To create Excel templates where I am able to pull real-time (or nightly synchronized, if not real time) drop-down lists of the fields in those contact folders.

I understand drop-down lists in Excel are easy to do if you want to manually enter the options in each cell, but I ultimatelly hope to have that cell point to options in a certain field in an outlook contact that exists on my exchange 2003 public folder.

Is there a way to establish a direct link between the two? Is there some scripting that would be necessary to "synchronize" from Outlook to a data file that can be pulled in by Excel?

Thank you for any and all advice and direction.
Brian
 

More replies
Relevance 69.29%

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 68.47%

Dear All,

I am new to this forum and not sure if this had already been answered. But here it goes anyway.

I would like to create a vacation form that users can use to fill their vacation requests. This form will have approve or reject buttons. If approved, the data would be auto populated onto an excel spreadhseet. If rejected, the rejection email will be sent back to the user.

Can someone show me how to do this.

Many Thanks for all your help in advance.

Regards,

Rashid
 

More replies
Relevance 68.47%

I have a database which, when a button is pressed if the field calls_made is 1 or 3, an email has to be sent out. I can manage to send a plaintext email, but there needs to be an image at the top which has a hyperlink attached to it. Also some of the words are in different colours and sizes etc.

At the moment there are 18 draft emails, which are saved in outlook. The user then has to manually find which template they want and fill in the email address, and sometimes the name. I want to automate this process so that, depending on a list box field called result with 18 possibiltiesm, the correct template is sent out.

I looked at saving each email template into word and using a mail merge, but choosing the correct email and getting the persons email address from the to field in the database into word defeated me.
 

Answer:Solved: Automated email in access

16 more replies
Relevance 68.06%

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 66.83%

Hi guys,
I would like to be able to move an email to a sub folder of my mailbox and get Outlook to send an email to the sender of the email I moved into it. Hope that makes sense.

I found this archived thread http://forums.techguy.org/business-applications/439567-outlook-reply-email-when-mail.html which has proved very helpful and I've managed to get it working for me.

I would like it to send more than just a one line email reply but I don't know how, maybe get it to use a text file for the body of the email?

Any help would be great

Thanks
 

More replies
Relevance 66.83%

I have uploaded a sample of the spreadsheet I am trying to modify and I kinda have it working the way I want and I need these costs broken out the way I have them. I will try to explain what I want the best I can so bear with me.

I want "Total" to capture if it is an expense or income. (right now it is not)

I want "Balance" to reflect if it is an expense or income. (right now it is not)

I want any unpopulated cells to show nothing or ""

This is probably simple for an excel wizard but I only know excel good enough to get into trouble!

Any help is appreciated, thanks, Joe
 

Answer:Solved: Can someone help me with this Excel spreadsheet?

16 more replies
Relevance 66.83%

I have a spreadsheet that I need to sort by column (P) which has formulas in it that added data from each row across. I checked all my formulas and they are correct. I had to delete 3 separate rows so I highlighted each one and went to "insert/delete rows, columns" etc. and deleted them there. I then went to DATA and sorted by column (P) from highest value to lowest value and that computed correctly. The data in each row however shifted so each row is incorrect. I don't know how to fix this. Can someone PLEASE help!! This is the only spreadsheet I work with and have never had a problem. I know I must've done something wrong but I've been working on this for 2 days. Did I mention I hate excel due to my ignorance of how it works??? HELP!! Thanks in advance.
 

Answer:Solved: Excel Spreadsheet HELP!!

13 more replies
Relevance 66.83%

Every month for several years I have accessed my own spreadsheet offline from desktop icon.
To utter consternation and increasing frustration, today OPEN brought up the file BUT can do nothing with it.
Same results with backups on different drives.

Consequently told browse to find program from which can OPEN. Obvious choice MSN Excel. Result: "Cannot find any version ...to open file for edit".

Further on I installed msn xlviewer. In Open process came box, "Office Source Engine (Process ID: 2120) running. Need to Close". How/where to do so no idea. I am on Vista Ultimate with !E7; note not included in list for this item.

FYI, I only have Office 2002 (with Excel 2002), but cannot even remember last time I used it for anything. Also note many MSN references to Office 2003, but hardly ever 2002.
Point is, HOW CAN I GET BACK WHERE I WAS & NOT BE REFERRED TO NEED FOR A PROGRAM (EXCEL)?
Only secondarily (and reluctantly) interested in making Excel function to restore ability to use my spreadsheet.

I will be most grateful for help in this unexpected problem.
 

Answer:Solved: Spreadsheet with/without MSN Excel

16 more replies
Relevance 66.83%

Hi everyone! I'm trying to set up a spreadsheet for my husband who is a competitive swim coach.

He needs to be able to look at it and see if he tells the kids to swim 10 one minute sets, how many minutes that will take. (Gets more complicated than that of course! ) So I set up a spreadsheet with the seconds across the top and the number of sets along the side and did a formula series in the time increments. i.e.: :25, :50, etc...

The problem is when it gets to 25 seconds x's 3 -- it needs to read 1:15 - and all I can get is :75. It needs to be on minutes and seconds like a clock.

Anyone know how I can get it to read correctly??

Thanks!

Rebecca
 

Answer:Solved: Excel Spreadsheet

enter seconds in a cell as:

00:00:25
00:00:50

etc

then right click the cells and click Format Cells, select Custom and enter mm:ss to just show minutes and seconds

is this what you meant?
 

2 more replies
Relevance 66.01%

I'm having trouble getting this automated email to send. I want it to prompt the MsgBox to the user if the Forms!Form1.Text83.Value yields an error (i.e. that field is null), but if it's not null I want the procedure to send the email.
What's happening with my code below is that when the Forms!Form1.Text83.Value is null, it will prompt the message AND send the email, and when Forms!Form1.Text83.Value isn't null it will do nothing.
How can I make it just display the message box when null, and just send the email when it isn't null?
Code:

Private Sub SendMessage()
Dim objOutlook As Outlook.Application
Dim objOutlookMsg As Outlook.MailItem
Dim objOutlookRecip As Outlook.Recipient
'Dim objOutlookAttach As Outlook.Attachment

Set objOutlook = CreateObject("Outlook.Application")
Set objOutlookMsg = objOutlook.CreateItem(olMailItem)

With objOutlookMsg

Set objOutlookRecip = .Recipients.Add("*removed for privacy*")
objOutlookRecip.Type = olTo
On Error GoTo ErrMsg
Set objOutlookRecip = .Recipients.Add(Forms!Form1.Text83.Value)
objOutlookRecip.Type = olTo
Exit Sub
ErrMsg:
MsgBox "Please enter your e-mail into into the Form1 textbox labeled 'User E-Mail'"
.Subject = "MISSING Routing Information!"
.Body = "Please follow the link below to the F_Routing Form to fill in the email address for each Mfg_Cd that is listed:" & vbCrLf &am... Read more

Answer:Solved: Sending an automated email, including a possible error message

Someone on a different forum gave me this, which worked great:
Code:

If Len(Forms!Form1.Text83 & vbNullString) = 0 Then MsgBox "You need to fill out the address"Else 'your code here to send the emailEnd If

 

1 more replies
Relevance 66.01%

If someone with access to a excel 10 spreadsheet makes a change in it is it possible to have an email sent to my outlook email address?

Answer:I'm trying to send an email from Excel.

Yes, you can achieve this by using the 'BeforeSave' function. Open the VBA window, expand 'Microsoft Excel Objects' if it's not already, then double-click on 'ThisWorkbook.'Copy and paste the following code into the window: (Note: you will need to change the email addresses and the servername at the minimum!)Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Dim MailObject As Object
Dim Cconfig As Object
Dim SMTP_Config As Variant
Dim Email_Subject, Email_Send_From, Email_Send_To, Email_Body As String
Email_Subject = "User Has Saved Changes to Your WorkBook"
Email_Send_From = "[email protected]"
Email_Send_To = "[email protected]"
Email_Body = "Someone has made changes to your workbook and saved them."
Set MailObject = CreateObject("CDO.Message")
On Error GoTo debugs
Set Cconfig = CreateObject("CDO.Configuration")
Cconfig.Load -1
Set SMTP_Config = Cconfig.Fields
With SMTP_Config
.Item("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
.Item("http://schemas.microsoft.com/cdo/configuration/smtpserver") = "PUTYOURSERVERNAMEHERE!"
.Item("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
.Update
End With
With MailObject
Set .Configuration = Cconfig
End With
MailObject.Subject = Email_Subject
MailObject.From = Email_Send_From
MailObject.To = Email_Send_To
MailObject.TextBody = Email_Body
MailObject.send
debugs:
If Err.Description <> "" Then MsgBox Err.Description
End Sub
Law of Logic... Read more

6 more replies
Relevance 66.01%

I'm using an Excel worksheet (2007) that has macros to populate a form that I want to email to various people. I used to do it with no problem in the 2003 version, but now I get a message that says, "Unable to Sign - If using Microsoft Publisher or InfoPath Please resend as an attachment." This error message is in a dialog box that has the label, "Send as message not supported from Microsoft Publisher or InfoPath" I wasn't aware that I was using either of those applications, just Excel and Outlook. I don't care if the message is digitally signed before sending or not, I just want to send the form out. Any ideas?
 

More replies
Relevance 66.01%

I'm trying to send an excel worksheet via email. I currently use Office 2003 and I'm use Windows Live Mail for my email. I have the icon in the file menu on Excel but it is grayed out and I am unable to access it. Does anyone know how to fix this?

Answer:I'm trying to send an email from Excel.

hi mom2otto,i found this for you..it may be helpful to you...rondebruin[dot]nl/sendmail[dot]htm

2 more replies
Relevance 66.01%

send receive receive is good--cannot send messages

More replies
Relevance 66.01%

Just got this after downloading google drive. I am new to excel. I enter a number in a cell and goes in. My question is this. How do you move that number say to the centre of the cell? Thanks
 

Answer:Solved: google excel spreadsheet

Click the Horizontal icon then select Center:
 

3 more replies
Relevance 66.01%

I am trying to enter a whole number that looks like this "123" into a cell and have it look like this "00123". I've even tried to custom format it and I can't get it to work. Please help
 

Answer:Solved: Need help formatting Excel spreadsheet

Hello smeegle, select the cells that you want to format and the on the main menu select Format>Cells>Number>Custom
and type in the box
00000
this will give you the format that you have shown.
 

2 more replies
Relevance 66.01%

Hi,

I am using a code to compare two spreadsheet.
One of the function is to copy the modified records in a different worksheet, highlighting changes element in red.
The script works, but ONLY when the cell is modified to "blank"(no value), I get coloured in red the upper cell instead of the correct one.

Here the script, any help?

Sub GDV()
Dim WsA As Worksheet, WsB As Worksheet, WsC As Worksheet, WsD As Worksheet, WsE As Worksheet
Dim rFind As Range, c As Range
Dim I As Integer, ColCnt As Integer

Set WsA = Worksheets("OldExport")
Set WsB = Worksheets("NewExport")
Set WsC = Worksheets("Changes")
Set WsD = Worksheets("PosDeleted")
Set WsE = Worksheets("PosAdded")

ColCnt = WsA.Cells(1, Columns.Count).End(xlToLeft).Column

With CreateObject("Scripting.Dictionary")
For Each c In WsA.Range("A2", WsA.Range("A" & Rows.Count).End(xlUp))
If Not .exists(c.Value) Then
.Add c.Value, False
Set rFind = WsB.Columns(1).Find(What:=c.Value, LookIn:=xlValues)
If Not rFind Is Nothing Then
For I = 1 To ColCnt
If Not c.Offset(, I - 1) = WsB.Cells(rFind.Row, I) Then
If .Item(c.Value) = False Then
rFind.Resize(1, ColCnt).Copy WsC.Range("A" & Rows.Count).End(xlUp).Offset(1)
.Item(c.Value) = True
End If
WsC.Cells(Rows.Count, I).End(xlUp).Interior.ColorIndex = 3
End If
Next I
Else
MsgBox c.Value & " PosID has been canceled!"
c.Resize(1, ColCnt).Copy WsD.Range("A" &am... Read more

Answer:Solved: Excel VBA comparing spreadsheet

to who may be interested
I found a solution (workaround) here:
http://www.excelforum.com/excel-pro...adsheet.html?p=2818323&viewfull=1#post2818323
 

3 more replies
Relevance 66.01%

howd'y

I'm just wondering how to convert this spread sheet file (.wks) to excel 2007..

i know thats a lot of years in between the two programs but there must be a way to convert it.. or is there?

so i do need to open and re use the spread sheet but i don't know how i got that program in the first place.. so yer.

ive tried to convert it using excel 07' and was a fail. only came up with all differnt characters.

thanks for reading.
 

Answer:Solved: converting spreadsheet (.wks) to excel 07

Is this of help ??? http://forums.techguy.org/business-applications/779694-solved-works-vs-excel-formats.html
 

3 more replies
Relevance 66.01%

Hello,

I am having a hard time getting my formula right to automatically work out what percentage will be earned on sales, which is dependant on what percentage of their annual target has been reached.

I have got the formula to work for one of the commission rates but my maths or formula isn't working on any of the other rates.... Could someone please have a look at my attached spreadsheet and correct the formula!

Very much appreciate your time

Thanks
 

Answer:Solved: Excel Spreadsheet - Commissions

Never Mind, I figured it out myself!!!
 

1 more replies
Relevance 66.01%

I have a large spreadsheet in which data is added weekly. At the top of the page I have several "windows" in a set of frozen rows which display results from the various columns. I would like to know if it is possible to have a function in a cell which would make a calculation using the last added row of data. For example, to compare a price to the previous week or to the highest figure in the column.

Regards

Daffer
 

Answer:Solved: Excel 2003 spreadsheet

10 more replies
Relevance 66.01%

We are playing a silly game that is teaching me about trading on the Stock Market. I am trying to figure out how to work my spreadsheet up so that it will tell me when to buy and when to sell my stocks in certain companies. I have the basic spreadsheet with category, business, bought, sold, buy, sell but I am having a problem. I need a column to automatically tell me the lowest amount seen in "buy" and the highest amount seen in "sell". Is there a way to do this? I used to think I was proficient in Excel but this gives new meaning to "tearing your hair out" for me. I'm sure that there are pivot tables and all sorts of other things to utilize but I'm not sure how when I'm only wanting to see things a certain way. Can you help?
 

Answer:Solved: Excel Help with trading spreadsheet

11 more replies
Relevance 66.01%

I have an Excel spreadsheet, shared over the network and anytime I try to make and save changes over the network, it tells me that the spreadsheet is read only.

I've checked the attributes of the folder, and the file itself, and it does not indicate that it is read only

I'm using Office 2007 Ultimate and Windows Vista on the machine I'm doing the editing on, and Office 2003 and Windows XP Home on the laptop where the share folder/file resides, if that makes a difference.

I've also checked permissions, and it's checked for Unrestricted Access
 

Answer:Solved: Excel spreadsheet says that it is read only

15 more replies
Relevance 65.6%

Hi,

After a power outage a particularly important file gets the error "Excel cannot open the file.xlsx beacause the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file. The file format has not changed. Is there a safe free program that can uncorrupt a file? I have tried Open and repair, changing the format, and using open office. Also tried using recova but the file was not lost.
 

Answer:Solved: Excel 2007 spreadsheet gets error "Excel cannot open the file .xlsx.." How ca

https://support.microsoft.com/en-us/kb/820741

and 5 ways are shown here http://www.wikihow.com/Recover-a-Corrupt-Excel-File
 

2 more replies
Relevance 65.6%

I would like to know if I could send an outlook email via command line while also attaching a file via command line. I am trying to have a Windows 2000 or 2003 server inititiate an email when it sees a certain text file arrive on the server. The email should run automatically with the file attached. I've found this attached link on how to do the command line: http://support.microsoft.com/kb/192341/en-us But no mention of attaching a file. Anyone have any ideas? Thanks!
 

Answer:Outlook - Send Outlook email via command line w/attached file

9 more replies
Relevance 65.6%

I 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" then hit send again on the email, can we automate this some how, like a macro that engadges when I open my outlook every morning

Answer:send email from excel based on

This should be in the Office forum here: http://www.computing.net/forum/offi...

2 more replies
Relevance 65.6%

I am looking to write code that will send an out an email automatically if 2 conditions are met in excel. The first condition being, is this a repeat design "Y or N" and the second is the number of days shown in another column. The criteria is, if "Y & over 42 days then send email" or if "N and over 14 days then send email" otherwise do nothing.I have my repeat design in Col G & Number of days in Col K. I have been trying to adapt the code below that I found online earlier on. Unfortunately, it uses a limit instead of the IF function I would like. It is currently set to send out an email as soon as any number in Col K goes over a 200 day limit, that's the bit I would like to change.Private Sub Worksheet_Calculate() Dim FormulaRange As Range Dim NotSentMsg As String Dim MyMsg As String Dim SentMsg As String Dim MyLimit As Double NotSentMsg = "Not Sent" SentMsg = "Sent" 'Above the MyLimit value it will run the macro MyLimit = 200 'Set the range with Formulas that you want to check Set FormulaRange = Me.Range("K8:K100") On Error GoTo EndMacro: For Each FormulaCell In FormulaRange.Cells With FormulaCell If IsNumeric(.Value) = False Then MyMsg = "Not numeric" Else If .Value > MyLimit Then MyMsg = SentMsg If .Offset(0, 1).Value = NotSentMsg Then Call Mail_with_outlook2 End If Else ... Read more

Answer:How to send an email from excel if certain conditions are me

Thank you for reposting the code with the pre tags. That really helps.As far as your example data, your column letters don't appear to line up correctly, but based on your earlier posts, I'll assume that Column K contains the 443, 18, etc.Another posting tip:Since we can't see your workbook from where we're sitting, telling us that the VBA code is "coming up with an error" doesn't give us a lot to work with. VBA can present all sorts of errors, including syntax errors, compile errors, run time errors, application errors and even the dreaded Fatal Error. (Ouch!)It would help us help you if you told us what the error says and, if possible, which instruction caused the error.Allow me to offer you this before I address your question:If you are going to be using VBA, either writing your own code or just trying to figure out how code that you find on the web works, it helps to have some debugging techniques in your toolbox. I suggest that you practice the techniques found in the following tutorial. Not only can these techniques help you find errors in your own code, but they can be used to reverse engineer code that you find elsewhere. I am essentially self taught in VBA and much of what I have learned came from my application of these debugging techniques on working code, which helps me understand how and why the code does what it does.https://www.computing.net/howtos/sh...OK, as for your current problem, let's take a look at what you said:"I cut and replaced "My Limit = 200" in m... Read more

7 more replies
Relevance 65.6%

When I start in Word or Excel (office xp pro) and hit
file, send to, send as an attachment the word email
editor will pop up with the word document as an
attachment (as it should). I then put the address I want
to send it to and hit the send button. The send button
greys while the mouse button is pushed (as it should) but
the message stays there. It does not send. I can hit the
button 7 million times and the email and attachment just
sit there.

Does anyone have any idea what may cause this?

Side notes: It doesn't mater if outlook is open or closed same effect either way. I can send attachment directly from outlook.
OS Win XP Pro. Network 2000 Server with 2000 exchange.
Newest Service Packs on all software from server to local
machine including office.
 

More replies
Relevance 65.6%

HI All,

Can any one help me on this.

I want to auto send email from file whwnever a cell value changed.

In attached excel file if the value of cell "C" get changed to yes then excel should automatically send email to the addreess mentioned the column D.

Help on this .

shishir kumar
 

Answer:Excel to auto send email

Hi there, welcome to the forum,
There are quite a lot of postings with similar questions.
Have you checked this? You can search for then and I'm sure that the solution is there for you.
Some minoor editting may be needed but it will work
 

1 more replies
Relevance 65.6%

Hi all,

I have an excel file from which I want notifications to be sent to a particular email address. I have seen several threads which are related to mine however I could not manage to do it. I am new to this stuff and need your help to explain the coding.

I have 2 columns (in red in the attached file) and I want a notification to be sent via outlook if the expiry is due within 2 months, 1 month and on the day as a reminder.

Another query I have is that this excel sheet will be used by multiple users. Will the notifications be sent each time a user will use this sheet?

Your help is much appeciated.
 

More replies
Relevance 65.6%

Hello,

First time post from me! So hi everyone.

Im a begginner at this so any help would be appreciated.

I have created a training matrix on Excel, and it obviously peoples training runs out regularly. Somehow i need to try and get an email sent to 4 different email addresses when somebodies training is a month before running out. Then, if its still not updated, another email to be sent out 2 weeks before the 'date expiry'.

I've tried messing about with Task schedular and have got an email to be sent out every Monday morning at 9am, to various email addresses. However, ideally i need something which would send an email alert as i explained. Ive tried with macros and visual basic codes, but its just a bit too much for me! haha

I understand there have been similar posts, and i have tried to adapt to them, but still doesnt seem to work out.

Any help whatsoever would be fantastic.

Look forward to your reply.

Thanks
OW
 

Answer:How to send an email from excel when a cell changes.

16 more replies
Relevance 65.6%

Hi All,

Let me take the pleasure to introduce myself as Vasu, beginner in this forum.

I know that there are many on going threads related to my this new thread. But, actually I had gone through some of the posts (like Rollin, OBP, and Diego) as per my need and I did saw OBP used to share some links which already covers this my new thread, but since I am totally beginner to MS Excel, so I could not understand many of the things. So, with left chance I thought initiating the new thread, so that I can aware of step-by-step to "automatically send an email from excel on date basis". Hope you all fine with this.

So, here is what I need, I have a sheet (which contains columns Request No, Owner, Run Date, Due Date to Close Request). Usually sometimes we miss to close the requests as per the due dates.

So, could you please share detailed information on how can my excel automatically send an email whenever the "Run Date" crosses??

As per my understanding after reading the existing posts, I thought of giving you some sample data from my side. In my attached workbook, there are two sheets ("Request Tracker" and "Email"). "Request Tracker" sheet contains the base data on which "Email" sheet contains what I need in my email when excel send an email.

I would be more than happy to give you any additional information if required.

I use MS Outlook and MS Excel on Windows.

Thanks for your assistance and help to get my problem ... Read more

Answer:How to send an automatic email from excel?

15 more replies
Relevance 65.19%

Transition from Office 2007, Outlook to Outlook 2010, Cannot send email
The following has been performed:
1. Re-installed Outlook
2. Deleted profile and re-loaded
3. Look at pssible error from MS updates
Problem still exist, any takers?

Answer:Cannot send email after upgrading from Outlook 2007 to Outlook 2010

What error did it give you?
What email service are you trying to setup?
Do you have "My Outgoing Server (SMTP) requires authentication" checked on the Outgoing Server tab of the account setup menu?

4 more replies
Relevance 65.19%

I have an Excel spreadsheet split into two ranges. I accidentally sorted only one range when I thought I was sorting the whole spreadsheet, then made other changes and saved the file. I could not undo back far enough. Is there anyway to re-sort so I can re-connect the two ranges and put them in the correct order?
 

Answer:Solved: Excel Spreadsheet Accidentally Mis-sorted

Hi, this is something that is 'back to the drawing board'
There is no way that Excel knows what the previous sorting was.
Your only option is to lookup the file using Windows Explorer, righclick on the file and if you're using Windows 7 or later there is a tab named 'Previous Versions' you can then see if you can find a file before you carried this out and recover it.

Good luck
 

2 more replies
Relevance 65.19%

I have a data base that is linked to an excel spreadsheet. I want to be able to open that sheet up by pushing a button on a menu form in access.

Currently I have a button that opens up the application but then I have to open the excel file after excel opens.

How can I get the file Quick Guide.xls to open right up by pressing a button on the access menu?
 

Answer:Solved: Access - Open Excel Spreadsheet

6 more replies
Relevance 65.19%

I have a spreadsheet with almost 3,000 lines in it that I'd like to add to a Dashboard in Excel - but I can't figure out how to do this within excel.

I know how to embed a spreadsheet from excel into a word document, HTML document, etc - but not within the same program.

I want a dashboard "rectangle" that is scrollable within itself to show all 3,000 lines of data without taking up more than 30 standard-sized rows.

This is an Asset Management spreadsheet with several dashboard items as pie charts, graphs, etc - but I'd also like all of the PC names listed on the same page without taking up all the space it normally would - it needs to be the same size as the other graphs.

Any help is appreciated! Thank you!!

-Drake
 

Answer:Solved: Embed a Spreadsheet in Excel (Dashboard)?

10 more replies
Relevance 65.19%

I have raised an Excel 2003 spreadsheet and wanted to show grid lines in it. I have followed the routine "Tools/Options/View" and made sure the grid lines box is checked, but when I print the document none are showing. Can anyone suggest how I can correct his please?
 

Answer:Solved: Gridlines do not show in Excel spreadsheet

9 more replies