C# Discussion Boards - CodeProject

9-Mar-09 21:23

hi guys, this is my first post in CodeProject.
i want to send an email from my c# code but at a specific time.
would any one please help me.
i have exchange server in my office and i am able to send email immediately using System.Net.Mail.SmtpClient class but can't send it at a specific time.
thanks

Mycroft Holmes9-Mar-09 21:27

9-Mar-09 21:27

Ramin RamZ wrote:
this is my first post in CodeProject.

That I'm afraid is obvious from the content of the post. This question has been asked sooo many times it is ridiculious, try searching either CP or Google. You will find many examples to work with.

Good luck.

Never underestimate the power of human stupidity
RAH

Ramin Rahimee9-Mar-09 21:35

9-Mar-09 21:35

i have already searched google but didn't solve my problem.
because i dont want to put it in a queue and set a timer to look at the queue after a specific time.
the problem is that the computer sending the mail might be off on that time, what i want is to send the mail even if the computer goes off.

N a v a n e e t h9-Mar-09 21:47

N a v a n e e t h

9-Mar-09 21:47

Schedule the mail sending application using windows scheduler.

Ramin RamZ wrote:
the problem is that the computer sending the mail might be off on that time, what i want is to send the mail even if the computer goes off.

Navaneeth

How to use google | Ask smart questions

Ramin Rahimee9-Mar-09 22:54

9-Mar-09 22:54

thanks navaneeth for the reply.

but if the computer goes off then how the scheduler would be able to run.

Christian Graus9-Mar-09 22:02

Christian Graus

9-Mar-09 22:02

Ramin RamZ wrote:
what i want is to send the mail even if the computer goes off.

Wow. You ARE dumb. How can your PC send mail, if it is off ? It can't.

Christian Graus

Driven to the arms of OSX by Vista.

Ramin Rahimee9-Mar-09 22:52

9-Mar-09 22:52

nothing is impossible in the world of programming.
if i send e-mail to someone and if i am able to delay it from the server then for sure it is possible. It is possible through server based not client based i know this, but i dont know how to delay it from the SMTP server.

Dave Kreskowiak10-Mar-09 1:29

Dave Kreskowiak

10-Mar-09 1:29

Ramin RamZ wrote:
if i send e-mail to someone and if i am able to delay it from the server then for sure it is possible.

Sure, on an Exchange server, it's possible. But, on a normal SMTP server, there is no facility to support this.

A guide to posting questions on CodeProject[^]

Dave Kreskowiak
Microsoft MVP
Visual Developer - Visual Basic
2006, 2007, 2008

Rob Philpott9-Mar-09 23:14

Rob Philpott

9-Mar-09 23:14

You send email using the SMTP protocol which is donkey's years old. There is no facility in this protocol to time the sending of mail, you send it to your server, it forwards it on to the next and so on until it gets recieved by the recipient.

The only way email gets delayed is if a server is out of action. Normally when this happens, the previous server in the chain will attempt to resend it at intervals. The sender will normally get information emails saying that it's having difficulty contacting the (maybe redirection) server. Usually after about 48 hours it gives up and returns your mail.

The only way you can do what you're tring to do is by actually doing the send at a later time. If you're SMTP server or the sending computer is turned off then you are stuck and that's the bottom line.

As others suggest either the Windows Scheduler or your own rolled solution are the only options you have. Sorry.

Regards,
Rob Philpott.

Ramin Rahimee9-Mar-09 23:47

9-Mar-09 23:47

thank you Rob.

Mycroft Holmes9-Mar-09 23:26

9-Mar-09 23:26

Sorry Ramin my mistake - missed the word "delay" in your title Blush | :O

Never underestimate the power of human stupidity
RAH

Ramin Rahimee9-Mar-09 23:42

Re: A few Excel Questions

9-Mar-09 23:42

its ok no problem.

A few Excel Questions

MumbleB9-Mar-09 20:42

MumbleB

9-Mar-09 20:42

Hi Guys. I have a working Excel application that reads an input file and writes the data to an Excel sheet. Now, I need to do a few more things though but just can't seem to get it working properly. This is what I need to do and what I have so far.
I need to set the current cell color to red if the Recon Indicator is NN but it sets all the cells before the current cell to RED. My question is how do I select only the current Cell. I have tried numerous things but it doesn't work.

                    if (RECONCILIATIONIND == "N")
                    {
                        objSheet.Cells[iR, iC + 18] = RECONCILIATIONIND;
                        objRange = objSheet.Cells.Rows.EntireRow;
                        objRange.Font.ColorIndex = "3";
                    }
>/pre>
The next problem I have is that I need to do some calculation on an unknown number of cells and subtract it from a total in a different column.  Below is a sample screen.
<code>
Nominees & Own Name (Level 1)	Beneficiaries (Level 2)
19326421	
	                                175
	                                84
	                                76
	                                2238
	                                235
	                                14
	                                591
	                                345
	                                122
</code>
From the above, I need to calculate the totals in Beneficiary (level 2) and subtract that from Level 1 total and add the total into a new column.  Now, there is an undertermined number of values in Level 2 i.e. there could be 2 or 4 or 50 or 300 values to add.  How would I be able to do that?

Any help or advise would be appreciated. 

<div class="ForumSig">Excellence is doing ordinary things extraordinarily well.</div>

Mycroft Holmes9-Mar-09 21:06

ContextMenuStrip shortcuts problem

9-Mar-09 21:06

I suggest you reformat the question to include ONLY code in the code block - this is unreadable.

Never underestimate the power of human stupidity
RAH

maryam.saboor9-Mar-09 20:37

maryam.saboor

9-Mar-09 20:37

Hi All!
I have a Form simulating an OpenFileDialog which has a ContextMenuStrip with some items including: Copy, Paste, Delete and so on with shortcut keys: Ctrl+ C, Ctrl + V and Del.
The problem is this: when I lunch the form, Del shortcut works fine (but Ctrl+V ant Ctrl+C don work unless I show the context menu by right clicking)! if I do a Copy/Paste the Del shortcut does not work any more until the next time I right click on the form and showing the context menu Cry | :((

. this problem is only by shortcuts, context menu items work fine by themselves.
any suggestion would be greatly appritiated.

Re: ContextMenuStrip shortcuts problem

Mycroft Holmes9-Mar-09 21:10

Problem in reading excel from server folder

9-Mar-09 21:10

I am assuming that the form is getting the keypress events instead of the context menu. If you think about the way a menu works IE press alt F to activate the file menu item then it makes sense that a context menu will not be operated directly from the form.

Why Del work, I have no idea. If you trap the keypress on the form you may be able to activate the context menu.

Never underestimate the power of human stupidity
RAH

Krishna Varadharajan9-Mar-09 20:29

Krishna Varadharajan

9-Mar-09 20:29

Hi,

Here is my code...

string sPath = Server.MapPath("~/sms/sms.xls");
String sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=sPath;Extended Properties=Excel 8.0";
OleDbConnection objConn = new OleDbConnection(sConnectionString);

objConn.Open();

OleDbCommand objCmdSelect = new OleDbCommand("SELECT * FROM [Sheet1$]", objConn);

From the above code, connection string was working and connection is opening fine, than its throwing the error messg like

"The Microsoft Jet database engine could not find the object 'Sheet1$'. Make sure the object exists and that you spell its name and the path name correctly."

But sms.xls file having the name of sheet1 and which resides inside the sms folder... than to y this message appearing....

Pls help me....for the past 2 days iam sike of this problem

krishna

Re: Problem in reading excel from server folder

Mycroft Holmes9-Mar-09 21:16

Re: Problem in reading excel from server folder

9-Mar-09 21:16

never having used a connection to XL but I would check that the sheet1$ is the same as naming a sheet sheet1, the $ may signify the system default name rather than a user defined name.

Try naming the sheet differently.

Also make sure the sheet layout conforms to DATABASE layout structure, no stray bits in the top rows!

Personally I would open the sheet and interate the rows and cells rather than rely on the OLEDB connection.

Never underestimate the power of human stupidity
RAH

Jack Li9-Mar-09 23:06

Jack Li

9-Mar-09 23:06

The excel's sheet have some sheet name, Sheet1$ on of this,but application read excel, if you excel file sheet name not call Sheet1$, it's will error, So, You'll using sheet of Excel file, the code for sheet[0],it's mean frist sheet name,Sheet[1] is second sheet name.

how to search a word in word document and capture the immediate next word and insert it into the DB

Ferdin9-Mar-09 19:33

Ferdin

9-Mar-09 19:33

Hi Everybody,
I have a word document, i need to analyze the whole document and search a word and capture the next immediate word of the searched word and insert it into the DB.
eg: i have a phone bill of 3 persons in a single word document, i need to analyze this doc and find each persons name, ph no, monthly charges and insert these values into a DB... i hope u understood my issue... Awaiting ur reply....

Re: how to search a word in word document and capture the immediate next word and insert it into the DB

Mycroft Holmes9-Mar-09 21:18

Re: how to search a word in word document and capture the immediate next word and insert it into the DB

9-Mar-09 21:18

Wow google is so difficult to use, look at the 3rd entry![^]

Never underestimate the power of human stupidity
RAH

Ferdin9-Mar-09 21:34

Ferdin

9-Mar-09 21:34

Hi Holmes...
I know how to search in Google, bt i did'nt get the expected result... that s y i have posted here...if u know plz give me a clue r else...leave it...

Re: how to search a word in word document and capture the immediate next word and insert it into the DB

Mycroft Holmes9-Mar-09 23:24