Hey Vish,
Could you please send code for me the details in attahed excel sheet
I am looking automated mail to be sent by excel to outlook by using the
excel defined time and date
1st - Subject --> Column A is Subject " What user defined
2nd - Date & Time -> Column B is Date and time " What is us
Hi Hemanth,
Code given by Noorian and Lalit will work to send email on that given date.
For that you need to open that excel file manually and trigger the code
manually then only the mail will be sent.
To make this process also automatic follow the below process:
1. Add a Module in your work
Hi Hemanth,
Code given by Noorian and Lalit will work to send email on that given date.
For that you need to open that excel file manually and trigger the code
manually then only the mail will be sent.
To make this process also automatic follow the below process:
1. Add a Module in your work
Thanks Asa and belatedly Noorain. The format function worked and as it
happens the other method was returning the wrong day for all those who
might use it.
The .value2 does not seem to be necessary but I left it anyway.
On Wednesday, June 27, 2012 10:09:16 PM UTC-7, tangledweb wrote:
> Asa!
Hi gm experts,
is anybody solve my problem reg. disable ctrl+d option.
Iam waiting for solution for the problem.
On Thu, Jun 28, 2012 at 2:34 PM, Muralidhar E wrote:
> Hi group,
>
> Because of CTRl+D just fill down the data iam facing this problem, when i
> want to use Ctrl+F unfortunatley it
Dear Divakar,
Please see earlier discussion on this topic.
Date: Sat, 16 Jun 2012 08:14:00 -0700
From: jainayus...@gmail.com
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: MIS executive
Hi Yogananda,
Please note that Job posting is allowed in this forum. Please do not post
any
Nice Pandey ;)
On Fri, Jun 29, 2012 at 12:22 AM, vijay yadav
wrote:
> Thanks Lalit_Mohan
>
> ,You are a genius,great work done.
>
> This gives me 95 % correct results but due to 2 bug or errors I have to
> check everything and correct it.
>
> The bug or errors are
>
> 1)THE X AT RIGHT SHOULD TAKE
Totally agreed.
Warm Regards
Ankur Aggarwal
91-8010614628
Analyst
Mckinsey Knowledge Center
Mckinsey & Co.
From: Divaker Pandey
To: excel-macros@googlegroups.com
Sent: Thursday, 28 June 2012 8:44 PM
Subject: Re: $$Excel-Macros$$ Fwd: MIS executive opening wi
Hi,
I have modified Rajan's code
A closer way to see the data as sheet on cell's double click
Please find the attached.
Regards,
Lalit Mohan
www.excelfox.com/forum
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Mangesh Vimay
S
That’s not possible
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Mangesh Vimay
Sent: 28 June 2012 8:49
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: Need He
Hi Ahmed,
Thanks but it is not solution to my problem.
On 6/28/12, Ahmed Honest wrote:
> Hi Mangesh,
>
> Try using from Insert Menu -- Object -- choose Create from file and locate
> your sheet path that is available in your respective file then an Icon is
> displayed so being in a sheet when
Hi Noorain,
I think job related to excel vba mail should not be banned.
1. it will help to user to know what is in current demand in excel related
job.
2. it will encourage to learn and solve more excels quiz.
3. in last each enhanced skill is used to get better job options.
Regards.
Divaker
O
Hi Friends,
Thanks All for your valuable solution.
But, I need excel sheet when we click on its header so that I could
able to modify data.
Please Help !!!
On 6/28/12, Rajan_Verma wrote:
> Use this One ..
>
>
>
> Problem is not identified but when I click on Twice on Design button it
> work
HI,
Hope this will meet your expectation
Sub SeperateData()
Dim varVal As Variant
Dim lngLoop As Long
Dim rngRangeAs Range
Dim strIni As String
Dim strFinalAs String
Dim strTemp As String
Dim lngVal
Dear Jitu,
As per Forum rule, Job related mail has been banned.
Brother take care in future.
On Thu, Jun 28, 2012 at 4:17 PM, Jitendra singh wrote:
>
>
> -- Forwarded message --
> From: RJT Compuquest
> Date: Thu, Jun 28, 2012 at 1:26 PM
> Subject: MIS executive opening with A
Download from here
http://www.2shared.com/complete/CMFN-eEp/Building_Accounting_Systems_Us.html
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kashan Abbas
Sent: 28 June 2012 1:32
To: excel-ma
Hi Experts
still waiting for solution
Divaker
On Tue, Jun 26, 2012 at 8:25 PM, Divaker Pandey wrote:
> but it will lock modification in list through vba.
>
> Divker
>
>
> On Tue, Jun 26, 2012 at 8:23 PM, NOORAIN ANSARI
> wrote:
>
>> Hi Divaker,
>>
>> I have created a name range "List_Matters"
I still waiting for answers, Please advice
I tried to made it with myself, It look like better but still have problem
see my sheet, Please help
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Attapan
Sent: Wednesday, June 27, 2012 9:46 PM
To: excel-macros
Thanks Lalit
On Thu, Jun 28, 2012 at 3:51 PM, Lalit_Mohan wrote:
>
> Hi Hemanath
>
> Hope it helps you
>
> 'First add Tool -> Refrence -> Microsoft Outlook 12.0 object library
> Sub ExportEmail()
> Dim olApp As Object
> Dim olMail As Object
>
Thanks Noorain, Let me check this out.
On Thu, Jun 28, 2012 at 4:08 PM, NOORAIN ANSARI wrote:
> Dear Hemnath,
>
> before run the macro pls check on Ms outlook liberary
>
>
>
> On Thu, Jun 28, 2012 at 4:05 PM, NOORAIN ANSARI
> wrote:
>
>> Dear Hemanath,
>>
>> Please try it..
>>
>> Sub maildata()
I have posted a request today itself,Should i fill the SURVEY FORM or
should i wait for a few days and fill the form when i get a response ?
Regards
Vijay
On Saturday, 9 June 2012 00:23:15 UTC+5:30, Ayush Jain wrote:
> Dear members,
>
> I have received very few responses on feedback reque
Hi Vijay,
Hope it helps you
Sub SeperateData()
Dim varVal As Variant
Dim lngLoop As Long
Dim rngRangeAs Range
Dim strIni As String
Dim strFinalAs String
Set rngRange = ActiveSheet.Range("A1")
varVal = Split(rngRange
The macro below does exactly what is need but it doesn't prefix the letters
before the hypen.
eg 1
X6-1,4,5,6,9,X7-23,56,67,X30 in cell C34
ANSWER by using below macro -
X6-1 in cell c34
4 in cell c35
5 in cell C36
6 in cell C37
9 in cell C38 I want X6- also as a prefix
23 i
Dear Hemnath,
before run the macro pls check on Ms outlook liberary
On Thu, Jun 28, 2012 at 4:05 PM, NOORAIN ANSARI wrote:
> Dear Hemanath,
>
> Please try it..
>
> Sub maildata()
> Dim olApp As Outlook.Application
> Dim olMail As MailItem
> Dim i As Integer, j As Integer
> Dim sh As Worksheet
Dear Hemanath,
Please try it..
Sub maildata()
Dim olApp As Outlook.Application
Dim olMail As MailItem
Dim i As Integer, j As Integer
Dim sh As Worksheet
On Error Resume Next
Application.ScreenUpdating = False
Set olApp = New Outlook.Application
Set olMail = olApp.CreateItem(olMailItem)
Set sh = T
Dear members,
Please help me solve the above problem using "macro" or "array formulae".
Problem - data seperated by hypen - and comma , to be written in
rows existing below (should not insert rows but place data in already
existing rows )
eg 1
X6-1,4,5,6,9,X7-23,56,67,X30 in cell C34
ANSWER
Hi Mangesh,
Try using from Insert Menu -- Object -- choose Create from file and locate
your sheet path that is available in your respective file then an Icon is
displayed so being in a sheet when you click on that Icon you will get
another sheet.
Revert if you failed to understand the above. I t
Hi group,
Because of CTRl+D just fill down the data iam facing this problem, when i
want to use Ctrl+F unfortunatley it was accidently clicking Ctrl+D iam not
observing it later it was effecting to the data.
So i what i need is i want to *disable Ctrl+D with a passward* and same
time i want to
Friends,
I have an excel spreadsheet with dates updated on it, all I need is that
the system should automatically send an Email to the specified email
address automatically by picking up that particular date.
Ex:
Date:Subject To
29/06/2012 Renew your
29 matches
Mail list logo
