Vaibhav, I wrote an macro in excel where in the macro automatically find the to, cc, subject, mail body, attachment name, attachment extention, and attachment path, send on behalf of name
The above attributes are already been defined in excel What actually I want is to do some formatting in mail body The trailed mail is carrying an example that how I need the bold in some parts of mail body Wanna help in VBA function. Sent from my iPhone On Nov 30, 2010, at 12:40 PM, "in.vaib...@googlemail.com" <in.vaib...@gmail.com> wrote: > Dear Rahul > > Pl explain the procedure, if you are saying you will be sending it to 9000, > then will you be using mail merge or not. > > If not how u will be sending (i.e. using which application) to 9000 employees. > > Rgds > > Vaibhav J > > > > On Tue, Nov 30, 2010 at 9:21 AM, Rahul Gandhi. <myname.ra...@gmail.com> wrote: > Sir, > > Thanks for the prompt action, But I have a Data of 9000 Employees. > > I have to Send the Letters to Employees without using the Mail Merge. > > Only with The Hlp of Concatenate. > > Eg. > > ="Your Salary is increased with Rs. "&A1&"/- Please find enclosed > attachment which contains the breakup of amount" > > What actually I want is the Value which is derived from A1 should be > Bold. > > > Thanks. > Rahul Gandhi > > On Nov 28, 9:37 pm, Dilip Pandey <dilipan...@gmail.com> wrote: > > Hi Rahul, > > > > I dont think there is any existing function using which you can bold > > at text. Considering your problem, I have thought of one smart way :- > > let say A1 has the text which needs to be bold. Go to B1 and type the > > formula =a1. Now apply conditional formatting in B1 that if cell B1 is > > not blank, then text should be bold. (=not(isblank(b1)) :) > > > > Best Regards, > > DILIPandey > > > > On 11/28/10, Rahul Kamal Gandhi <myname.ra...@gmail.com> wrote: > > > > > > > > > Guys, Can anyone Help me to Bold the text with the help of Formula > > > > > Eg. > > > > > A1 Cell Contains "ABC" > > > > > I Want to write the formula in any cell, lets take Cell B1 =AnyFormula(A1) > > > > > And My output should be *ABC* But in Bold Format > > > > > Any Formula or Code. Please Guys I am Struck > > > > > Regards, > > > Rahul Gandhi > > > +91-9711772297 > > > > > -- > > > ---------------------------------------------------------------------------------- > > > Some important links for excel users: > > > 1. Follow us on TWITTER for tips tricks and links : > > >http://twitter.com/exceldailytip > > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > > <><><><><><><><><><><><><><><><><><><><><><> > > > Like our page on facebook , Just follow below link > > >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;... > > > > -- > > Sent from my mobile device > > > > Thanks & Regards, > > > > DILIP KUMAR PANDEY > > MBA-HR,B.Com(Hons),BCA > > Mobile: +91 9810929744 > > dilipan...@gmail.com > > dilipan...@yahoo.com > > New Delhi - 62, India > > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
