Computer Support Forum

Help with Excel sending automated email

Question: Help with Excel sending automated email

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 = Replace(Cells(i, 7), ".", "/")
If Left(Cells(i, 8), 4) <> "Mail" And toDate - Date <= 7 Then
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
toList = Cells(i, 6) 'gets the recipient from col F
eSubject = "Action Topic " & Cells(i, 3) & " is due on " & Cells(i, 7)
eBody = "Dear " & Cells(i, 5) & vbCrLf & vbCrLf & "Please update your project status. Minutes from last meeting:" & Cells(i, 4)

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 Error GoTo 0
Set OutMail = Nothing
Set OutApp = Nothing
Cells(i, 8) = "Mail Sent " & Date + Time 'Marks the row as "email sent in Column A"
End If
Next i
ActiveWorkbook.Save
With Application
.ScreenUpdating = True
.EnableEvents = True
.DisplayAlerts = True
End With
End Sub
Can anyone point me in the right direction as to why this is failing?

Thanks in advance!!

More replies
Relevance 102.09%

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

HiI have a few worksheets with expiry dates, I was wondering if there was a way to set up an email reminder when due dates are approaching - and then again when due dates have passed.all of my due dates in are in column D, but not every row, they skip rows if that means anything. I just need the emails to come to me, not to everyone these dates belong to.(I've already read these, but they didn't help me - TRYhttp://www.rondebruin.nl/sendmail.htmMIKEhttp://www.skeptic.com/)Thanks very much for any further help

Answer:sending automated emails from excel

I have something similar that i use at work, but i have since re created this in VB6 and therefore cannot remember exactly how i did this in excel, but saying that here is something i would probably do.1) Your due dates are in column D2) Use a free column for todays date '=Today()'3) use another column to calculate the days between today and you due date for example1 D E F
2 30/09/2013 02/09/2013 28
in this example D is my due date, E is todays date, and F is the difference in days between the two, so i would make macro to go through all the records and then send an email when F is for example 10 days. If you wanted to calcualte the dates difference dynamically you can use the DateDiff or even DateAdd function in VBA. You can then use the below code to generate an email which will automatically be sent.Sub Mail_Workbook_1()
' Works in Excel 2000, Excel 2002, Excel 2003, Excel 2007, Excel 2010, Outlook 2000, Outlook 2002, Outlook 2003, Outlook 2007, Outlook 2010.
' This example sends the last saved version of the Activeworkbook object .
Dim OutApp As Object
Dim OutMail As Object

Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)

On Error Resume Next
' Change the mail address and subject in the macro before you run it.
With OutMail
.To = "[email protected]"
.CC = ""
.BCC = ""
.Subject = "This is the Subject line"
.Body = "Hello World!"
... Read more

2 more replies
Relevance 83.64%

hello,

I need some help in figuring out how to send an automated email message from an excel spreadsheet to my outlook. My basic requirement is that when the value in a cell ( in my case it is the number of left over days until the deadline) I require an automatic email to be generated and sent to me when the value in this cell reaches a certain threshold value.

thanks
 

Answer:Help with sending automated emails from excel

Welcome to the forum.
If you do a search on your subject you'll finde several posts with the same question. I think the results can help you.
 

1 more replies
Relevance 80.36%

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

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

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

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

10 more replies
Relevance 68.06%

I like another previous member cannot send straight from an excel spreadsheet. However, mine says that no email exists. Any suggestions or comments would be appreciated.

Thanks Christina
 

Answer:help with sending an email from excel

HI,

Check this site.
http://www.rondebruin.nl/sendmail.htm
 

2 more replies
Relevance 67.24%

Hey All
Im very new to VBA, two weeks in the learning. I am trying to set it up so that when a cell on row g (sheet2) states YES. An single email is sent out to an address stated on sheet(1). Problem im getting is im recieving 80 emails. And none of Row g on sheet 2 is stating yes. Also can someone tell me how to make it send only a single email if more then one cell states yes.

Im bad at explain so please ask what every detail that may be needed.
Regards
Jimmy
Code:
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
Dim wa As Worksheet
For Each ws In ActiveWorkbook.Worksheets
If ws.Name <> "One" Or ws.Name <> "two" Then
lRow = Cells(Rows.Count, 4).End(xlUp).Row
For i = 2 To lRow
If Sheets(2).Cells(i, 7) = "Yes" Then
Set OutApp = CreateObject("Outlook.Application")
Set OutMail = OutApp.CreateItem(0)
toList = Sheets(1).Range("G14")
toAlso = Sheets(1).Range("G15")
eSubject = "Reviews/actions"
eBody = "Dear Sir" & vbCrLf & vbCrLf & "You currently have actions/reviews required on assessments on the following."
On Error Resume Next
With OutMail
.To = toList
.CC = toAlso
.BCC = ""
... Read more

More replies
Relevance 67.24%

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

Hello All techies here,

I am very much new to this forum.I am aware that it is possible to send emails from Excel using VB programming but I am very much unaware of VB programming and tricks.

I am working on a work where I need to generate automated mails from excel via outlook based on the contents of the selected cell and some logics.

Here is the URL for image that will give some rough idea.

https://fbcdn-sphotos-d-a.akamaihd.net/hphotos-ak-snc7/s480x480/391681_552548121437857_52068638_n.jpg

or
https://fbcdn-sphotos-d-a.akamaihd....480x480/391681_552548121437857_52068638_n.jpg

or

from this sheet(shown in image) I want to generate mail with logic like this :
case 1) If i click on MSS in row ABC ,click on APD and then press " @ " then it should generate a mail like below and send it to [email protected] and cc : [email protected]

subject : "card request"

mail body
**********
Hello,

My name is ABC (i.e. A2 content).
I need to have some MSS card of APD type
value 1
value 2
value 3
if above cards are not present then we can also use VD
value 4
value 5
value 6

Regards,
Shashank1320
*************

case 2 )but if I press MCS in row ABC ,APD and then press @ then it should send mail to [email protected] and cc : [email protected]

subject : card request
mail body
*****
Hello,

My name is ABC (i.e. A2 content).

I need to have some MCS card of APD type
value 1
value 2
value 3

if above cards are not present then we can ... Read more

Answer:Email sending from Excel programming

Welcome to the forum,
I suggest you do a search for similar posts, give or take minor differences they all come down to the same solution.
Once you've found something taka a look and try it out.
 

3 more replies
Relevance 66.42%

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

Microsoft excel 2003 (as part of microsoft office 2003 small business edition), on XP professional 2002 service pack 3.

I have a spreadsheet on which it looks as though I must have pressed "send to mail recipient", by mistake, because it now always displays with the fields "To:" etc, using up several lines. How do I get rid of all that? I can't find a cancel facility. One option I suppose would be just to send it to myself, but that would involve setting up outlook, and I don't know how to do that, given than I only ever use webmail (googlemail as it happens). I did just try setting it up with completely fictitious info, but it was too clever for me, and recognised that it couldn't achieve sending that way, so kept displaying all the stuff I don't want.
 

Answer:Solved: excel: cancelling sending by email

6 more replies
Relevance 66.42%

Hi is there a way to send an automatic email of a workbook on a certain date?

For example workbook 1 needs to be sent at the end of every month automatically when opened.

thanks
 

Answer:sending excel sheet via email autmatically

"the end of every month"

Is that the last day or the last working day? If the latter, define "working".

The Analysis Toolpak add-in (you'd have to check if you have it installed) has some useful additional functions, such as EOMONTH.

Today (20th March), the formula:

=NETWORKDAYS(TODAY(),EOMONTH(TODAY(),0))

returns 8. That probably means that there are 8 working days left this month, including today. Of course, this month is a bad example because of Easter; NETWORKDAYS' 3rd argument "Holidays" is something you'd have to plug in.

Some very basic "workbook open" code could check the value of such as formula and act accordingly (i.e. if formula result = 1, do x-y-z). You might also need to set a flag to handle the workbook being opened > once on the "last" day.

Beyond that (or maybe even instead of), Ron de Bruin has lots of snazzy SendMail stuff.

HTH
 

2 more replies
Relevance 66.42%

Hi!
I am using Excel to track many IP deliverables for a project. almost 100 IP's
In the excel I have Initial/current/Acutal/date of IP delivery.
Based on the Aligned(Actual) IP delivery scheduled date, I am looking at how to automatically send Email reminder to the IP Provider on or before the aligned from Excel.
Please do let me know how I can acheive this automation.

Thanks
Nagesh
 

Answer:Sending Email Reminders to Different people from Excel

16 more replies
Relevance 66.42%

Hello,
I have a excel through which I track the delivery schedules of a large number of IP's for a design.
I looking how I can automate in excel to send reminders to the IP Providers.
Based on the Actual delivery date, I need to automate the excel to send out reminders.
Please let me know how I can do this. If you need to look at the excel, I can send it.
Thanks
Nagesh
 

Answer:Sending Email Reminders to Different people from Excel

Hi Nagesh!
Wy did U put the same thread twice!
 

2 more replies
Relevance 66.42%

Hi all,

I have a question,
I use the following code to send a Excel workbook via Email.
Code:

Private Sub Mail_workbook_1_Click()
'Working in 97-2010
Dim wb As Workbook
Dim I As Long

Set wb = ActiveWorkbook

If Val(Application.Version) >= 12 Then
If wb.FileFormat = 51 And wb.HasVBProject = True Then
MsgBox "There is VBA code in this xlsx file, there will" & vbNewLine & _
"be no VBA code in the file you send. Save the" & vbNewLine & _
"file first as xlsm and then try the macro again.", vbInformation
Exit Sub
End If
End If

On Error Resume Next
For I = 1 To 3
wb.SendMail "[email protected]", _
"Subject"
If Err.Number = 0 Then Exit For
Next I
On Error GoTo 0
End Sub
It does the trick for so far, but it sends the e-mail directly, without showing the E-mail itself first (only a notifications shows up which tells you some program is trying to send an email).
I would like to manually select Send in the E-mailmessage, so our customers are sure that the e-mail is send correctly.

How do I change this?

An other question, the Subject of the message is now "Subject" how could I 'attach' a value from cell B9 to it?

It would be pretty simple I guess, but I can't find the answers.

And last and also least important.. It isn't poss... Read more

Answer:Solved: Excel; First show Email before sending

7 more replies
Relevance 65.6%

This is prasanna from india. i need a help in my company i want to trigger mail automatically based on the date.. its kind of probation tracking mail... Example :- IF an employee has completed three months automatically mail should trigger to concern person.. is it possible in excelThanks in advance

Answer:Sending automatic Email based on the date in row in excel

Look here:http://www.rondebruin.nl/sendmail.htmYou should be able to find something you can work with.MIKEhttp://www.skeptic.com/

2 more replies
Relevance 65.6%

Hi, I have a risk register which has action by dates for owners of that particular risk. I would like to set up a VBA code that automatically sends each owner an email reminder, through outlook, 5 days before the action date. One owner may have multiple risks due on the same date so I would like the code to send 1 email detailing all the item numbers that the owner has to look at (however this is not at the top of my requirements if it causes issues). I would like the email to include the "Number" (Col. A) in the body listing which risks the owner should look at along with a message reminding them that the action by date is near. Also i want this to be automated, I want the code to run once and send emails as time goes on. Also i will need to change the action by dates as new information is available, can the code account for this change and send another email when the new action by date is near? Thanks for your help I really appreciate it. Using excel 2010
 

Answer:Excel sending automatic email to owners near due dates

12 more replies
Relevance 65.6%

Hello,

I will be grateful if you can please help me have automation in the attached Excel sheet for automatically generating and sending (triggering) Emails to the action owners based on their Email IDs upon approaching of "Actual Finish Date (column I) in the attached Excel sheet? My request is similar to https://forums.techguy.org/threads/excel-sending-automatic-email-to-owners-near-due-dates.1171902/.

You are welcome to suggest and implement value additions.

It will be a boon if this task can be accomplished irrespective of any Email client. Be it Microsoft Outlook or Lotus Notes. Please help.

Regards,
Maitreya Barve.
 

More replies
Relevance 64.37%

Hi All!

I am having major difficulty figuring out excel. I am using a spreadsheet and want excel to automatically send an email to the user in that row when a contract is expiring. Within the row I have the specified user's email, the end date of the contract, and when the reminder email should go out. I have tried playing around with Macros and VBA coding, but I have no idea what I am doing. I am using excel 2003. Any help would be greatly appreciated!! I am using Outlook as my email. Have questions please let me know!

-J
 

Answer:Email automatically sending to user when cell is at a certain Date Excel 2003

16 more replies
Relevance 63.14%

When searching on google I get the following message:

"We're sorry...

... but we can't process your request right now. A computer virus or spyware application is sending us automated requests, and it appears that your computer or network has been infected.

We'll restore your access as quickly as possible, so try again soon. In the meantime, you might want to run a virus checker or spyware remover to make sure that your computer is free of viruses and other spurious software.

We apologize for the inconvenience, and hope we'll see you again on Google."
I had the same problem several months ago but now it is back. I have run all of my spyware and virus soft ware (trendmicro anti-virus, microsoft, ad-aware, spybot search and destroy, ewido and spycop security scanner) but nothing comes up.

Advice?

Answer:Google Says I Am Sending Automated Requests?

DogSoldier:Please read the following quote explaining this message from http://www.oreillynet.com/pub/wlg/6518In other words, Google won?t let you look beyond the first 10 results if you request it to find URLs that point to PHP resources. This is most likely Google?s response to recent worms that have been using Google to look for vulnerable versions of PHP code.Hope that helps,

2 more replies
Relevance 62.32%

Google is sending me a msg.please help me to figure this 1 out.
also thank you very much everyone for any help you can offer
here is my error msg from google and my hijackthis log. i have no clue.
not sure how to return here, email is<email removed> , please email an answer

Google
Sorry...
We're sorry...

... but your computer or network may be sending automated queries. To protect our users, we can't process your request right now.
See Google Help for more information.

2009 Google - Google Home

Logfile of Trend Micro HijackThis

v2.0.4
Scan saved at 4:05:24 PM, on 2/28/2012
Platform: Windows XP SP3 (WinNT 5.01.2600)
MSIE: Internet Explorer v8.00

(8.00.6001.18702)
Boot mode: Normal

Running processes:
C:\WINDOWS\System32\smss.exe
C:\PROGRA~1\AVG\AVG2012\avgrsx.exe
C:\Program Files\AVG\AVG2012\avgcsrvx.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\services.exe
C:\WINDOWS\system32\lsass.exe
C:\WINDOWS\system32\svchost.exe
C:\WINDOWS\System32\svchost.exe
C:\WINDOWS\system32\spoolsv.exe
C:\WINDOWS\Explorer.EXE
C:\WINDOWS\system32\ctfmon.exe
C:\Program Files\AVG\AVG2012\avgwdsvc.exe
C:\WINDOWS\system32\cisvc.exe
C:\Program Files\Java\jre6\bin\jqs.exe
C:\Program

Files\Logitech\SetPointP\SetPoint.exe
C:\Program Files\AVG\AVG2012\avgtray.exe
C:\Program Files\Microsoft

IntelliPoint\ipoint.exe
C:\Program Files\Logitech\LWS\Webcam

Software\LWS.exe
C:\Program Files\AVG Secure Search\vprot.exe
C:\Program Files\Common Files\Java\Java

Update\j... Read more

Answer:your computer or network may be sending automated queries

Your email has been removed. Not only would it be picked up by bots and flood you with spam, but this is a public forum. Please keep all communications public.
 

1 more replies
Relevance 62.32%

Hi all, First post here, here goes.PC/Network EnvironmentI have a laptop running Windows XP SP2 which connects to my work network (wired) and to a wireless network (now wired as wireless router has died) at home (1 internet gateway pc, 1 laptop and 1 desktop connected to that network). The laptop is installed with Symantec Antivirus Corporate which is managed by my work domain/server.While at work we are behind a firewall (server based) but I am not running a firewall on any of the pc's connected to the home network (silly me I know).The ProblemsAbout a week ago my pc all of a sudden started sending out spam when connected to my wireless home network, I knew this was happening as Symantec was monitoring outgoing email and was reporting send failures due to spam every few seconds. I ran a total antivirus scan through Symantec while disconnected from the network and cleaned out what was found and the problem appeared to be over.However, a week or so later and it started again (again when connected to the home network). This time I performed an Ad Aware scan, followed by a Panda ActiveScan Pro scan and another Symantec Antirus scan. Once all issues appeared to be under control I then installed the Sygate Personal Firewall to monitor any future outbound traffic just in case the problem hadn't been eradicated... it hadn't.Now with the firewall runnign all of a sudden I see traffic going to virtuoz.info from svchost.exe and everynow and then to other strange addresses/I... Read more

Answer:I Think Svchost.exe Has Been Hijacked And Is Sending Automated Spam

Hello mikezone13,

Have you retained the logs from any of those scans? If so, please paste them in your next reply.

Orange Blossom

18 more replies
Relevance 62.32%

Logfile of Trend Micro HijackThis v2.0.4
Scan saved at 9:18:08 PM, on 6/12/2012
Platform: Windows 7 SP1 (WinNT 6.00.3505)
MSIE: Internet Explorer v9.00 (9.00.8112.16421)
Boot mode: Normal

Running processes:
C:\Program Files (x86)\ASUS\ATK Package\ATKOSD2\ATKOSD2.exe
C:\Program Files (x86)\ASUS\SmartLogon\sensorsrv.exe
C:\Program Files (x86)\ASUS\Splendid\ACMON.exe
C:\Program Files (x86)\ASUS\ASUS Live Update\LiveUpdate.exe
C:\Windows\SysWOW64\ACEngSvr.exe
C:\ProgramData\DatacardService\DCSHelper.exe
C:\ProgramData\DatacardService\DCSHelper.exe
C:\Program Files (x86)\Internet Everywhere 3G+\Internet Everywhere 3G+.exe
C:\Windows\AsScrPro.exe
C:\Program Files (x86)\CyberLink\Power2Go\CLMLSvc.exe
C:\Program Files (x86)\ASUS\Sonic Focus\SonicFocusTray.exe
C:\Program Files (x86)\ASUS\ATK Package\ATK Media\DMedia.exe
C:\Program Files (x86)\ASUS\ATK Package\ATK Hotkey\HControlUser.exe
C:\Program Files (x86)\ASUS\Wireless Console 3\wcourier.exe
C:\Program Files (x86)\AVG\AVG2012\avgtray.exe
C:\Program Files (x86)\AVG Secure Search\vprot.exe
C:\Program Files (x86)\iTunes\iTunesHelper.exe
C:\Program Files (x86)\Trend Micro\HiJackThis\HiJackThis.exe

R1 - H... Read more

Answer:hijackthis log, my computer is sending automated requests

Greetings and Welcome to The Forums!!My name is Gringo and I'll be glad to help you with your computer problems. I have put together somethings for you to keep in mind while I am helping you to make things go easier and faster for both of usPlease do not run any tools unless instructed to do so.
We ask you to run different tools in a specific order to ensure the malware is completely removed from your machine, and running any additional tools may detect false positives, interfere with our tools, or cause unforeseen damage or system instability.Please do not attach logs or use code boxes, just copy and paste the text.
Due to the high volume of logs we receive it helps to receive everything in the same format, and code boxes make the logs very difficult to read. Also, attachments require us to download and open the reports when it is easier to just read the reports in your post.Please read every post completely before doing anything.
Pay special attention to the NOTE: lines, these entries identify an individual issue or important step in the cleanup process.Please provide feedback about your experience as we go.
A short statement describing how the computer is working helps us understand where to go next, for example: I am still getting redirected, the computer is running normally, etc. Please do not describe the computer as "the same", this requires the extra step of looking back at your previous post.NOTE: At... Read more

3 more replies
Relevance 62.32%

Hi all,

I tried to search a local college's website but got the following message:

"We're sorry... but your computer or network may be sending automated queries. To protect our users, we can't process your request right now.
See Google Help for more information."

I'd appreciate any help I could have with this. I have a 'hijack this' log too if that will help.

Thanks :-)

- Marc

DDS (Ver_2011-06-23.01) - NTFSx86
Internet Explorer: 8.0.6001.19019 BrowserJavaVersion: 1.6.0_23
Run by marc at 18:21:39 on 2011-06-26
Microsoft® Windows Vista™ Home Basic 6.0.6002.2.1252.1.1033.18.2813.1486 [GMT -4:00]
.
AV: AVG Anti-Virus Free Edition 2011 *Enabled/Updated* {5A2746B1-DEE9-F85A-FBCD-ADB11639C5F0}
SP: AVG Anti-Virus Free Edition 2011 *Enabled/Updated* {E146A755-F8D3-F7D4-C17D-96C36DBE8F4D}
SP: Windows Defender *Disabled/Updated* {D68DDC3A-831F-4fae-9E44-DA132C1ACF46}
.
============== Running Processes ===============
.
C:\PROGRA~1\AVG\AVG10\avgchsvx.exe
C:\Windows\system32\wininit.exe
C:\Windows\system32\lsm.exe
C:\Windows\system32\svchost.exe -k DcomLaunch
C:\Windows\system32\svchost.exe -k rpcss
C:\Windows\system32\Ati2evxx.exe
C:\Windows\System32\svchost.exe -k LocalServiceNetworkRestricted
C:\Windows\System32\svchost.exe -k LocalSystemNetworkRestricted
C:\Windows\system32\svchost.exe -k nets... Read more

Answer:Google says my computer may be sending an automated query

Please close this post. It turns out that the website in question says the same thing to others as well.
I appreciate the time (over 50 views)spent on this, thank you :-)

Regards,

Marc

2 more replies
Relevance 62.32%

Hi!

I have recently begun getting messages from Google asking me to sign in through a CAPTCHA to prove that I am human since my machine or network is apparently sending out automated queries. I have tried:

NOD32
G Data Antivirus
AntiVir
Malwarebytes
Combofix
Spybot S&D
Ad-Aware

and haven't found anything on either machines. Being at a total loss, I decided to come here and ask for your help. Any ideas what's going on?

Also as a side issue, I used to have Threatfire on my machine and have erased it but it is still apparently there. Any clues on how to get rid of it?

Thanks!
DDS (Ver_09-09-29.01) - NTFSx86
Run by FBLAINADMIN at 0:36:09.40 on 10/10/2009
Internet Explorer: 8.0.6001.18783 BrowserJavaVersion: 1.6.0_16
Microsoft? Windows Vista? Home Premium 6.0.6001.1.1252.2.1033.18.3069.1824 [GMT -4:00]

AV: ThreatFire *On-access scanning enabled* (Updated) {67B2B9A1-25C8-4057-962D-807958FFC9E3}
SP: Windows Defender *enabled* (Updated) {D68DDC3A-831F-4FAE-9E44-DA132C1ACF46}
SP: ThreatFire *enabled* (Updated) {79E34F8F-D0AD-48d6-9223-C657C6491F67}

============== Running Processes ===============

C:\Windows\system32\wininit.exe
C:\Windows\system32\lsm.exe
C:\Windows\system32\svchost.exe -k DcomLaunch
C:\Windows\system32\svchost.exe -k rpcss
C:\Windows\system32\atiesrxx.exe
C:\Windows\System32\svchost.exe -k LocalServiceNetworkRestricted
C:\Windows\System32&#... Read more

Answer:Computer sending out automated queries to Google

Hello , And to the Bleeping Computer Malware Removal Forum. My name is Elise and I'll be glad to help you with your computer problems.I will be working on your malware issues, this may or may not solve other issues you may have with your machine.Please note that whatever repairs we make, are for fixing your computer problems only and by no means should be used on another computer.You may want to keep the link to this topic in your favorites. Alternatively, you can click the button at the top bar of this topic and Track this Topic, where you can choose email notifications. The topics you are tracking are shown here.-----------------------------------------------------------If you have since resolved the original problem you were having, we would appreciate you letting us know. If not please perform the following steps below so we can have a look at the current condition of your machine. If you have not done so, include a clear description of the problems you're having, along with any steps you may have performed so far.If you have already posted a DDS log, please do so again, as your situation may have changed.Use the 'Add Reply' and add the new log to this thread.We need to see some information about what is happening in your machine. Please perform the following scan:Download DDS by sUBs from one of the following links. Save it to your desktop.DDS.scrDDS.pifDouble click on the DDS icon, allow it to run.A small box will open, with an explanation about the tool. No inp... Read more

3 more replies
Relevance 61.91%

Im running denim, this problem has been going on for months now. It is so inconvenient.

Answer:Google saying my nokia lumia 730 is sending automated queries?

Perhaps your search option in Bing is set to Google and they don't care for Cortana searches. Email them and tell them you are not doing automated searches.
Unless a background app is doing something. Check background apps are what you expect.

more replies
Relevance 57.4%
Question: Automated Email

I have quite a question I feel. The short version is that I would like to find a way to send email using Microsoft Excel 2003 and Lotus Notes 7. In my excel file I have reminders created to show when a project or paperwork is due for certain clients. I have reminders set to show based on different amounts of days, 30, 45, 90, just a few examples. On my alerts sheet, each row is a different client and each column is different paperwork due. I have tried creating a macro to send an email when alerts in the range are present which no look. I also have a column of email addresses that I would like the reminding message to go to.

I basically want to be able to send email in lotus notes to automatically to clients with alerts. The other clients cells are blank when there are no alerts. I need each row to be sent to the corresponding email address in that row, but i need each column to generate different subjects and bodies depending on which column the alert is present in.
 

Answer:Automated Email

Hi, welcome to the forum.
Have you done a search on hhtis forum, there are quite e number of posts with answers and examples of how to trigger mail.
The only thing you will have to finc out is the code necessary to trigger Lotus Notes 7 but the web will surely privide for this.
 

2 more replies
Relevance 57.4%
Question: automated email

At my company we use a automatic emailer to send report to endusers. For some reason my reports fail to go through to my AOL email address. I will show you the message I get back. It does work with other services we've tried but not AOL or Prodigy yet. Any assistance you may be able to give will be welcomed.

----Transcript of session follows----
...while talking to zc.mx.aol.com.:
>>>MAIL From :<[email protected]>
<<< 550 REQUESTED ACTION NOT TAKEN: DNS FAILURE
554 [email protected].. Service unavailable

If there is a cure for this error please let us know. You can reach me at [email protected]

We are using a unix mail server,
also a private domain name of namdg.com.

Hope this helps.
 

More replies
Relevance 57.4%

I have a Excel Spreadsheet that currently generates a automated email through outlook. My company recently transitioned from Outlook to Gmail (our email addresses did not change). Is it possible for the spreadsheet to generate a automated Gmail? Thanks for all the help.
 

Answer:Automated Gmail Through Excel?

As per my experience you can send email via Gmail's SMTP servers using CDO - http://www.rondebruin.nl/cdo.htm
 

1 more replies
Relevance 57.4%

Have seen a few topics on here about this, and it's obviously WAAAAY out of my league.
We have a register of all our operators & drivers and all their various qualifications. I am after a way to set up e-mails or alerts to myself and 3 colleagues whenever a persons expiration of a specific qulaification comes within say, 60 days of todays date. Each person may have up to 20 different expiry dates.
At the minute, I only have a simple conditional format in place showing me Red when expired, Orange within 90 days, and Green when OK. Someone obviously has to physically check this though every day
 

Answer:Automated E-Mails from Excel via VBA

well, it sounds quite similar to the solution I gave this poster...

http://forums.techguy.org/business-applications/940910-emailing-excel-based-off-cell.html

you will need this program to click Yes for you.....
http://www.contextmagic.com/express-clickyes/free-version.htm

If your email security blocks excel from sending
 

1 more replies
Relevance 56.58%

-I have this webcam software that automatically takes pictures whenever it detects motion
-it does not support email
-how do i upload pictures automatically using gmail or some online back solution that uploads?

Answer:automated upload / email?

Batch file. Get the GDrive and transfer the pcitures from where you take the screenshot to the GDrive which will upload it to a GMail account. IT wont be able to be viewed online like they are but you can use the space.

If that doesnt work. Batch file so it uploads using the Photobucket Mass uploader or something.

6 more replies
Relevance 56.58%

Hello,

I'm looking for either freeware or shareware automated email software. I need the software to read addresse from a ascii file, excel ect., one at a time (until end of file), use the attachement file - also listed in the ascii file, then send the information to the email address automatically. This program should be able to do this until it reaches the end of the addresses in the ascii file (or other file format). Anyone know of a automated email software pkg. which can do this?
 

More replies
Relevance 56.58%

I'm a novice user of Excel 2007 at best, but as an intern at a local company, I've been tasked to figure out a way to have a pre-filled e-mail sent when one of our users presses a radio button. I would also need to send along some specific information from certain cells.

The e-mail would be going to a specific person every time, and I'd like for the employees to only have to choose "Yes" in a radio button for "Send E-mail", then have a confirmation window come up before it is sent out.

Is this possible? Does anyone have any code for a similar function?
 

More replies
Relevance 56.58%

Have attached notepad with few data. What exactly i need is listed below:

1. I have 27 folders in my desktop where all the folders contains one notepad as attached.
2. I need a excel macro file which automatically pick the notepad from desktop in that the certain folder.
3. And convert them into excel and save it in the same folder.
For eg: If folder 1 have notepad file with the name "123456", then excel file should save in the same folder where notepad was picked with the name "123456 "B" Ctns "D" Pcs". B- Countif the total "B" and Sum if the total "D"
4. Excel file should do "Text to coloumn" the data in notepad file.
Text to colomn:
*Delimited - Next
*Enable all the Delimiters excep "others" - Next
*Enable "Text"in "Column data format" for first 2 coloumn - Finish.
5.Once everything done in sheet 1.Sheet 1 should take copy of that data and save it in another sheet.
6. Coloumn "A" having a Data of "B" and "D".
7. Add one new coloumn in "A".
8. "B" is the header of "D". So Every header should come left side to "D".
For eg:
IF the DATA is
B STMEGY05066
D 12345678999 8
D 25874136987 9
B STMEGY05067
D 36982117852 10
D 78945612365 2

I need the data like below,

STMEGY05066 12345678999 8
STMEGY05066 25874136987 9
STMEGY05067 36982117852 10
STMEGY05067 78945612365 2

9. Once the above is done. then do pivot th... Read more

Answer:Automated Covertion of Notepad to Excel

16 more replies
Relevance 56.58%

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

Hi

I just started to use MS Excel and I'm having trouble entering data in one specific catalogue.

In one column in that catalogue are digits, and what I have to do is to multiply them all by certain value and then add percentage to them.

Is there a way to do it quicker then one cell at the time, it okay now but as the info building up it will become a genuine pain in the you know what...

Thanks in advance
 

Answer:Excel help - automated process, converting etc.

10 more replies
Relevance 56.58%

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

I use Outlook for email, from Office 2007 Professional because the accounting program and my Palm Pro PDA likes it.

Just recently I have had a couple of complaints that emails with a video attached I have forwarded have been delivered to the addressee in excess of 30 or 40 times.

The latest was last night when one of my sons said he had received it 104 times, and another friend in the USA 99 times, needless to say both aren't happy, the video was a wmv (3mb).

When my son called me a an hour or so later it was still in my outgoing mail box, obviously because it was still sending.

I have run full AV scan using Esset Nod32 which came up clean, so I&#8217;m at a loss where else the problem is or where/what to look for.

Thanks for reading&#8230;..Any clues/help would be appreciated.
 

More replies
Relevance 56.17%

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

Dear all,

I have the unfortunate task of going through 3 years of emails and renaming them all to include the date the email was sent as a prefix in the YYMMDD format. I was hoping that there might be a method of doing this using either windows, an additional downloadable utility or the 2007 edition of Office. The emails are in one of four formats; either Outlook Express .eml files, Outlook .msg files, or less commonly .txt or .htm files. Whilst I'm aware that there is most likely no one size fits all solution for all of these files types, anything that reduces the time needed to complete this task would be fantastic.

All help would be much appreciated!

Answer:Automated email file renaming

how do you rename the email. I'm looking at outlook right now, and I don't see how you would do this.

4 more replies
Relevance 56.17%

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

Hi the Excel Gurus here,
I have a simple requirement of comparing a huge list of names with the already existing big list of names in another excel sheet. I want the IDs associated with the matching names to be automatically transported to the first excel sheet (containg names to search) and display in adjacent columns.
To make it more clear, say I have Excel sheet A containing names
hoyle,david
singh,naveen
millette,sandra
......

Another Excel sheet contains huge list of names and the corresponding IDs, like
Column A Column B
12345 yang,minh
53478 hoyle,david
76347 khosla,honey

I want to compare all the names in Excel sheet A with the matching names in excel sheet B and want to create 2 columns for employee name and id in Excel sheet A.

Help from anybody to simplify this task would be highly appreciated.

Thanks and Regards,
Everhappy
 

Answer:Automated Excel search and data reorganization

9 more replies
Relevance 56.17%

I know variations of what I want to do exist but I have not had success in implementation. I am using Excel 2007 and MS Outlook.

After opening the file, I would like the macro to look at all the dates in the sheet and send an email (.Display is preferred) each time a date gets within 1 year, 6 months (180 days) and 90 days of the current date.

The headers in the columns are:
A-First Name
B-Last Name
C-email address

D, E, F, G, H, I, J-Certification 1, 2 ,3 etc. (All contain various expiration dates)

K-1 Year email sent. I've gathered from reading that another column indicating if an email was sent is a good idea and may be needed to trigger the other events.
L-180 Day Email Sent
M-90 Day email sent
 

More replies
Relevance 56.17%

Hello Friends,

I have a set of 7 to 8 Dispositions in a cell as a drop down. Every disposition has its own unique notes in the following cell. Assuming A1 has disposition as first in class, A grade, B grade, C grade and failed. B1 contains examination month, C1 contains percentage and d1 contains names of the students. In the last coloumn I want note for every name which should concatenate D1 "has secured" C1, "Percentage in the examination conducted in", B1, and stood first in class, if he is class first. If he failed, it should show me as failed in notes. Can I have a formula.
 

Answer:How to have automated note for multiple despositions in EXCEL

Are you looking to just combine the text from Columns D, C, and B, in that order? Or are you looking to have the cell conditionally show something based on those values?

If you want to combine the values with a space in the middle it would be something like this:

=D1&" "&C1&" "&B1

If you're looking for something else, I'll need a few more specifics. What, exactly, will be in the cells that you're going to base your conditions on? What do you want it to say if those conditions are met? How do you want the notes to be formatted? Those kind of things will help me a little further if the above isn't what you want.
 

9 more replies
Relevance 55.35%

Hello folks, I need your kind help here, before asking I've been trying once and again to get this done and I could do a 90% let's say.

I managed to build a code that retrieves certain info from certain fields and put them into a new mail message (email address, subject, customer name)

But now I need it to retrieve information from a linked subform (linked by ID)
Is there anyway to do this?

Also, VBA doesn't recognize a hyperlink type field, is changing it to 'text' type the only option?

I attach a sample of what I did if anyone is willing to lend me a hand, thanks in advance.
 

Answer:Testing automated email in Access 2007

9 more replies
Relevance 55.35%

Hello,

I'm looking for either freeware or shareware automated email software. I need the software to read addresse from a ascii file, excel ect., one at a time (until end of file), use the attachement file - also listed in the ascii file, then send the information to the email address automatically. This program should be able to do this until it reaches the end of the addresses in the ascii file (or other file format). Anyone know of a automated email software pkg. which can do this?
 

Answer:Freeware/shareware Automated Email software?

Please only post in one forum. You have another post on this subject in the Business Forum.

By posting in two different forums our members don't know what other members are suggesting and it can get confusing.

Thank you.
 

1 more replies
Relevance 55.35%

can anyone recommend a paid service that can automatically remove my company's ips from any blacklist that it pops up on? is there such a thing? id like to pay for a service to automate this process instead of having a human being doing it.
 

Answer:Automated service for email blacklist removeal

Why not simply fix the problem and submit for removal? Are you expecting to be constantly added?
 

6 more replies
Relevance 55.35%

Hello,

I have a data set that has four columns of data. Column A = Date, Column B = Name, Column C = Question Asked, Column D = Verbatims/Sentences (response to question). The data is collected from respondents imputing information for a quick questionnaire. I will be manually refreshing the sheet every day with new data as I export the data (copy and paste).

I would like to understand the step-by-step instructions on how I can create a Keyword alert system similar to Google Alerts. I vision the end-user (whoever wants to subscribe to the data) sending me an email of the keywords they would like to subscribe for (ie: the word "dog"). Whenever there are any verbatims/sentences in column D that contains the word "dog," it will automatically send an email with the full verbatim/sentence to them along with column A with the date and Column C with the question asked.

An example email would look like this:
-------------------------------------------------------------------------
Subject

New Data Alert

Message

Keyword: "Dog"

01-11-2012; What is your favorite animal?;"My favorite animal is a dog."
------------------------------------------------------------------------
How do I do this?

Any support you may provide would be great!
 

Answer:Excel Automated Alerts - triggered when data contains certain keywords...

9 more replies
Relevance 55.35%

Can anyone help me please?I'm trying to get excel to send an automated email from outlook when a due date comes about in certain cells Desperately seeking help on this Thanks

Answer:Automated emails when cells in excel are at specific date?

Try here:http://www.rondebruin.nl/win/sectio...should give you a starting point.MIKEhttp://www.skeptic.com/

4 more replies
Relevance 55.35%

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

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

Hi,l

My antivirus software is showing that I'm sending email that I'm not sending! I don't even know where it is sending from. And it is yucky SPAM headlines that it looks like it is sending. I use AVAST anitvirus. I'm on a wireless laptop running xp home. Microsoft outlook express and hotmail and gmail are the email accounts that I use.

What to do?
 

Answer:hijacked: sending email that I'm not sending

16 more replies
Relevance 52.48%

Intermittently, Outlook 2007 will crash while sending an email and, needless to say, the email is not sent. However I wanted to know if there is a temp or backup copy of that mail anywhere. I've looked in drafts and it's not there.

I've sometimes typed a very long email and then lost the whole email when Outlook crashes so I just wanted to know if, like Word, there is a temp file that may be created.

Thanks.
 

Answer:Outlook 2007- crash while sending email - where does the email go?

Hi cp, welcome to TSG. Do you have Autosave enabled for Outlook? If not, perhaps this link will help.
 

2 more replies
Relevance 52.48%

hello:
 
i have been trying to fix my email/outlook spam issue.  emails are going out WITH my actual email address, sending emails to people in my contacts, etc.
I also have been getting a ton of spam emails myself.
 
I use:
 
-Windows 7 Pro
-64 Bit
-Outlook 2010
-I have our own domain name email address, that is hosted by Frontier
 
Odd thing:  I changed my password for my email, but my outlook kept sending/receiving with the old password.
When I tried to update  the new password in outlook (which I verified by using the webmail versus outlook), it would not accept it.
 
Thank you for any help you can provide.

Answer:email / outlook is sending emails with my email address

Here is my FRST logs:
 
Scan result of Farbar Recovery Scan Tool (FRST) (x64) Version: 26-06-2016 02
Ran by LS (administrator) on LS-PC (27-06-2016 12:22:27)
Running from C:\Users\LS\Downloads
Loaded Profiles: LS (Available Profiles: LS)
Platform: Windows 7 Professional Service Pack 1 (X64) Language: English (United States)
Internet Explorer Version 11 (Default browser: Chrome)
Boot Mode: Normal
Tutorial for Farbar Recovery Scan Tool: http://www.geekstogo.com/forum/topic/335081-frst-tutorial-how-to-use-farbar-recovery-scan-tool/
 
==================== Processes (Whitelisted) =================
 
(If an entry is included in the fixlist, the process will be closed. The file will not be moved.)
 
(NVIDIA Corporation) C:\WINDOWS\System32\nvvsvc.exe
(NVIDIA Corporation) C:\Program Files (x86)\NVIDIA Corporation\3D Vision\nvSCPAPISvr.exe
(Realtek Semiconductor) C:\Program Files\Realtek\Audio\HDA\RtkAudioService64.exe
(Waves Audio Ltd.) C:\Program Files\Waves\MaxxAudio\WavesSysSvc64.exe
(NVIDIA Corporation) C:\Program Files\NVIDIA Corporation\Display\nvxdsync.exe
(NVIDIA Corporation) C:\WINDOWS\System32\nvvsvc.exe
(Realtek Semiconductor) C:\Program Files\Realtek\Audio\HDA\RAVBg64.exe
(Microsoft Corporation) C:\WINDOWS\System32\wlanext.exe
(Apple Inc.) C:\Program Files\Common Files\Apple\Mobile Device Support\AppleMobileDeviceService.exe
(Realtek Semiconductor Corporation) C:\Program Files (x86)\Realtek\Realtek Bluetooth\AvrcpService.exe
(Apple Inc.) C:\Program Fil... Read more

2 more replies
Relevance 52.48%

when i email someone at 6pm central it shows on the email that was sent 6 hours or more difference than computer time clock

Answer:email time and date are wrong when sending out email

And the email client you're using is.....?

3 more replies
Relevance 51.66%

The host 'smtp' could not be found. Please verify that you have entered the server name correctly. Account: 'pop3', Server: 'smtp', Protocol: SMTP, Port: 25, Secure(SSL): No, Socket Error: 11001, Error Number: 0x800CCC0D--------------------------this is what comes up when I try to send an email using the built in email , how can I fix this so that it works ?the reason I want to use the internal email system is because I can right click on an image and choose to send a picture to an email .

Answer:problem sending email - internal email

You have to configure the incoming and outgoing mail server of your e-mail provider.E.g. for gmail, you have to use this:Hotmail Incoming Mail Server (POP3) - pop3.live.com (logon using Secure Password Authentification - SPA, mail server port: 995)Hotmail Outgoing Mail Server (SMTP) - smtp.live.com (SSL enabled, port 25)

4 more replies
Relevance 51.66%

Using Free AVG, Windows 7, email sending out Canadian Pharmacy website and get rich quick website to address book. How to cure? No virus/problems found with AVG, Spybot or Threatfire.

Answer:Email has been hijacked. Email sending junk

Standard practice would be to change your email password. And don't tell anybody what it is.

2 more replies
Relevance 51.66%
Answer:I keep getting Email scan notices but I'm not sending any email?!

So far I'm thinking I may as well Just restore to A drive image i made 2 months ago with Ghost.. but i'd rather not Loose the changes to the OS drive in that time, Plus It is more benificial to learn to fix manually , and would be a good learning experience.

or this maybe something glitchy... dunno.. first time i've seen it and i'm stumped

1 more replies
Relevance 51.66%

Good morning, people,

One of my users here is having a wierd issue with her Outlook program...Every time she sends an email out, a .txt file of that email is sent as an attachment to that email.

So an email saying, "Greetings!", has the text file attached that says, "Greetings!".

Any ideas?
 

Answer:Outlook sending a copy of email w/email

Must be set to send in both plain text and HTML? But I thought in that case that it was done the other way around...

Turn off one or the other in the E-mail options, would be my guess.
 

1 more replies
Relevance 49.61%

hello everyone, i have created email form using incomediawebx5 software, i have uploaded the forum in my website,, all looks ok in my website, when someone/ or i try to send a email using email form just to check its working or not, after click send button, i recieve this message,
All data will be send to email [email protected] once the website is been loaded on server,

i dont know how to fix this can anyone help please
 

More replies
Relevance 49.61%

"This is an automatically generated Delivery Status Notification.

Delivery to the following recipients failed"
I only get this when i send from my long time email address a msn.com one. I cant find where to check the pop settings on this laptop or dont even know if that would work. Can you help me understand why i cant send or reply from this one address of mine, all the others work fine. just this one email address of mine that has been mine from the beginning of internet in my life.
Thank You , Nancy

Answer:Email from one email account not sending

What are you using to manage email? . . Outlook Express? . . Outlook? . . Windows Mail??

19 more replies
Relevance 49.61%

appears some virus from aol sent out messages from my email (which is on a mac computer) which were returned many of them. I don;t know what to do? I have never had this problem on my mac. SO i must assume it is an aol issue

Answer:aol virus sending email from my email

aol virus sending emails to my contactshttp://tinyurl.com/4fzb28q

2 more replies
Relevance 47.97%

Hi

I have a macro set up in excel 2010 to send emails of a range from a worksheet. Next to the button for the email macro i have a drop down button for different suppliers to bring up their products. At the moment the "email macro" only creates a new sheet for the current selected supplier and attaches it to a new email message. What I would like to do is when the mail message is created the email address for the listed supplier is added as well. The macro i am using at the moment is below: -


Sub Mail_Range()
'Working in 2000-2010
Dim Source As Range
Dim Dest As Workbook
Dim wb As Workbook
Dim TempFilePath As String
Dim TempFileName As String
Dim FileExtStr As String
Dim FileFormatNum As Long
Dim I As Long

Set Source = Nothing
On Error Resume Next
Set Source = Range("D8:S500").SpecialCells(xlCellTypeVisible)
On Error GoTo 0

If Source Is Nothing Then
MsgBox "The source is not a range or the sheet is protected, please correct and try again.", vbOKOnly
Exit Sub
End If

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

Set wb = ActiveWorkbook
Set Dest = Workbooks.Add(xlWBATWorksheet)

Source.Copy
With Dest.Sheets(1)
.Cells(1).PasteSpecial Paste:=8
.Cells(1).PasteSpecial Paste:=xlPasteValues
.Cells(1).PasteSpecial Paste:=xlPasteFormats
.Ce... Read more

More replies
Relevance 47.97%

I know this may be an obvious question, but I have a number of Worksheets in my Excel Workbook.

How do I send just a single Worksheet via e-mail?
 

Answer:Sending Excel Worksheet

It's not obvious at all. Questions:

1. Always emailing to the same person?
2. Email as an attachment? Or as part of the message body in Outlook?
3. Want a button on the worksheet?

You can check here:
http://www.rondebruin.nl/sendmail.htm
 

3 more replies
Relevance 47.97%

Is there a quick way to send the data in a Flex Grid to an Excel sheet? Right now I'm using 2 For..Next loops (one for Rows one for Cols) and it takes forever. Up to 12 secs. for 1000 lines of data. I run DoEvents after each row is sent to Excel, because I still have data coming in that I can't miss. I tried doing a cut and paste using Clipboard, but that placed the entire FlexGrid in the first cell of Excel.
 

More replies
Relevance 47.97%

I have created an invoice using Office Excel.

As a test I sent it to own e-mail address.

The problem I have is when I received it, it was sent directly to my deleted folder.

I have both Norton Anti Virus and Internet Security installed on my PC.

Could these two programs have anything to do with it???

Thanks
 

Answer:Sending Excel Worksheet

8 more replies
Relevance 47.97%

In Excel, I hit the email button to send a spreadsheet to other people. When they receive it, the rows of the spreadsheet are kind of squished. How can I unsquish?

Answer:Sending Spreadsheet from Excel

How are you mailing it?File > send to > Mail recipient (as attachment).Noldi

10 more replies
Relevance 47.97%

Hi all,
I am trying to write a spreadsheet to be distributed across a number of site. Once the info req. has been entered into the spread sheet, as the level of knowledge of the users will be negligable.

So I want to put a button, or a text box on the sheet that will save the file, open a mail, & attach the current file, simply leaving the user to click send. simply by clicking the button/text box.

I have set up a user file that opens a new mail, but thats as far as i've managed to get.

I can open the mail, but i can't find a way to attach the file. can anyone help.

Paul
 

More replies
Relevance 47.97%
Question: Sending email

I have XP and use sea monkey 1.0.6 for browser and mail. I have a question.

When sending email is it better to send in plain text and HTML
or send in plain text only
or send in HTML only
I have always sent in plain text only but my daughter tells me I should send in plain text and HTML.
Any suggestions would be appreciated. Thanks
 

Answer:Sending email

I would say that most people have it set to plain text........
 

2 more replies
Relevance 47.97%
Question: Sending email

Although my email does get sent eventually (Sometimes not at all), this message keeps appearing: Task 'pop.mail.yahoo.com - Sending' reported error (0x800CCC0F) : 'The connection to the server was interrupted. If this problem continues, contact your server administrator or Internet service provider (ISP). The server responded: 553 From: address not verified; see click here'I don't believe that coincidentally the server is interrupted everytime I use the internet. Can anyone explain this?Thank you in advanceErch

Answer:Sending email

click herebretsky ;0)

1 more replies
Relevance 47.97%
Question: Sending email

When sending an email from OE, above To:, Cc: and Bbc:, there is a 'from'.
How to remove this 'from' from there.
Thank You!
 

Answer:Sending email

Hello, If you select view at the top of the screen then untick the from box. That should do it.
 

1 more replies
Relevance 47.97%
Question: Sending email

I have read several discussions of error 0x800ccc60 when sending emails with either Outlook or Thunderbird, but none solves my problem.
I have several email addresses and access all at home, using my ISPs SMTP server to send emails.
When trying the same approach in another location, I get the above error. I have tried switching off the AV and changing the port from 25 to 587, but nothing seems to change.
 

Answer:Sending email

With most ISPs you can only send when using their smtp server, so if in another location just change the server to that of the local ISP. Receiving is OK though.
 

8 more replies
Relevance 47.97%

Previously i was helped with code to send a static email through outlook express. Which work perfectly in my home network but when I took it to my work network I could not get the emails to send. Here is the code that worked at my network at home:
Code:
Public Sub Email()

Dim iMsg As Object
Dim iConf As Object
Dim WBname As String
Set iMsg = CreateObject("CDO.Message")
Set iConf = CreateObject("CDO.Configuration")

With iMsg
Set .Configuration = iConf
.To = "[email protected]"
.CC = ""
.BCC = ""
.From = """test"" <[email protected]>"
.Subject = "test"
.TextBody = "message"
.AddAttachment ""
.send
End With

End Sub
The only major difference that is obvious, is the email at the office requires SPA where as my home network does not. Any thoughts Would be great!

Eric
 

Answer:Sending Email through VBA

Does your work server allow email relaying? Did you have an SMTP server running at home that sent the email?
 

3 more replies
Relevance 47.97%
Question: Sending email

I have moved and just signed up with MSN through Qwest for sending my email. I would still like to use outlook express as well for sending email. I need help on the POP3 addresses
 

Answer:Sending email

6 more replies
Relevance 47.97%
Question: sending email

I am using outlook 2000. When I build a new email to send I would like to be able to send it to my out box, not automatically send to the recipeint. Does anyone know how to do this.
 

Answer:sending email

In Outlook Express, you can set it up to do that, but I don't think Outlook will let you. With O/E, there's a choice somewhere in the Options that says "Do not send mail immediately," but I found no such feature in Outlook.

JP
 

1 more replies
Relevance 47.97%

Hey all,

I keep getting e-mails from various places saying that I sent them an e-mail with the "sobig" virus. Problem is, I'm not sending anything. I've downloaded all the patches that I know of, Norton Anti-Virus runs every night and doesn't find anything. Does this mean I have the virus but Norton doesn't find it? Why is my email sending things to people I don't even know? How can I make it stop?

Thanks,
PaveFE
 

Answer:Email sending by itself

11 more replies
Relevance 47.97%

My contact is on XP Home and Outlook Express. When she sends an email, I get more than one - she sent one at 8:37 pm, so far I've had 26 and they're still coming.Is this something simple? It's only just started.

Answer:Same email keeps sending

Start by checking the following -Have You UNCHECKED 'Leave Copy Of Message On Server' ?Leaving them on the server for any length of time can cause such duplicated mail receipts.Open Outlook, click on "Tools", choose "Email Accounts", choose "Change or edit and existing account", highlight your POP3 account, then click on the "Change" button.. When that opens, click on the "More Settings" button, then the "Advanced" button. UNCHECK the box that says: "Leave a copy of message on the server". OK and Apply your way out.Hope this helps.click here

7 more replies
Relevance 47.97%
Question: Sending Email

Hello!

I can't send emails with attachments but emails without send just fine. I can also recieve emails with attachments.

Please help asap!

From HelpMe234
 

Answer:Sending Email

How big are the attachments? What email program?
 

1 more replies
Relevance 47.97%
Question: sending email

If I send mail to someone how do I know if it gets through even though they may not answer ??
 

Answer:sending email

Hi

Depending on the email software you are using you could enable a delivery reciept, not knowing which application your using to send mail cannot give direct steps, in Outlook you can click New Email > Options > Request Delivery Reciept, (only way I know of knowing if the email got to the other email server and correct address if real)

But in many other applications this is not possible, although in some you can ask for a Read Reciept, but this doesnt mean the recipient has to actually click yes.

eg. Windows Live Mail is New Email > Tools >Rrequest Read Reciept


Dont off hand know other email applications without searching for info on them, so if you tell us what application you're using we can asssit.
 

3 more replies