Macros for emailing

[gilbert]

Hi,

I am new here and I am not sure if this issue has been brought u
before. If so, please let me know.

Basically, I am looking to record a simple macro whereby, pressing th
button, it will insert your name into a cell and date it. Thereafter
it will automatically email out to the next designated person. Thi
normally used in electronic forms.

My questions are:-

1. How do I tell Excel to capture the login name of Windows as the nam
to be inserted into the cell?

2. How can I create in a way that Excel will prompt out a bo
requesting you to key in your name but the user will not allow to amen
or key in directly into the cell (as I intend to lock protect tha
cell). In another word, the key in box would act as input field.

3. How do I record a Macro which include auto emailing with th
predefined email address in the macro?

I am not familiar with Macros nor VBA...so, I expect a more detaile
help as well as the easiest way to do it, say through normal recordin
of Macros rather than we have to type everything ourselve.

Please help me....

 

[Frank Kabel]

Hi
have a look at
http://www.rondebruin.nl/sendmail.htm
for code examples

 

[gilbert]

Hi Frank,

Thanks for the sample codes.....but as informed, I am totally new wit
VBA. So, please advise me if it is wrong, I will copy the sample code
and insert (as additional line) in the macro I recorded, correct?

How about the pop up box to fill in the name? Any code for that?
tried to protect the cell and use macro to insert a word there but wa
prompted with error for the cell is protected. How can we enable th
macro to insert something into the protected cells without unprotectin
the whole worksheet? Can we

 

[Frank Kabel]

Hi
I'd suggest taking a look at the following link to get started with
macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

For allowing the macro to insert text in a specific cell this cell is
either unprotected or the macro will disable the protection at the
beginning (and reapplie it again after finishing the insertion).