Dear Selva,
Please use below code to add message
Sub Send_Email()
Dim olApp As Outlook.Application
Dim olMail As MailItem
Dim mailbody As String
Set olApp = New Outlook.Application
Set olMail = olApp.CreateItem(olMailItem)
With olMail
.To = noorain.ans...@gmail.com
.CC = noorain.ans...@one97.net
Please add Outlook library before run the code
Tools-Reference-Microsoft Outlook 12.0 Object Library.
--
Thanks regards,
Noorain Ansari
*http://noorainansari.com/* http://excelmacroworld.blogspot.com/
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
On Wed, Mar 14,
Hi
Thank u very much.I need some change in the code.
here I want to count the number of cells deleted in column B here 25 cells
In column C delete 50 cells
In column D delete 75 cells
In column E delete 100 cells.
Please refer the attached file
Regards
Rajesh Kainikkara
On 3/13/12,
Hi,
Try below formula,
=IFERROR(INDEX(Table1[DSPVCHDATE],SMALL(IF(Table1[DSPVCHDATE],ROW(Table1[DSPVCHDATE])-1,),ROW()-1)),)
*Apply With Ctrl + Shift + Enter.*
Regards,
MARIES.
On Tue, Mar 13, 2012 at 10:45 PM, dguillett1 dguille...@gmail.com wrote:
I thought I already responded to this.
Dear Sir
I can able to create Notepad files , but i getting following error when
trying to create word files
Run Time Error
User Defined is not found
On Tue, Mar 13, 2012 at 4:39 PM, BNS kumar chimir...@gmail.com wrote:
Hi,
check this out
Sub CreateWordDocs()
' add a reference to the
Hi there,
I'm not sure the kind of vba code you're looking for. If it's about
using vlookup, match and so on to retrieve data, so far, i'm not able
to do much just following you sql code. If you want me to help, copy
paste the tables you want to query on and I see
Comments in the code below
There ain't no attachment!
Sam
On Wed, Mar 14, 2012 at 8:51 AM, Jim sch...@gmail.com wrote:
I'm trying to divide a value in one Pivot Table by a value in a second
Table. Please see the screen shot and the following explanation in
the attached Word document.
Any ideas? I'm thinking that I
Try this
Sub CreateWordDocs()
Dim xsht As Worksheet
Dim rng As Range
Dim lngLoop As Integer
Set xsht = ActiveWorkbook.Worksheets(Sheet1)
lngLoop = xsht.Cells(Rows.Count, 3).End(xlUp).Row
If lngLoop 1 Then
With CreateObject(Word.Application)
.Visible
Hi Sharma,
How do you define failure for the first query? 0 records returned? an
error from the database server/engine?
What do you want to do with the result of the query? Put it on a (new?)
sheet in your workbook?
*writing* the queries using VBA is very simple. The following assembles
Hi
Mr. Ansari
how are you? My dear i need your help
can u guide me; how can i improve my skills in excel and VBA
regards,
On Wed, Mar 14, 2012 at 11:20 AM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Please add Outlook library before run the code
Tools-Reference-Microsoft Outlook 12.0
Hello, new around here ..
here is something that might help you...
luni, 12 martie 2012, 17:22:04 UTC+2, hilary lomotey a scris:
Hi Experts
i am trying to use the logical formula ie or operator to have an
outcome such that if the figure in say cell A is greater than that of cell
B,
EUROPE - Belgium
Hi,
I would like to do a sorting of cells (values) horizontaly in
ascending order !
There are many lines to sort !
Which is the VBA code ?
Thank you for your help !
Regards,
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles.
Thanks guys I want to thank everone on this site for making us feel welcome
and open to answer any questions keep up the great work
On Wednesday, 14 March 2012 17:49:30 UTC-5, Ayush wrote:
Hello Everyone,
Noorain Ansari has been selected as 'Most Helpful Member' for the month of
thanks buddy i'll give this a try
On Wednesday, 14 March 2012 01:20:52 UTC-5, NOORAIN ANSARI wrote:
Please add Outlook library before run the code
Tools-Reference-Microsoft Outlook 12.0 Object Library.
--
Thanks regards,
Noorain Ansari
**
Considering his work for the past few months.. could we recommend him
for next MVP
On Mar 15, 3:49 am, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Noorain Ansari has been selected as 'Most Helpful Member' for the month of
Feb'12
He has posted 156 posts in Feb'12 and helped
Congrats Noorain:)
On 3/15/12, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Noorain Ansari has been selected as 'Most Helpful Member' for the month of
Feb'12
He has posted 156 posts in Feb'12 and helped many people through his
expertise. He has been consistent contributor to
Congrats Noorain Sir,,
On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Noorain Ansari has been selected as 'Most Helpful Member' for the month of
Feb'12
He has posted 156 posts in Feb'12 and helped many people through his
Dear All,
i want to get opened all excel files in certain folder by using vba coding.
Regards
venkat
Chennai
--
Sent from my Nokia phone
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Congrats noorain bhai.
[?][?][?][?][?]
On Wed, Mar 14, 2012 at 3:49 PM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Noorain Ansari has been selected as 'Most Helpful Member' for the month of
Feb'12
He has posted 156 posts in Feb'12 and helped many people through his
Hi ,
if you are using 2007 or 2010 you can use default sort option with multiple
criterias.
--
Sent from my Nokia phone
--Original message--
From: Jean PIERRE jpr10500.newsgro...@gmail.com
To: MS EXCEL AND VBA MACROS excel-macros@googlegroups.com
Date: Wednesday, March 14, 2012
Congratulation Noorain..
On Thu, Mar 15, 2012 at 9:38 AM, Seraj Alam seraj.ala...@gmail.com wrote:
Congrats noorain bhai.
[?][?][?][?][?]
On Wed, Mar 14, 2012 at 3:49 PM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Noorain Ansari has been selected as 'Most Helpful
Congratulations Noorain!
Great contribution!
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ayush Jain
Sent: Wednesday, March 14, 2012 3:50 PM
To: excel-macros
Subject: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari
Hello
Congrats Noorain Keep it up
On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Noorain Ansari has been selected as 'Most Helpful Member' for the month of
Feb'12
He has posted 156 posts in Feb'12 and helped many people through his
expertise. He has
congratulation noorain ansari
may allah good reward for this.
On Thu, Mar 15, 2012 at 9:40 AM, Subhash Yadav scy2...@gmail.com wrote:
Congrats Noorain Keep it up
On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Noorain Ansari has been selected
Hi
Thank u for ur reply, still I need some more changes in the code, pls
check the attached xl file, it will show step by step what to do.pls
make the necessary change in the code for getting the result.
Sub CopyColumnsToTableSAS()
Dim i As Integer
Dim fr As Long
Dim lr As Long
'col A
Cells(2,
Congratulation for you achievement. Hoping for a good luck.
sanjib
On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Noorain Ansari has been selected as 'Most Helpful Member' for the month of
Feb'12
He has posted 156 posts in Feb'12 and helped many
Congrats Brother..
On Thu, Mar 15, 2012 at 9:50 AM, Sanjib Chatterjee
chatterjee.kolk...@gmail.com wrote:
Congratulation for you achievement. Hoping for a good luck.
sanjib
On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Noorain Ansari has
27 matches
Mail list logo