$$Excel-Macros$$ Mail merge activity from excel to Outlook!!! URGENT!!!!!

Hello All, I have an excel sheet and it contains 800 client names in column A, I want to mail these 800 clients using outlook, is there any way where in I can create a macro which automatically mails these people as soon as I open the excel sheet. its similar to mail merge activity bu

$$Excel-Macros$$ Re: how to make read only file in the particular folder

Hi Tom, Thanks for helping me but I have a question when I ran this macro the file get protect and open as read only. but read only should not get change unless I unprotect it with password. I tried macro you sent to me. The file I have protect through this macro I can easily unprotect with giving

$$Excel-Macros$$ Pinaki's Calendar

Hello Click on the link below and please enter your birthday for me. It will take less than one minute. http://www.birthdayalarm.com/bd2/83935630a44008518b1442916213c204800204d1386 Thank You, Pinaki --~--~-~--~~~---~--~~ Visit the blog to download Excel tutor

$$Excel-Macros$$ Re: Pick up values from alternate rows?

I think the following does what you want: Sub MoveData() Dim LastRow As Integer Dim Row As Integer LastRow = Cells.Find("*", ActiveCell.SpecialCells(xlLastCell), , , xlByRows, xlPrevious).Row + 1 For Row = 1 To LastRow Cells(Row, 2).Value = Cells(Row + 5, 1) Cells(