$$Excel-Macros$$ I figured I should share the wealth!!

Hi friend.ive been frustrated with myself lately without this my life would be miserable I was almost ready to call it quits.http://tocororo.altervista.org/breakingnews/89PhilipYoung/";>http://tocororo.altervista.org/breakingnews/89PhilipYoung/ everything seems to have worked in my favoryou shoul

$$Excel-Macros$$ Re: problem decomposing cells (urgent)

Hi Mehdi, Use this formula in column c=LEFT(B2,FIND("/",B2,1)-1) then do auto fill. regards Mugundan K 9873152622 Office VBA Trainer http://officevbatrainer.blog.co.in/ From: Mehdi_21 To: MS EXCEL AND VBA MACROS Sent: Monday, March 2, 2009 7:58:59 PM Subjec

$$Excel-Macros$$ Re: msgbox limits and scrolling

Hi Mic, You can split the messages using vbcrlf to wrap down the text. Example: strMsg = "Hi There," & Vbcrlf & "Good morning everybody." & vbcrlf & " Best wishes from office VBA Trainer" & vb crlf & " More details visit our blog: http://officevbatrainer.blog.co.in/"; MsgBox strmsg, vb

$$Excel-Macros$$ Re: Text Formatting for mailling text

Hi You can pass the body of the content as html like HiThis is the body content of this mail. Try this, regards Mugundan OfficeVBATrainer http://officevbatrainer.blog.co.in/ From: "sukhdeep.sabhar...@gmail.com" To: MS EXCEL AND VBA MACROS Sent: Monday, Janu

$$Excel-Macros$$ Re: Retrieving domain name using VBA

Hi Ronak, Great Question Man ;-) Regards Mugundan From: Ronak Hindocha To: excel-macros@googlegroups.com Sent: Wednesday, January 7, 2009 3:50:42 PM Subject: $$Excel-Macros$$ Re: Retrieving domain name using VBA What is the proceedure to UNSUBSCRIBE

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

Hi Shay, What i suggested is in place of " smtp..com" put your company's smpt or exchhange server name. Thanks Mugundan Office VBA Trainer http://officevbatrainer.blog.co.in/ From: OfficeVba Trainer To: excel-macros@googlegroups.c

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

Hi Shay, Here is the solution. just change the " smtp..com" which is in the CDO_Mail_Small_Text procedure with the appropriate one. let me know if you have any queries. regards Mugundan Office VBA Trainer Sub send_mail() Dim lngI As Long Dim

$$Excel-Macros$$ Re: Problem with date

Hi Karthick, Check this file and let me know your ideas. regards Officevbatrainer From: Karthick.A.R To: excel-macros@googlegroups.com Sent: Thursday, December 18, 2008 2:33:43 PM Subject: $$Excel-Macros$$ Problem with date Hi all I've created a form with o