email msg in exl on cell date to certain ppl

Microsoft Excel 2007
July 1, 2010 at 18:21:43
Specs: Office 2007
Dear all,

I am now doing a proj on excel application !
Could anyone help me about this ?

Actually, i know nth about the EXCEL VBA, but i have to generate an auto email based on the details of Excel. The followings are the situations.

I have to email the "Job Title" in the cell to a particular person (according to the cell) automatically based on the cell dates.

It is something like Email alert.

Here is the sample of my excel workseet

1 Job date 1 date 2 resp. by email
2 job 1 dd-mm dd-mm john john@

See More: email msg in exl on cell date to certain ppl

July 2, 2010 at 08:10:17

Look at this post, response 7 and
this post.

Both create and send e-mails from Excel.

Note the warnings about the use of passwords in the code and potential security risks - less of an issue if you are not distributing the worksheet to anyone else.


Report •

July 4, 2010 at 17:54:19
actually, i know nth about the VBA programme, can you tell me more ?

how to insert the cell no ?

Thanks very much !

Report •

July 4, 2010 at 18:42:54
Besides, I have some Questions,

As i am trying to input the code into the excel vba,

there are errors,

since I have set some alert dates using formular in the excel, as well as the email addres (using the functions in excel)

So, should i put any code prior to the cell ??

Thanks very much !

Report •

Related Solutions

July 5, 2010 at 06:22:46

DId you read response 7 mentioned in my first post.

This tells you how to enter the VBA code.

If you followed it, you need to repeat what steps you took and what errors you get.

Saying there are errors doesn't help. What are the error messages - when do they happen etc.

You say should i put any code prior to the cell ??
I don't know what you mean by this.

Code goes in a VBA window, it doesn't go in a cell or prior to a cell.

You also asked how to insert the cell no ?
What does this mean. Is 'no' short for number?
Where do you want to insert this 'cell no'.

Cells have addresses such as A1, consisting of a column and a row.
In VBA, a cell is a Range object and is addressed like this Range("A1")
As cells are on Worksheets, then it is necessary to identify which worksheet the cell is in:
or the active worksheet :

Have you tried getting a couple of simple VBA macros working first. At least then you know that you have the basic ability to get a macro to work.


Report •

Ask Question