Computer Support Forum

Excel VBA to automatically send out an email.

Question: Excel VBA to automatically send out an email.

I am new to excel VBA and am just about realizing the vast capabilities of coding.

I have created a spread sheet that contains delivery dates. I want to automate an email 7 days in advance 2 days in advance and the day of delivery. The less action required to initiate the macro the better. I tried tweaking some codes found online but to no avail. I'm surrendering to anybody out here that can help me accomplish this task.

I've attached an image of my sheet with column J being the delivery date to reference. The mailto list can be encoded in the VBA editor. Once the email is sent it shouldn't send again. In addition the may be a few blank rows before there is a row with more dates in them. I would need it to pass over the dashed rows and continue to the next row with a date.

Any and all help is greatly appreciated,
Thanks in advance.

More replies
Relevance 100%
Preferred Solution: Excel VBA to automatically send out an email.

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

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

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

Relevance 89.79%

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

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

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

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

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

We will then change the next contact date once completed.

Any help would be appreciated!

Thanks
 

More replies
Relevance 88.97%

Hello to everyone that reads this post.

I have seen several threads on this request, and have not been able to see exactly what I have been looking for.

Below is what I am looking for:
we will receive emails from one of our departments indicating that, what we call a disclosure, occurs. It is our responsibility to do the research on the cause, and email back our findings. Each of these requests have a due date. We have started to create a log to help keep track of these disclosures so that we can respond by the due date. I would like to make this easier by having an email sent that has not been completed. I have attached a spreadsheet as a sample, everything is fictitious. As you will see on the sheet, there are several data elements that are recorded. The fields that I want to have looked at to determine the criteria for sending the email is due date and email sent date. which is columns O & P. I would like to have an email sent automatically each day whether we open the sheet or not, that has a due date but not a date in the email sent column P.

An added piece but not necessary is to have sent in the email is that there are x amount of days left til the due date and/or it has been x amount of days past the due date.

I would appreciate any assistance, and if you need further clarification please don't hesitate to ask
 

More replies
Relevance 88.97%

Hi everyone,

I'm new here, and kind need your assistant on this spreadsheet. Been searching all over from this forum but non are helpful.

As attached, I created an excel workbook and would like to have excel AUTOMATICALLY send to me and other colleagues as well a reminder to Outlook email which the password going to expire soon WITHOUT opening the workbook. Is it possible?

Can someone help me on this ? as I don't have much exp on VB. Thanks!
 

Answer:How Excel AUTOMATICALLY send alert to email when is duedate

May be this thread is what you looking for http://forums.techguy.org/business-applications/574148-e-mail-cell-data-excel.html
 

1 more replies
Relevance 87.74%

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

HiI am hoping someone will be able to help me with the followingI am trying to write code that will send an email automatically when 2 conditions are met in excel. The first condition being, is this, does the required until date = todays date and the second is, = Not sent. The criteria is, if "= today & Not Sent send email" and then change to Sent also add names to body of email that require access removing, otherwise do nothing.I have my names in Col D , Not Sent/Sent in Col F & required until date in Col H. I have been trying to adapt the code below that I found online which by the look of it many others have found like the chap asking a similar questtion in this forum and like him am stuck. Unfortunately, it uses a numerical limit instead of the criteria I would like to use. It's currently set to send an email as soon as a number is = to or > is reached in a particular Col which before i started making changes was 200. the code is pretty near what i would like now i have made changes but i am a real novice at this and not sure how to address it. I have got it to a stage where it produces the email and can manually input the names to remove but that is all i dont know where to go with the rest i require.Many thanks in anticipation of your helpMy Data Col D Col F Col HCustomer Name System Required Email Sent Raised On Required UntilPete Hughes UAT ... Read more

Answer:How To Automatically Send Email When Conditions Are Met

Sorry I did edit the data so it was readable but on submitting has got scrambled, have i done something wrong.

4 more replies
Relevance 70.11%

Hi Everyone,

I am using a Windows 7 computer and I would like to install some software to automatically send a specific email once a week. I am not always at my computer so putting a reminder on my Outlook isn't going to work for this. I was using Gmail to do this, but recently they removed the feature.

Kind Regards,

Davo
 

Answer:Automatically send an email once a week

Did you try Boomerang?
 

2 more replies
Relevance 70.11%

I got some amazing help from bomb #21 to put together this awesome sheet.

I would like to now implement it on a much larger scale. Currently it produces emails when the button is pushed (macro is run) and on each email you need to click the send button. Is there any way to automate this so it sends the mail directly without needing to click the send button? I would prefer to bypass the visible generation of emails at all vs. having a macro that presses the send button.

There will likely be 40-100 emails generated each day.

Or is there even some Outlook 2007 function that will automatically send all emails that are currently open?

Thanks for any help!
 

Answer:Excel send emails automatically without prompts

16 more replies
Relevance 69.7%

I have accumulated over 1000 email drafts. I am now ready to send them to recipients.the idea of clicking and sending these emails one at a time is daunting. Is there a way for Thunderbird to automatically send these "ready to go" emails within my draft folder? If so, how is this done?Thanks,Vince

Answer:thunderbird how to send draft email Automatically

Check Mozilla's site. There may be an add-in for that. Or, you can click "Send" when you generate the email. :)

2 more replies
Relevance 68.88%

there are many ways to send photos from phones/cameras to email accounts
 
but these require a lot of fiddling: you have to
 
1. save the photos you have just taken with the phone or camera
 
2. then you have to open the email account through your phone
 
3. then you have to browse for the photos and include them as attachments to email messages.
 
I am looking for an app that can send copies of photos immediately from phone to email account
 
This could be preferably a smart phone but could be a digital camera
 
I would be grateful for any ideas on this.
 
P.S. Skype (Microsoft) recently shut down Qik, which is what I was going to us.

Answer:send photos automatically from camera/phone to email

What OS phone or devices do you have? There are different apps for each operating system but a camera will depend on what it supports.

0 more replies
Relevance 68.88%

Hello,I got a macro online for sending emails given a condition. It works great if you have 1-2 entries that require email sending based on the condition set. But when it sends up to 10 mails daily to the same person it becomes kind of annoying.I will post the macro I use below, but first I want to say what I would like to do and don't know exactly how (I am a beginner at VBA language):--> I want to modify the macro so that for multiple entries as per the condition, it sends only 1 email with all the entries specified in body.The columns are:A - name of the person to send email toB+C - email and CC emailD - condition, if yes send email, if no don'tE - company nameF - current no.G - sector to be auditedH/I - date to begin / end auditJ/K - days left until beginning / end of the auditL - audit done: if yes, column D becomes no and greenAnd here is the macro I use:Sub audit()
Dim OutApp As Object
Dim OutMail As Object
Dim cell As Range
Application.DisplayAlerts = False
Application.ScreenUpdating = False
Set OutApp = CreateObject("Outlook.Application")

On Error GoTo cleanup
For Each cell In Columns("B").Cells.SpecialCells(xlCellTypeConstants)
If cell.Value Like "?*@?*.?*" And _
LCase(Cells(cell.Row, "D").Value) = "yes" Then
Set OutMail = OutApp.CreateItem(0)
On Error Resume Next
With OutMail
.To = cell.Value
.CC = Cells(cell.Row, "C").Value
.BCC =... Read more

More replies
Relevance 68.47%

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows XP Professional, Service Pack 3, 32 bit
Processor: Intel(R) Core(TM) i7 CPU Q 740 @ 1.73GHz, x86 Family 6 Model 30 Stepping 5
Processor Count: 8
RAM: 3261 Mb
Graphics Card: ConfigMgr Remote Control Driver, 512 Mb
Hard Drives: C: Total - 238064 MB, Free - 186932 MB;
Motherboard: Dell Inc.,
Antivirus: VirusScan Enterprise + AntiSpyware Enterprise, Updated: Yes, On-Demand Scanner: Enabled

I am becoming somewhat familiar with macros and I have done some extensive search but I still need help to automatically send alerts from an excel cell to outlook or desktop.
 

Answer:automatically send alerts from an excel cell to outlook or desktop

Hi welcome to the forum,
You don't tell much like which version of Excel you're using or what triggers actions, etc. etc.

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

I suugest you check the link I have attached and I'm sure your answer is there.
 

1 more replies
Relevance 66.83%

Situation:

I have a domain, let's call it mydomain.com, and a whole bunch of domain email aliases (eg: [email protected], [email protected], etc) that all forward to my ISP pop3 email address account (default account).

I currently have rules setup so that emails sent to certain aliases at mydomain.com (which all come into my IPS email account) go to their associated folders setup in Outlook 2000, eg: [email protected] goes to the "Jim" folder, [email protected] goes to the "Mike" folder, etc, etc.

I also have a LAN email account setup in this copy of Outlook 2000 (although it's not set as my default). Emails on my LAN account use a virtual domain name to send within the network, let's call it mylanaccount.com.

Rather than have the emails go to folders on my computer, I'd rather they be forwarded on to the relevant address on our LAN, eg: emails that came in from [email protected] would be forwarded to [email protected].

Of course because mylanaccount.com is a virtual domain that doesn't exist in the big wide internet, these emails need to be forwarded on using the LAN account, not my default ISP pop3 email account.

Queries

1) Ideally, I'd like to setup a rule with something like:

Check messages when they arrive.

Sent to people or distribution list.

"Forward it to people or distribution list using the specified account"

Of course this last option does not exist. You can only ch... Read more

Answer:Outlook 2000 - automatically send email using specific account based on contact used.

1b. & 2b.: Doesn't look that way here in Outlook 2003. Have you thought about spending $7 to 9/month per person and get an Exchange Server hosting account?
 

3 more replies
Relevance 66.83%

I'm on Windows 2000 using Outlook Express. I have 2 email accounts. They were both working fine for ages then suddenly they stopped sending emails. I checked the configuration and when I clicked on 'Accounts' and 'Servers' I found the pop3/ smtp lines had been changed to a list of numbers! and my user name had extra characters. For example, it changed from smtp.freeserve.com and pop.freeserve.com to 127.0.0.1 on both lines. and the user name changed from MYUSERNAME.freeserve.co.uk to [email protected]

To begin with I changed these back on both accounts and mail would send ok. However it now does it every time i open outlook express, and mail is not sending despite me correcting the settings!!
please help!!
 

Answer:Outlook Express - can't send email, server details automatically change to numbers!!

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

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

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

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%

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%

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%

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

Hello,

I have an excel workbook file on a shared drive that multiple departments update daily. I need to figure out a way to have that file emailed to a list of people daily at a specified time.
I have tried a couple codes in MVB from other forums but they are not exactly what I'm needing.

-Thank you
 

More replies
Relevance 64.78%

I have an equipment list and I would like to be able to be prompted 1 week prior to the date that my calibrations are due without having to remember to check all the time.Can you please help me set it up so that an email alert can be sent saying that a certain piece of equipment is due for calibration within 1 week.

Answer:how to get excel to send me an email when a due date arrives

I have only minimal skills with Macros but see if this site gives you some ideas:http://www.rondebruin.nl/win/sectio...MIKEhttp://www.skeptic.com/

6 more replies
Relevance 64.78%

Dear All,

I would like to seek your advice to find out a solution for the below query:
Daily I would be having plenty of documents on hold which I need to intimate to respective people for the reasons on the same : so…..
Every time I need to send an e-mail for these, so I wanted to create macros for sending an e-mail for the excel on their respective documents like:
Dear Sir/Madam,
You’re so and so document and code no is on hold due to the “reason”, please provide us the clarification to process further
Data is like below

A B C D
Doument # Code Reason fo hold E-mail id
12 1 Due to Mismatch [email protected]

13 2 Wrong doc [email protected]

15 3 amount mismatch [email protected]

17 4 Wrong Details attached [email protected]

19 5 Wrong person details [email protected]

21 68 Due to Mismatch [email protected]

23 455 ddsss5 [email protected]
Please provide us Macro code for the same ,
Thanks in advance
Your’s friends
 

Answer:send email from excel to multiple recipients

6 more replies
Relevance 64.78%

Hi.

I have attach the sheet

Need your help on auto sending of email from the excel via Lotus note.
I have my data in excel which has Email ID to whom I need to send an Email. with subject in one column and Body of the message in one column.

I need to send email every day as per today date, by refering the cell B1 which has (Date) Today ().
Then accordingly I need to go to the Col "E" which has the Email Date as heading, I need to sort todays date from the Email Date, and send email accordingly to the respectively persons in that row( I have mentioned only email Id of the persons in Col "C" & "D").

Now what I want is,it should sort the date for the Email Date by refering the cell B1 (means according Today() date in B1).
I have created 2 Buttons one in the Cell C1 & the other in Cell D1 What I want is when I click on Button "First Name Contact" it should send auto email to that respective person email id in that column/row along with the subject and body of message which is in column F & G.
And when I click the other button "Both Contact Name from column E & F" it should send auto email to both persons email id in column/row C & D along with the subject and body of message which is in column F & G.
I have Lotus notes installed on my system and I'm using excel 2003 version.
I would appreciate if you could help me on this as I'm not familier to coding.
 

Answer:Send email from excel via Lotus notes

16 more replies
Relevance 64.78%

Hi there,

I am looking for a way that Excel can automatically generate an email alert for my colleagues that is triggered by data in my Excel file. I haven't generated the Excel file yet as the advice you give me may have an impact on how I go about it. Basically, the database will be a record of marketing activity we have undertaken as a company and will include dates for us to complete follow up actions. If possible, I would like for an email to be generated when todays date matches up with the follow up date. This should go to the staff member whose details are against that entry.

I hope this makes sense!

I have seen a previous thread which appeared to be on the right tracks, but it has been closed so I can't see the outcome!

Many thanks,

Carly.
 

Answer:How to make Excel send email alerts

16 more replies
Relevance 64.78%

0down votefavoriteCould you please help me to automatically send an email from Excel only when the formula value in column M (=IF(VAL.EMPTY(K15);"";MAX(K15-Today();0))>200. Unfortunately the Sheet1 code triggers the email code if the condition is met (>200) in formula value cell in column M if the date in column K is altered manually or by writing manually Not Sent in column N. Instead my goal would be: 1) to understand why this code in sheet1 doesn't send the email automatically as supposed to do (the only thing it does is to put Sent in column N without sending the email. This make me think that this code works) 2) to find the way to send the email automatically without changing anything manually in the cells in my sheet1. H I J K L M N Date Score Description Next Due Status Days till expiration 15 28/09/2017 13 Medium Risk 25/07/2018 Valid 284 Sent 16 11/10/2017 13 Medium Risk 10/08/2018 Valid 300 Sent 'Sheet1 (FormulaValueChange)Private Sub Worksheet_Calculate()Dim FormulaRange As RangeDim NotSentMsg As StringDim MyMsg As StringDim SentMsg As StringDim MyLimit As DoubleNotSentMsg = "Not Sent"SentMsg = "Sent"'Above the MyLimit value it will run the macroMyLimit = 200'Set the range with the Formula that you want to checkSet FormulaRange =... Read more

More replies
Relevance 64.78%

Send Email from Excel when cell is populated.

I have no knowledge of VB, but know that this is possible based on other threads and limited articles that I have read.

Can anyone provide me with the script to send an email out of excel when data (date) is entered into column Q or R or T of the attached sample spreadsheet? A prompt to send the email including text that the field has changed as well as text from column G & H would be great.

Whatever help you can provide would be greatly appreciated.

Thanks.
 

Answer:Send Email from Excel when cell is populated

Hi, welcome to the forum.

Check out the post created by mightybekah. I put some VBA code in the sample file which when modified to your needs will work for you.
Try it and if you still have any issues just post.
 

1 more replies
Relevance 64.78%

Hello folks. Just a general opinion required at the moment, please. I might need to create something to monitor due delivery dates against actual delivery dates. It's pretty easy to use an Excel wbook and conditional formatting to highlight late deliveries, but what I'd like is an automated email sent to a couple of relevant people as soon as an item becomes late. That also might not sound too hard, but what I think might be a problem, is this. Is there a way for this to happen even if the program is not currently open and running? And would this sort of thing be easier to achive in Access or Excel? (Assuming it is possible at all)Thanks

Answer:Excel or Access to auto send email

If the program is not running, then that's it. The only thing I can suggest is that you run the program automatically using Schduled Tasks.

5 more replies
Relevance 64.78%

Hi there,

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

The password for the spreadsheet is Kalibratedbyme (capital K)

Best regards and many thanks!
 

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

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

3 more replies
Relevance 63.96%

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

Hi there,

I am using Office 365 Excel 2013, but we do not have access to the Cloud features. I think we are on
Windows 7.

What I am trying to do is create a spreadsheet for our managers to check off when a task has been completed. When they check the forms control box, the forms control box in B17 is assigned to say M17 and the word TRUE populates M17. The other form boxes are relative to the "results" cell. (Note if there is not check in the forms box then the "results" cell is either FALSE or is blank). Once all the boxes are checked, I want to change the cell color of A16 (title Accounts Payable) to green and generate an email notifying me saying Accounts Payable tasks are complete.

Here is a sample - I have also uploaded a copy of the excel document.

I realize that the email being sent out takes VBA programing and I think I have an example of this but haven't tried it yet. Is what I want to do possible? Is there a better way to go about doing this?

Thank you for the help.
 

Answer:Excel count true statements then send out an email

Are you still looking for a solution to this?

It seems possible. If you have any code (even if it's not working), please share it. Additionally, it sounds like the real bulk of the code is going to come from sending an email. The rest of it pretty much seems done or seems like one line of code.

How do you plan/want the email to be sent? What email program are you currently using on your computer? I would assume Outlook since you have Office, but not sure.

It also seems like other people are accessing this file. Is it stored on a network folder and everyone accesses it that way?
 

2 more replies
Relevance 63.96%

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

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

Code:
Public Sub email()

Dim SubJ, Recip As String

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


ThisWorkbook.SendMail Recip, SubJ

msgbox "Email Sent"

End Sub

 

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

6 more replies
Relevance 63.96%

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

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

I have a list of associates (14) that require taking company regulated courses throughout the year. I first would like the cell to change colors based on the date, i.e.: 1 week before, date it is supposed to complete and 3 days late. I also need to send an email (Lotus Notes) from my excel spread sheet, to the associate on the day it is supposed to have been completed. I aatached the file, thank you for your help.
 

More replies
Relevance 63.96%

Okay - here goes... I know I have seen a few questions similar to mine but no final answers.

I am trying to send a mass email to my distributors - approx 100 of them. I have their names, log in ID's and email addresses in an excel spreadsheet.

What I am trying to do is have the email for letter pull the info from the spreadsheet, put it in the email, and send it out but personalized to each person/company.

Fro example, I need it to pull XYZ co from the list, use their email address to send it to them, insert their contact name in the "Dear so & so" part of the letter, pull their ID for the log in from excel and place into the email, and send it out personalized with each companies info.

PS - If you give me programming info like some of the other posts showed - I need to know where do I put it/enter it etc? I'm not all that knowledgeable on this stuff but need to figure out how to make it happen.

Thanks in advance!
irishki
 

Answer:How to use Excel Sheet to send personalized mass email

http://spreadsheetpage.com/index.php/tip/sending_personalized_email_from_excel/
 

3 more replies
Relevance 63.96%

Hello ,

I have one excel file with one column with expires date.
I want script or something else to check every day this excel and if one cell is small than 10 then
run a batch file (i have it) with blat emailer (command line emailer) to send me email.
Is it possible ?
 

Answer:Script to check column of excel and send email.

16 more replies
Relevance 63.96%

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

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

desantisj
 

Answer:Excel 2007 Macro to Send Reminder Email

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

2 more replies
Relevance 63.96%

I've read the previous post with the same issue, but I'm unable to understand how to use the other codes posted within my product. I would like to send an email based on a date. I will attach my document so it is easier for me to explain the requirement. Columns L37-L45 have due dates - I would like the email to be sent 60 days prior. I have posted some mock emails in R37-R45 and the email message in the EMAIL workbook tab. Any assistance would be greatly appreciated.

Thank you so much!
 

Answer:Auto send an email based on date in Excel

Welcome to the board.
I've had to save it as 2003 version but the code works under 2007

See attached my copy of your sheet with the code in ThisWorksheet module.

This just a simple way of doing it and you will have to edit it for your needs but maybe it can put you on the right track.
 

2 more replies
Relevance 63.96%

I have read this thread http://forums.techguy.org/business-applications/775756-how-use-excel-sheet-send.html. I am looking to do the same thing but withh Outlook. What must I do differently?

"Okay - here goes... I know I have seen a few questions similar to mine but no final answers.

I am trying to send a mass email to my distributors - approx 100 of them. I have their names, log in ID's and email addresses in an excel spreadsheet.

What I am trying to do is have the email for letter pull the info from the spreadsheet, put it in the email, and send it out but personalized to each person/company.

Fro example, I need it to pull XYZ co from the list, use their email address to send it to them, insert their contact name in the "Dear so & so" part of the letter, pull their ID for the log in from excel and place into the email, and send it out personalized with each companies info.

PS - If you give me programming info like some of the other posts showed - I need to know where do I put it/enter it etc? I'm not all that knowledgeable on this stuff but need to figure out how to make it happen.

http://spreadsheetpage.com/index.php/tip/sending_personalized_email_from_excel/

Thanks for the info - that looks like exactly what I need ! Your awesome!
One more question tho ( please don't laugh me out of here)
Where do I enter the VB programming to make it happen - in Outlook?
In the email itself? In Excel?

With the workbook open in Excel, press ALT+F1... Read more

More replies
Relevance 63.96%

In Excel 2010 I use the Review tab to hit the Mail button which opens my Outlook-attaches the spreadsheet and sends the email with the Spreadsheet successfully. However there is no message text in the body. No matter what I type (e.g. Mary, how are you today?) it just sends a blank email with a good attachment. Any ideas?

More replies
Relevance 63.96%

Basically, I have created a very simple Excel spreadsheet as an example, but what I would like to do is the following:

I have several employees (100 +/-) that require training in various fields. Each training certification is good for 1-yr. I am trying to figure a way for Excel to automatically send an email to my Microsoft Outlook whenever that training date is set to expire. I would like to have it email me 30-days before it expires. The problem is that I don't record and notate it by the date the training expires, but rather by the date they were trained. An example would be that I trained someone on 5-3-13 and they will be expiring 30-days from now. I have it entered on the spreadsheet as 5-3-13. How can I make Excel automatically generate an email warning me of the upcoming expiration date? I am admittedly not very proficient in computer language, but I am more than willing to learn.
 

Answer:Trying to send automatic email notification from Excel 2010

6 more replies
Relevance 63.55%

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

Hi Everyone!

I need your help in sending automated email and text message, when the due date of a PO is a week away from the current date. The script should preferably run automatically every time the PC is running without the excel file necessarily open.

In the attached excel file, An email should go of to -email address (Col. E), with subject "PO (Col. A) is due on Delivery date(Col. C)", and body "Vendor (Col. D), please update your project status".

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

I have scoured the forum for similar problems, and although I found most of threads using Outlook only (my default email is Mozilla thunderbird),I am not proficient enough in VBA to modify them to my needs.

I'd really appreciate any help,

Thanks
 

Answer:Send email reminders thro Thunderbird from Excel sheet

16 more replies
Relevance 63.55%

Hi Friends,

I wonder if anyone can give me some instruction on how to send through Excel an email with an HTML file as message body.
I tried something out but does'nt recognize the html but placed it in the body message as text.

I know how to send email and even how to send it with a spreadsheet as message body, but an HTML message body would give me much more flexibility.

Thanks a lot,
Elad.
 

Answer:Send email (Excel VBA) with HTML file as message body

elad11 said:

Hi Friends,

I wonder if anyone can give me some instruction on how to send through Excel an email with an HTML file as message body.
I tried something out but does'nt recognize the html but placed it in the body message as text.

I know how to send email and even how to send it with a spreadsheet as message body, but an HTML message body would give me much more flexibility.

Thanks a lot,
Elad.Click to expand...

Welcome to TSG.

I recommend you attach a excel in the attachment, it's the way we can do.
 

1 more replies
Relevance 63.55%

I am working with the attached spreadsheet in Excel 2010 and am trying to figure out how to code certain parameters that will make Excel send myself, my client or other individual an email (with text in body) if certain dates have not been entered into particular cells, or if a cell has exceeded a certain number of days in a particular cell. I have attached a sample spreadsheet and have listed at the bottom 8 points in which I need an email sent, what the trigger is and what the action (email sent to) is.

I just know enough to be very dangerous with Excel but have found that there is a way to code in Excel to send emails which would greatly help my business but I just don't know that much about codes at all.

Can anyone please help me??

Thanks!!
 

Answer:Excel Coding to Send Email based on Cell Entry

Hi, welcome to the forum.

I suggest you do a find in the forum, there are many posts that gao about this and there are many answers, I'm sure there is one that will help yu and of course one of us can help you if you're still stuck
 

2 more replies
Relevance 63.55%

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

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

System: Windows Vista and Microsoft Office 2007

When I Right-Click an Excel file, go to Send To, then select Mail Recipient, to send it to an email addressee, as I type the first characters of the address it automatically fills in a previously deleted email group. I have deleted an Outlook Email Group and renamed and restructured it, but the system keeps inserting the old deleted entry. Since the separate addressees are still in the system, it remembers and inserts them via an erased group. Its memory is too great! How can I purge this from memory and utilize the “New, Improved” email groups? Lastly let me say, “Thank you” in advance.
 

Answer:Email; Excel (Right Click) “Send To” – “Mail recipient” problem

Hi BudParker

Outlook automatically inserts, the e-mail group, in the To: field? It doesn't give it as an option in a drop down list?
If it is appearing in a drop down list, try hitting the Delete key, when the e-mail group is highlighted.
The autocomplete list is stored in an .nk2 file for Outlook 2007.

http://www.slipstick.com/config/backup2007.asp
 

2 more replies
Relevance 63.55%

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

Answer:Excel worksheet to send auto email reminder to clients

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

2 more replies
Relevance 62.73%

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

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

Folks,

I did a Panda Scan recommended by one of the experts
on this forum, and it reported that it found some infected
(containing malicious code)
Java applets/files on my system.

I then did a Google search for this worm "Exploit-ByteVerify"
and found the following article
http://vil.nai.com/vil/content/v_100261.htm

which seems to suggest that this vulnerability can cause
malicious code to run on one's machine, and that it affects
Outlook Express (this is the mail agent from which all of my
returned junk mail is apparently coming from).

I then took the following actions:
i) Went to the following Microsoft page to read up on this,
and updated my Microsoft VM build to 5.0.3810 (I had
.3805 installed)
http://www.microsoft.com/technet/treeview/default.asp?url=/technet/security/bulletin/MS03-011.asp

This is supposed to plug the vulnerability.

ii) I did not install Microsofts Extended Email Security Patch for Outlook 2000 in Win2K described below
http://office.microsoft.com/Downloads/2000/Out2ksec.aspx

because it seems to prevent one from getting all sorts of
normal extension files, and is an irreversible process!

The questions I now have are the following:

i) I assume one would still have to delete/fix the files Panda found
(I hadn't selected automatic fix in the first round)

ii) Does anyone know how to check if infected email is going out
of one's system??
(I certainly don't have any emails in the Sent folder of my
Outlook Express, but then... Read more

Answer:Can "Exploit-ByteVerify" worm automatically send email from one's computer?

Hi Folks,

Wondering if any of the experts has a thought on this
note?

Thanks.
 

3 more replies
Relevance 60.68%

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

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

Did not find answer when I searched.I have Windows XP Home Edition, SP2, and IE6, SP2.When I go to a web site and click on File, Send page by email or Send link by email, I get the message box entitled Enter Network Password, asking for user name and password.   How can I get it to go right to the Hot Mail message box so I can send?   In Tools, Internet Options, Programs, the Email section shows Hot Mail, so it should go right to Hot Mail.If I change the Internet Options, Programs, Email section to Yahoo Mail, instead of going to my Yahoo mail, I get a message box with the title Microsoft Exchange Setup Wizard, but it should take me to my Yahoo Mail.Anyone know how I can fix these two to work right?   Thanks much.Anna Ruth

Answer:File, send page by email, send link by email

Since you are using web client based e-mail it won't do this automatically...Copy and paste the links into Hotmail and it should work fine...

1 more replies
Relevance 57.4%

Excel 2007 Send email "message has not been Sent"
I'm having a major problem with excel sending an attachment as and email.
I go to send email and it opens up a new message with the worksheet attached. Above the send button it says "this message has not been sent."
Next I select the person it is going to...and hit send.
The email box never closes and the message still says, "this message has not been sent."
But the email goes through to the person. The issue is that you really don't know if it sent because the box does not close or say it has sent.
Any ideas on how to fix this?
Thanks
 

More replies
Relevance 57.4%

I'm having a major problem with excel sending an attachment as and email.
I go to send email and it opens up a new message with the worksheet attached. Above the send button it says "this message has not been sent."
Next I select the person it is going to...and hit send.
The email box never closes and the message still says, "this message has not been sent."
But the email goes through to the person. The issue is that you really don't know if it sent because the box does not close or say it has sent.
Any ideas on how to fix this?
Thanks
 

More replies
Relevance 53.3%

I have a Nokia Lumia 521 windows phone running windows 8.1 on which I have a few separate email accounts to manage. I am repeatedly receiving send error messages when using a non-gmail account, (outlook.com, mail.com). I've tried re-starting the phone, cleaning the cache, deleting messages from folders, but the results, if any are short-lived and unsatisfactory. Any suggestions or a fix would be welcome. Software version is Lumia Cyan
Phillip in CO

More replies
Relevance 53.3%

Tech Support Guy System Info Utility version 1.0.0.4
OS Version: Microsoft Windows 10 Home, 64 bit
Processor: Intel(R) Core(TM) i5-2410M CPU @ 2.30GHz, Intel64 Family 6 Model 42 Stepping 7
Processor Count: 4
RAM: 4010 Mb
Graphics Card: Intel(R) HD Graphics 3000, 1813 Mb
Hard Drives: C: 582 GB (515 GB Free); D: 13 GB (7 GB Free);
Motherboard: Dell Inc.,
Antivirus: Windows Defender, Enabled and Updated
Somehow I again lost the SEND button but I pressed ALT+V, Toolbars, etc. and, SEND LATER, displayed. How do I change it to just, SEND? I have a few emails that I would like to send now. Thanks, John
 

More replies
Relevance 52.89%

I am new to the world of Visual Basic & Macro's so please excuse my ignorance.


I am looking to create a macro to populate

Excel Template
Word Template
from an exsisting (master) Excel file

once these documents populated I want to create a zip file containing the newly populated templates.

and then add this zip file and the details from the (master) excel file to an microsoft outlook meeting request

is it possible to do this using macros or will I have to generate some sort of code/ script

I understand there are a lot of factors i am trying to combine into one simple command and may be trying to run before i can walk, but any input, guidance or suggestions would be greatly appreciated,
 

More replies
Relevance 52.07%

Dear all

May I know is there any software (work indepentent, no additional email client e.g. Outlook, Eudora etc. needed) can download email (can filter by sender email address) from a specific POP3 server and save those attachement to a specific folder automatically?

Thanks!

Regards
Christine
 

More replies
Relevance 51.66%

ok, this code below is working but it does not show a pop up from outlook instead it sends the mail automatically.

I want to have a pop up as a new email message with the to list populated from the query when i click the button on the form. anyone can help?
Code:
Code:
Dim MyDb As DAO.Database
Dim rsEmail As DAO.Recordset
Dim strEmailAddress

Set MyDb = CurrentDb()
Set rsEmail = MyDb.OpenRecordset("Query Full Director", dbOpenSnapshot)

Do Until rsEmail.EOF
strEmailAddress = strEmailAddress & rsEmail("Email") & ";"
rsEmail.MoveNext
Loop

strEmailAddress = Left(strEmailAddress, Len(strEmailAddress) - 1)

DoCmd.SendObject , , acFormatRTF, strEmailAddress, _
, , strSubject, strEMailMsg, False, False

rsEmail.Close
Set rst = Nothing
 

Answer:Solved: Email Button to send email in a form access 2010

7 more replies
Relevance 51.66%

Hello, all!

I'm wondering, is there a way to set up an email server that can receive emails addressed to any email address under a specific domain, and automatically set up a mailbox for them (and forward the emails to a specific address)?

I've read that there are people that create a new email address for every website they register on so that they can figure out who leaked their email to spammers. I'd like to do this, but don't want to take the time to set up an email account every single time I register on a website.

For example, I register at Hardforum. I enter an email address: [email protected] When an email is sent to that address, the mailbox is automatically set up by the webserver, and messages are forwarded to my primary mailbox.

Thanks!
ElectroPulse
 

Answer:Email Server to Automatically Generate Mailboxes Upon Email Receipt?

With gmail just add +whateveryouwant at the end of your address and it will do what you are asking.

ex: [email protected]
 

4 more replies
Relevance 51.66%

I want to include my printer in an outgoing email so that it automatically prints the email.  How can I do this?  Thanks.

More replies
Relevance 51.66%

So I've set up a personal out look using the same number on my works outlook, I want the emails kept separate and I'm not use if they automatically link

Answer:Will your work email and personal email automatically link if you've used the same number

In my experience, no. You would have to make the choice to link them.

2 more replies
Relevance 51.66%

hello anyone

Here is a question I need you help me:

I want to send an attachment file to many email addresses at one time, but when I sent it to them, I just want each person's email see only his or her email (as like as -->To: [email protected] in his or her mail only) that I sent for the person.

Can anyone tell me how to do that, or that can not do it, only send one by one? Please let me know immediately.

Thank you for your help

Phil

-------------------------------------------------------------------
For example, I don't want it display in each person's email like that:

Date: Fri, 11 Jun 2004 17:35:51 -0700 (PDT)
From: "Phil T" <[email protected]> Add to Address Book
Subject: re: one to many (one file to each separate person)
To: [email protected], [email protected], [email protected]
[email protected]--

-------------------------------------------------------------------
I want it display like this below (each person received like this, To: [email protected]) and other email received the same file too:

Date: Fri, 11 Jun 2004 17:35:51 -0700 (PDT)
From: "Phil T" <[email protected]> Add to Address Book
Subject: re: one to many (one file to each separate person)
To: [email protected]
------------------------------------------------------------
Date: Fri, 11 Jun 2004 17:35:51 -0700 (PDT)
From: "Phil T" <[email protected]> Add to Address Book
Subj... Read more

Answer:re: how to send an attachment file to many email addresses, but each person email...

I think you you need to put people's address in the bcc (blind carbon copy) field.
 

1 more replies
Relevance 51.66%

Hi, firstly please bear with me as i'm new to this. I'm trying to setup the email on our virtual server through cpanal and using Thunderbird 3 (although i did try it with Outlook 2007 and the same results.)

Using the given Incoming and Outgoing mail server info given (mail.domain.co.uk) and the mail server username, I get a failed to find error (using both POP3 and IMAP). If I change that too the SSL settings for Incoming / Outgoing (serverusername.miniserver.com), it works and autofinds Connection Security as STARTTLS and finds the ports too. With this I can send emails fine, but I am not getting incoming emails, and I don't know enough about it too see what I'm doing incorrect, any help would be great, thanks.

I posted this on yahoo answers first, but the only response I got was "restart your outloook and try later." *facepalm* Glad to have found a place more dedicated to such problems.
 

More replies
Relevance 51.66%

We have Exchange 2007, and I want to be able to have a message sent to our users anytime someone tries to email them with a message that exceeds are message size restrictions. The sender gets a message bounced to them, but the recipient never gets a message and thus they have no idea if someone is trying to email them or not.

I've searched Google and come up blank, also the Exchange help guide is of no help. Anything would be greatly appreciated.
 

Answer:How to send email to recipient when email is bounced back to sender.

Not sure that you can do that, but if you figure something out post it up here. im interested in finding out if you're able to do that.
 

1 more replies
Relevance 51.66%

I have a word document that includes a form the user must fill in. I want to create a button that will do all of the following:
1. Update all fields
2. Attach the updated word document to an email
3. Enter an address I have stored in the macro into the To field of the email.

I have one module which does the first part:
Sub CommandButton1_Click()
Dim oStory As Range
For Each oStory In ActiveDocument.StoryRanges
oStory.Fields.Update
If oStory.StoryType <> wdMainTextStory Then
While Not (oStory.NextStoryRange Is Nothing)
Set oStory = oStory.NextStoryRange
oStory.Fields.Update
Wend
End If
Next oStory
Set oStory = Nothing
End Sub

I found that if I add this to the before End Sub it attaches the updated Word document to an email:
Application.Options.SendMailAttach = True 'Or False
ActiveDocument.SendMail

However, I can't figure out how have it put a specific address into the To field of the document.

So I tried another tact. I have the email address as a hyperlink in the document, and set a bookmark at the hyperlink. Then I created a module that will go to the bookmark and open the hyperlink. However, this will not add the document as an attachment:

Sub Open_Hyperlink()
Selection.GoTo What:=wdGoToBookmark, Name:="hyperlink"
With ActiveDocument.Bookmarks
.DefaultSorting = wdSortByName
.ShowHidden = False
End With

Selection.Range.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
End Sub

So then I found this bit of coding on the web, and tried imp... Read more

Answer:Word Macro to attach doc to email, then send address email

I found a solution, but I think it is a bit bulky. It seems to work but I'd love to know if there is a simpler solution:
Sub CommandButton1_Click()
Dim oStory As Range
For Each oStory In ActiveDocument.StoryRanges
oStory.Fields.Update
If oStory.StoryType <> wdMainTextStory Then
While Not (oStory.NextStoryRange Is Nothing)
Set oStory = oStory.NextStoryRange
oStory.Fields.Update
Wend
End If
Next oStory
Set oStory = Nothing

ActiveDocument.Save

MsgBox "Thank you. Your order has been sent", vbOKOnly, "Thank you. Your order has been sent"
Dim bStarted As Boolean
Dim oOutlookApp As Outlook.Application
Dim oItem As Outlook.MailItem
On Error Resume Next
If Len(ActiveDocument.Path) = 0 Then 'Document has not been saved
ActiveDocument.Save 'so save it
End If
Set oOutlookApp = GetObject(, "Outlook.Application")
If Err <> 0 Then 'Outlook isn't running
Set oOutlookApp = CreateObject("Outlook.Application")
bStarted = True
End If

Set oItem = oOutlookApp.CreateItem(olMailItem)
With oItem
.To = "[email protected]"
.Subject = "Promo Order" '
.Body = "Thank you for your order"
.Attachments.Add Source:=ActiveDocument.FullName, Type:=olByValue
.Send
'**********************************

End With
If bStarted Then 'If the macro started Outlook, stop it again.
oOutlookApp.Quit
End If
Set oItem = Nothing
Set oOutlookApp = Nothing
End Sub
 

1 more replies
Relevance 51.66%

When I got BellSouth DSL years ago I had Outlook email account set up with BellSouth as outgoing and old domain as incoming so I could keep my email address from another domain. It worked fine until a year or so ago I had to add another account just for BellSouth and that worked fine.

Within last few weeks emails from my email address (old domain) would not send. I've been through it with ATT tech several times to no avail.

It seems that ATT has trapped me out and does not want me to be able to keep my old email.

There's bound to be a way to set up my email accounts so my outgoing email from my other ISP provider will send through BellSouth without changing my very old and reliable email address.

Also, I recently have acquired my own domain name and I fear emails from that email address will suffer the same fate.

I hope this is not too long, but PLEASE HELP if you can.
 

Answer:Can't send email using different domain in email address BellSouth trapped me out...

If your BellSouth e-mail service is provided by Yahoo, then you probably need to go through a registration and authentication process for each e-mail address you want to send through a non BellSouth/Yahoo mail server. At least that is what I had to go through as an SBC/ATT DSL customer. They claim that they do the blocking to prevent from originating from users within their network.

http://help.yahoo.com/l/us/yahoo/mail/classic/manage/sendfrom-07.html

EDIT: Forgetting my manners. Hi and welcome to TSG.
 

1 more replies
Relevance 51.66%

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

i want to know that i am leave but my all mail send other

Answer:how to send all mail send to other email id

You mean like a vacation message or something like that?

3 more replies
Relevance 50.84%

I am trying to send an e-mail and attachment automatically (at the click of a button) using the following VBA. The e-mail is send OK but without the attachment (via outlook over a network). When I try to include the attachment (additional code indicated by ??) I get an error message, any ideas.Sub callMessage()??Dim attach As Varient??'Set attachment path??attach = "Workbook.Worksheets("Sheet1").Activate"'argument = False so e-mail is not displayed before sendingSendMessage(False, ??attach)End subSub SendMessage(DisplayMsg As Boolean, Optional AttachementPath)Dim objOutlook As Outlook.ApplicationDim objOutlookMsg As Outlook.MailItemDim objOutlookRecip As Outlook.RecipientDim objOutlookAttach As Outlook.Attachment'Create the Outlook sessionSet objOutlook = CreateObject("Outlook.Application")'Create the messageSet objOutlookMsg = objOutlook.CreateItem(olMailItem)'Add the recipient to the messageSet objOutlookRecip = objOutlookMsg.Recipient.Add("Kevin Nelson")objOutlookRecip.Type = olTo'Set the subject and bodyobjOutlookMsg.Subject = "This is an automated message"objOutlookMsg.Body = "Body of message"'Add attachments to the messageIf Not IsMissing(AttachmentPath) Then Set objOutlookAttch = .Attachments.Add(AttachmentPath)End IfEnd sub

More replies
Relevance 50.84%

Hi,

I built an application a couple of years ago and the user has been able to bring up a report, choose Send page by email... and email the report to their own customers.

However, this week it stopped working. The report still displays on the page, but when he clicks Send page by email... it brings up an empty email. Well, not completely empty, there are around 4 or 5 lines of whitespaces.

Does anyone know what could be causing this?

More replies
Relevance 50.84%

Say I have 10 individual Email recipients that I often send the same Email to. I want to be able to bring all the addresses together into one Group, and send the Email addressed to say "Family" or "Social Team" etc.

Is there a way that I can lump all the common recipients together under one title?

Answer:How do I group common Email addresses together to send all the same Email?

Since your question is in the Windows Live section, I am assuming you are using the Windows Live Mail (POP Version). To add a group email do the following:

1. In Windows Live Mail, click the "contacts" button
2. Click "New"
3. Select "Category"
4. Name the Catergory (such as Family or whatever you want to call the group)
5. Check the email addresses of the list that pops up for those you want in the group.

Now, next time you want to send an email with this program, in the "to" field, simply type the name of the category you just created. All contacts you added to the group will now be sent the email you just wrote.

2 more replies
Relevance 50.84%

I, just today, received a million emails from mail delivery refused daemons and such -i didn't send these emails. I changed my password, i use internet mail.. Yahoo.. I've always received a bleepload of spam however this is more serious.. Just happened recently, so I'm not sure if changing the password helped. still receiving this messages however they were sent before the time i changed my password.

if it so happens that the emails are continued to be sent, do I have malware? please help.

some more info: there are none of these messages in my "sent" folder. it's continuing to send me this delivery failed messages after changing my password. i've run spybot, ad-aware, avast home is on high real-time protection. posted two copies of these emails below, there are tons.

update: i think email is still being sent without my connection to the internet
update2: i think it may just be a ridiculous sort of spam

i.e. 1.----------------------------------------------------------------------

From:
"[email protected]" <[email protected]>
Add sender to Contacts
To:
[email protected]
Message contains attachments
Message001.txt (209b), Maintain a high level of excitement.eml (2KB)
This is an automatically generated Delivery Status Notification.

Delivery to the following recipients failed.

[email protected]

Forwarded Message: Maintain a high level of excitement
Maintain a high level of excitement
Thursd... Read more

Answer:Can malware send email from your internet email address?

Sounds like a spammer got your email address and is spoofing the return to or from address using yours instead.It could also be that someone is infected and their computer had you email address.Here's an example of headers shown in real emailReturn-Path: <[email protected]>Received: from inaamta17.mail.tds.net ([216.170.230.187]) by inmta16.mail.tds.net (InterMail vM.7.08.03.00 201-2186-126-20070710) with ESMTP id <[email protected]net> for <[email protected]>; Thu, 26 Feb 2009 07:51:51 -0600Received: from mta705.email.newegg.com ([38.119.56.165]) by inaamta17.mail.tds.net (InterMail vG.3.00.02.00 201-2196-120-20070322) with SMTP id <[email protected]egg.com> for <[email protected]>; Thu, 26 Feb 2009 07:51:51 -0600

2 more replies
Relevance 50.84%

send receive receive is good--cannot send messages

More replies
Relevance 50.84%

Uh, oh, my session had timed out.   Anyway, I have Dell Dimension 4700.   This computer was formatted, by a computer tech, about two months ago, and Microsoft Windows XP Home Edition put in.   Before that I had Windows XP Professional.   And before that I had the Home Edition again.Anyway, the File, Send page or link by email would always work.  Say, I had Yahoo Mail in the Tools, Internet Options, Programs, Email Section, when I would go to File, Send page or link, it would always take me right to my Yahoo mail; or if I had Hot Mail in the Email section, it would take me to my Hot Mail.So, do not undersand why I get message boxes now.  Yesterday was the first time I had tried the File, Send, since Home Edition put in.Have to scoot to bed now, but will check sometime tomorrow to see if a reply.   Thank you for your feedback.

Answer:File, Send Page by Email, Link by Email

Hi Foxy.I tried to bring up your problem on my system but just couldn't.   Regardless of which mail program was shown in the E-mail section my system runs the default mail program.For example, if Yahoo is shown in the E-mail section and Thunderbird is the default mail program my system runs Thunderbird not Yahoo.Perhaps if you set Yahoo as the default mail program your problem will disappear.Which program generates the "message boxes" you refer to

2 more replies
Relevance 50.84%

Can someone tell me how to:Block send email without showing email addressesThanks Col

Answer:Block send email without showing email addresses

Send it to yourself with the other addresses entered into the Blind Carbon Copy (Bcc) field. To display this when you create a message in Outlook Express, View, All headers.

9 more replies
Relevance 50.84%
Answer:Please need one cd key counter strike not used send on my Email [email protected]

Where to get a counter-strike CD Key are you asking? Why thats an easy question.

Your local computer store, or ata MediaPlay, Best Buy, Circuit City, etc. Or online from Amazon or another store.
What-you thought we would give you one for free?
http://www.techguy.org/rules.html
 

1 more replies
Relevance 50.84%

We are been unable to send emails from our work email to outside addresses. (Yahoo, Hotmail, AOL, etc.)

My Network guy is MIA and I don't know what to do or who to call.

We are host our own email and are running email on Exchange Server 2000 and are on Windows 2000 OS. Any help or advice on who I can call would be greatly appreciated.
 

Answer:Solved: HELP!!! Can't send email at work to outside email address!!!

7 more replies
Relevance 50.84%

Hi I noticed on my brothers computer every now and then the above mentioned program pops up. It says its scanning email to a certain address on port 110, which turns out was some marketing company. Another time the address showed some random looking IP address, which was untraceable after a certain number of hops.

The only email client installed is outlook express, which is set to the comcast/adelphia account. I installed sygate to make sure nothing strange is going on, but this bothers me.
 

Answer:AVG Email Scanner - Says its scanning email I dont send

Sounds like the PC is infected with a spam bot. Some of those things are now rootkits that hide their files/services. Very nasty.

Hunt it down and destroy it the same way as viruses/trojans/spyware.
 

1 more replies