Macro for Sending Mail

[toravietl]

Hi All,

I have one excel with 4 sheets.In each sheet starting from first row. first sheet row has headers from A to F columns.And from second row onwords we have data in those columns
(A to F).Column B contains date values(12-mar-2014 for example) and remaining columns contains text data.I need a macro to copy those data from all the fields and sent a mail to concerned persons.
But it will check max(column B value date value) from all those 4 sheets.Then copy the maximum date value data from all the sheets and send mail using outlook.If any case any sheet have less than maximum date ,for example sheet1 and sheet2 and sheet3 have maximum date
and should be same date and sheet4 have less than that max date value date then it will replace the C,D,E columns data values as Not available and column B date value set to high maximum date value.Excel sheet will placed in specific path I need a macro to send those data automatically using that sheet data.


Any one can help me onthis.

[Richard Buttrey]

Unfortunately your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[toravietl]

Hi Richard,

I have changed the title.Is it ok ?

[Richard Buttrey]

Hi,

The title is now fine. Thanks for the change.

It will help if you upload the workbook, or at least a representative sample from it. Clearly identify the specific ranges that you want to send.

One thing isn't clear. Are you wanting to put this data in a separate workbook and attach that Excel file to an Outlook email?