Automatic email generation

Hi Friends,

I have a Report status in sheet1. I need a macro coding to send this report as a email from this excel to a the recepient [email protected] every month on date 25th.

Can it be done automatically using macro.

This macro should function even if the workbook is closed.

Model of the excel is attached.

Thanks,
Saky

Hi Saky

The process you describe

send this report as a email from this excel to a the recipient [email protected] every month on date 25th.

can be done.

Doing so on a closed workbook that contains macros is problematic. Unless you set Security Level to low or have Digitally Signed macros, you'll need to manually enable macros for the procedure to run. To my knowledge, there's no way to do this with a program.

John

Hi Saky

Yes, that can be done. I assume you're using Outlook. Is that the case? If so, check this link http://www.rondebruin.nl/sendmail.htm

If you would like me to adapt this code for your use, let me know.

Will the worksheet be an attachment to the email or in the body of the email? Will the filename be the same each month? What is the file name?

John

Hi Saky

You said

Pls dont feel bad that i am asking you to do my homework

Do you mean "Homework" as in school work?

John

Hi Saky

Sorry Saky but Forum rules strictly forbid assisting with school homework. If I proceed, I could get banned from the Forum.

If you wish too, you could PM one of the Forum Moderators and explain your situation. If they approve, either have them PM me or indicate such approval in your thread.

Again, sorry.

John

Hi Saky

I'll proceed to work on the project and get it up and running for you. I've PM'd a Forum Moderator to look at our conversation. I'm inclined to believe you and that the "language" thing caused me to misinterpret your words.

However, I want to make sure I don't get into hot water. I'll get back to you ASAP.

John

Thanks John for checking on the forum rules. Although it is policy not to provide homework answers, we can assist in leading the OP to a point where they should be able to complete the task based on your guidance....

However, it is not possible to determine for sure that this is homework, and I guess, if it is, then we hope that the OP will actually learn from your help rather than just take it and run.

Regards
NBVC

Hi Saky

Got the go ahead to proceed. I'll work on this today. Hopefully have something for you later today.

John

Hi Saky

I've got this basically completed except for the attachment.

When you say

I want this excel also to be attached in the mail.

do you mean just the Project Status - Overview sheet or do you mean the entire workbook?

John

Hi Saky

I've assumed you only want to attach the Project Status - Overview sheet. The attached file appears to do as you require based on that assumption.

You'll need to modify several lines of code in Sub Send_Mail to conform to your environment:

Line 70 - Change this to the actual Sheet number of Progress Status - Overview
Line 140 - Change this entire line to the actual Path and File Name of your signature. To do this, do a search on Signatures; you should find the file that has YOUR signature. Make sure it's the .htm file.
Line 220 - insert in the parentheses the EXACT spelling in the Contact File "Display As" field of the Sender.
Line 290 - Change this line from .Display to .Send to automatically send the Email (leave at Display while you test).

You'll also need to set References in VBA. (Tools --> References) See the References.jpg

The attached screen shot.jpg is what I get in running the code in Excel 2000 with Outlook 2007.

Let me know of issues.

John