Hi,

I am using Office 2007 pack and want to send E-mail to a particular group every day.

I want to say My Excel looks llike below :
Example:
Date problem Solution Author Location
29-Jan-12 issue 1 Fixed Deepak India
30-Jan-12 issue 2 Fixed Deepak india

On 29-Jan i want to send a mail saying the Problem = 'Issue1', Solution = 'Fixed', Author = 'Deepak', Location = 'India'.

Can anyone help me in writing the Macro for this .

You can send the mail on my Email Id - [email protected] or reply on the post.

regards,
Deepak

Hi

You can use Workbook.Sendmail if you want to send the entire workbook by mail. If you try to do with Outlook you can have an elegant solution

I have tried using Outlook (http://vbadud.blogspot.com/2007/04/vba-email-automation-vba-mail.html)

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Hi Shasur,

I only want to send the Entry per day from the Excel Sheet .

As i have already suggested in the Example. If you can help me on this it?

Thanks
Deepak

Hi Deepak

You need to go for the Outlook Automation.

The example gives you some hint on how to automate Outlook and use the values from Excel. If you are new to Outlook automation - please have a look at http://msdn.microsoft.com/en-us/library/ee814736.aspx

This is very good to start with

Cheers
Shasur

__________________
C# Code Snippets (http://www.dotnetdud.blogspot.com)

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Thanks Shasur,

I will go through that document, but still if you have any suggestion regarding the code that would be great.

Cheers,
Deepak