Dear All,
I have to maintain two excel file/sheet:
1. For outstanding from Customer :It records sale by various office and
collection from customer . It has 12 column (Sr.No.1 to 12) and around 3500
rows.The same is updated periodically.
2. Cheque collection File: This file contains selected rec
Hi
I am a management student and have to formulate a macro for tour
travel. I have some basic idea but it would be great if you could help
me out with the technicals.
The tour has to be designed in which sequential drop down boxes will
appear. After selecting the city, the person will choose area
hi Group,
Can any one send me the macro commands to create pivot table in excel.
Thanks & Regards
Rajesh
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitt
Hi,
The following code will split the content in column "K" by using "|" as a
border key, but would like place another condition to move the cells in
different columns based on the character found in the cell.
Sub Split_content()
Dim objRange1 As Range
'Set up the ranges
Set ob
Hi
I need some help creating a script. I need it to loop through each row
of a sheet and replicate the value from D to O, P, AW and BL. The
number of rows of the sheet will change so I am thinking it will need
a for - next loop to run to the last row and on each loop it will copy
the data from cel
aul
- Original Message
> From: Kurt
> To: MS EXCEL AND VBA MACROS
> Sent: Fri, November 5, 2010 10:28:46 AM
> Subject: $$Excel-Macros$$ Macro to add bottom border to cells in range
>
> I have several dynamic named ranges that span multiple worksheets. The
> range
I have several dynamic named ranges that span multiple worksheets. The
ranges are named Sheet1Data, Sheet2Data ... up to Sheet4Data.
I need to create a macro that applies a bottom border to the last row
in each range. I've taken some code that loops through the *cells* in
each range (Dim c As Rang
I'd like to create a macro that adds a border to the bottom cells
(i.e., row) of two dynamic ranges.
e.g., Range 1 is based on this formula:
=OFFSET(WorkSheet1!$C$8,0,-1,MATCH(1E+306,WorkSheet1!$C$8:$C$265,1),
16)
A macro runs some calculations in this range, deletes some rows, and
so on, so the
Hi, I am not able to understand ur question. pls make more clear.. and if
possible give sample data
Regards,
Swapnil.
On Sat, Oct 30, 2010 at 10:19 PM, MT wrote:
> I have a worksheet called "Offering" and was wondering how do I make a
> Macro to go from say cell C35 to E26 on that worksheet af
Hi,
I am Najam , I need ur guidence for in excel sheet
suppose i have an excell file with 30 sheets for thirty branches with the
same variables . now ineed to add suppose the data of all cell A1 for
each sheet in a new sheet called total inA1 cell.
one sol is i start adding a1 cell for all
I have a worksheet called "Offering" and was wondering how do I make a
Macro to go from say cell C35 to E26 on that worksheet after I exit
C35 whether C35 was changed or not. If C35 absolutely has to be
changed to make it work, that would be OK. In Access you can sort the
"Tab Order" and pick which
Can anyone help with this?
Not sure how well this copied but I have gl accts on the left with
the
months across the top. I need to copy only the acct data over to
another tab and occasionally new accounts will be inserted so I don't
want to "lock" in the range. I would like to go to Dec Actual
Dear All,
Please find attached a file. It contains four sheets. Sheet branches
contains details for branches, sheet data contains data for the branches and
sheet report contains the rough format in which I need the report to be in.
My quest is that when ever a new branch is opened, for example, b
Thanks
Its difficult to understand for me
Thanks Once again - my purpose is solved
Dharmesh Shah
On Fri, Oct 15, 2010 at 11:44 AM, Vishal Angre wrote:
> *code is Thisworkbook in VBAproject *
>
>
> On Wed, Oct 13, 2010 at 6:05 PM, Dharmesh Shah
> wrote:
>
>> Thanks Vishal
>>
>> Its working
>>
*code is Thisworkbook in VBAproject *
On Wed, Oct 13, 2010 at 6:05 PM, Dharmesh Shah wrote:
> Thanks Vishal
>
> Its working
>
> Can u explain how u done this (If its posible)
>
> Once Again Thanks
>
> Dharmesh Shah
>
>
>
>
>
> On Wed, Oct 13, 2010 at 5:21 PM, Vishal Angre wrote:
>
>> NOW OPEN FI
r
> *To:* excel-macros@googlegroups.com
> *Cc:* villager.g...@gmail.com
> *Sent:* Wed, October 13, 2010 2:22:17 AM
> *Subject:* Re: $$Excel-Macros$$ Macro to run on specific day.
>
> i want to run this macro for today only , i am using following code but is
> not working
>
&
com
>Cc: villager.g...@gmail.com
>Sent: Wed, October 13, 2010 2:22:17 AM
>Subject: Re: $$Excel-Macros$$ Macro to run on specific day.
>
>i want to run this macro for today only , i am using following code but is not
>working
>
>
>
>if (day(now) ) = 0 then
>'
Thanks Vishal
Its working
Can u explain how u done this (If its posible)
Once Again Thanks
Dharmesh Shah
On Wed, Oct 13, 2010 at 5:21 PM, Vishal Angre wrote:
> NOW OPEN FILE AND U WILL SEE ADDIN MANU AND DHARMESH SUB MANU
>
>
> On Tue, Oct 12, 2010 at 12:39 PM, Dharmesh Shah
> wrote:
>
>
i want to run this macro for today only , i am using following code but is
not working
if (day(now) ) = 0 then
' my code
end if
Looking your comments ...
On Wed, Oct 13, 2010 at 11:41 AM, siti Vi wrote:
> only work on day 5 to 10 of the month
>
>
> sub blablabla()
>
> if day(date) >= 5 and da
only work on day 5 to 10 of the month
sub blablabla()
if day(date) >= 5 and day(date) <=10 then
* *your full macro*
*
end if
end sub
On Wed, Oct 13, 2010 at 12:26 PM, C.G.Kumar
wrote:
> Dear All,
> I want my macro to be executed only for specific day in a month based on
system date and
Dear All,
I want my macro to be executed only for specific day in a month based on
system date and it should not run thereafter.
Kindly let me know the code for it.It's urgent.
Regards,
C.G.Kumar
--
--
Some i
Not sure how well this copied but I have gl accts on the left with the
months across the top. I need to copy only the acct data over to
another tab and occasionally new accounts will be inserted so I don't
want to "lock" in the range. I would like to go to Dec Actual for
acct 60, shift end do
Dear Group
I have created one macro, I want to use this macro as add ins, how can I use
this pls help
regards
Dharmesh Shah
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and li
sample data pls
On Tue, Oct 12, 2010 at 5:33 AM, DEF wrote:
> I have a file that is gl accts and $$ amts with a subtotal at the
> bottom. I need to copy down and then over and then come back up off
> of the subtotal line. I tried offset and resize but couldn't get it
> to do a row instead
I have a file that is gl accts and $$ amts with a subtotal at the
bottom. I need to copy down and then over and then come back up off
of the subtotal line. I tried offset and resize but couldn't get it
to do a row instead of a cell.
--
---
Attached is the macro code I need help with. I want to define the end
of the range (to the last occupied cell) in the code. currently the
range is fixed based upon the initial use of code.(I attached a
listing of the code to reference).
Can anyone assist?
Thx in advance!
Dave
Sub Macro_PMT()
'
'
"Excel should recognize that if you're going from 10 to 1
it's going "down"! "... yeah.. that would be nice, but it doesn't)
good luck!
Paul
>
>From: Dave Bonallack
>To: "excel-macros@googlegroups.com"
>Sent: Fri, October 1, 2010 10:00:46
0 05:15:54 -0700
> From: schreiner_p...@att.net
> Subject: Re: $$Excel-Macros$$ Macro hangs
> To: excel-macros@googlegroups.com
>
> Dave, keep in mind that Excel can do several HUNDRED comparisons each SECOND.
>
> If you're adding an Application.wait for only ONE second EACH
the index, and update the values
with
the array of rows
for that index:
for example, the dictionary is by "originator".
the value is:
dict_orig.item(schreiner) = 100|105|310|416|500
then, when I want to report by originator, I read the dictionary, split the
value into an array
and loo
gt; Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
> Chdir "C:\temp"
> End Sub
>
>
> save the template and you should be on your way!
>
> Paul
> - Original Message
>> From: Johnnyboy5
>> To: Paul Schreiner
>
MODELNUMBER123 Part 1A 123 Part 1B 0 Part 2A 234
Part 2B 0 Part 3A 456 Part 3B 432 I'm
implementing a part scanning system For some models we only use Part 1A
and some models Part 1A and Part 1B. Same thing for Parts 2 and 3. In such
c
) then I will
definitely be impressed, and dictionaries may even rise above SumProduct (in my
eyes).
Regards - Dave.
> Date: Wed, 29 Sep 2010 05:15:54 -0700
> From: schreiner_p...@att.net
> Subject: Re: $$Excel-Macros$$ Macro hangs
> To: excel-macros@googlegroups.com
>
> D
Please post a NEW topic instead of "hijacking" another discussion thread.
P
>
>From: Rakesh Sharma
>To: excel-macros@googlegroups.com
>Cc: intermediatec...@gmail.com
>Sent: Thu, September 30, 2010 4:19:19 AM
>Subject: Re: $$Excel-Macros$$ macro to save it
essage
> From: Johnnyboy5
> To: MS EXCEL AND VBA MACROS
> Sent: Thu, September 30, 2010 3:30:17 AM
> Subject: $$Excel-Macros$$ macro to save it to a particular drive / file
>location.
>
> I have a workbook "template" which when team members use it and
>
*Hi ,
I am rakesh from Jammu and i want to know more about macro, and i also want
to know how to use macro and whats the functions of macro,
and my another question is can we add 2 values in vlookup .
please get the attached sheet for exp.
Rakesh Sharma
*
On Thu, Sept 30, 2010 at 1:00 PM, Jo
I have a workbook "template" which when team members use it and
then
when they go to save it defaults to “my documents” and I would like to
set
up a macro to save it to a particular drive / file location. This is
needed to stop team members saving to the wrong location etc.
Below is one that wo
Dear Friend,
How much time did it take to get the result?
Regards,
Angelo
2010/9/29 ashish koul
> hi
>
> check the attchment see it it helps you
>
> you can apply the filter and delte all rows with "d" and then remove the
> temp column
>
>
>
>
>
>
> On Wed, Sep 29, 2010 at 2:44 PM, Dave Bonall
TElapsed Mod 60
msg = msg & Chr(13) & Chr(13)
If (TMin > 0) Then msg = msg & TMin & " mins "
msg = msg & TSec & " sec"
MsgBox msg
Application.StatusBar = False
Application.ScreenUpdating = True
End Sub
Paul
&g
I have the following macro that I use to print only rows with data (A1
to up to I2000 possible).
The only column that has a formula is the I colunm. Without the
formula this macro works but
I do not know where to put in the exclusion to not look at the formula
in column I. Note that the formula
What has this got to do with shading rows?
has someone hijacked another's post?
P
From: "Kishan Reddy, K"
To: MS EXCEL AND VBA MACROS
Sent: Fri, September 10, 2010 2:58:35 AM
Subject: Re: $$Excel-Macros$$ Macro to reshade every other row af
Usha,
This function is used mainly in finance. This can be better explained
by an example.
Let us assume, you are having Rs. 1,00,000/- which you want to invest.
You got two proposals.
1. Fixed deposit at 10% interest for five years.
2. an annuity plan :
end of 1st year you wi
Got it working! Here's the final code. I actually have two named
ranges on each worksheet, so the code performs the highlighting for
each.
###
Dim curWks As Worksheet
Dim r As Long
Dim Range1 As Range
Dim Range2 As Range
Set curWks = ActiveSheet
With curWks
If .Name = ("WS1") Then
Set Range
; > or
>
> > =MOD(ROW(),2)=1 (to shade odd rows)
>
> > Set the shading format you want
>
> > OK
>
> > Hope this helps.
>
> > Regards - Dave.
>
> > > Date: Wed, 8 Sep 2010 13:56:09 -0700
> > > Subject: $$Excel-Macros$$ Macro to reshade e
7;t currently using it for something else.
>
> Select all cells in the block
>
> Open the conditional formatting dialogue box
>
> Select 'Formula is'
>
> Enter:
>
> =MOD(ROW(),2)=0 (to shade even rows)
>
> or
>
> =MOD(ROW(),2)=1 (to shade odd ro
#x27;Formula is'
>
> Enter:
>
> =MOD(ROW(),2)=0 (to shade even rows)
>
> or
>
> =MOD(ROW(),2)=1 (to shade odd rows)
>
> Set the shading format you want
>
> OK
>
> Hope this helps.
>
> Regards - Dave.
>
> > Date: Wed, 8 Sep 2010 1
-- Forwarded message --
From: Usha Negi
Date: Thu, Sep 9, 2010 at 1:47 PM
Subject: Re: $$Excel-Macros$$ Macro to reshade every other row after column
sort
To: excel-macros@googlegroups.com
Dear All,
Can you tell me what is IRR (Internal Rate of Return Calculation) in Excel
and
Dear All,
Can you tell me what is IRR (Internal Rate of Return Calculation) in Excel
and how to use it?
Regards,
Usha
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
Formula is'
Enter:
=MOD(ROW(),2)=0 (to shade even rows)
or
=MOD(ROW(),2)=1 (to shade odd rows)
Set the shading format you want
OK
Hope this helps.
Regards - Dave.
> Date: Wed, 8 Sep 2010 13:56:09 -0700
> Subject: $$Excel-Macros$$ Macro to reshade every other row aft
I have four worksheets (WS1, WS2, etc.), and on each sheet a dynamic
name ranged (WS1Data, WS2Data, etc.). These named ranges always begin
on B8 but the columns and rows they span will vary based on the data
(so I can't use an absolute reference). The rows in the range are
alternatively shaded.
Ea
Hi
The best and the easiest way.
Regards
Rajender Soni | 750 322 55 50
On Aug 19, 12:12 am, Umesh Dev wrote:
> Hi Sundervelan,
>
> I have enclosed a file which will automatically update the moment you make a
> change in the Master sheet.
>
> Regards
> Umesh
>
>
>
> On Wed, Aug 18, 2010 at 12:06
Hello All ,
First request and bit urgent.
Request :
When I send a mail , Outlook should search list of words which are stored in
backend.
If found , it gives me popup with list of words which are identified in Mail ,
once I confirm than mail is sent to recipient.
Macro should not only search i
Hey,
Dont post vague queries and clog our mail box, BE specific and attach a
sample file...
Please read the mail sent by Paul regarding Good Group Etiquettes..
Thanks Vinod
On Mon, Aug 16, 2010 at 3:47 AM, caffe Trieste wrote:
> How i cam make some macro for using example 60 days one e
How i cam make some macro for using example 60 days one excel page?
thank you
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join o
Hi everybody -
I am hoping someone can help me out with a problem that I am having.
I am trying to edit a macro, but I do not have a lot of experience
writing macros and I cannot figure out the issue.
I have a spreadsheet with a macro that does some formatting and
refreshes a pivot table in a diff
; Columns("C:C").Select
> Columns("I:I").Select
> Columns("U:U").Select
> Columns("X:X").Select
> Columns("Y:Y").Select
> Columns("Z:Z").Select
> Selection.Delete Shift:=xlToLeft
>
> End Sub
>
>
>
> On Aug 8,
eating a macro for on the attached file...
>
> *Conditions/Criteria*
> 1. Delete columns C,I, U,X,Y,Z
>
> 2. Delete the rows which has "180" in column A
>
> 3. Delete rows which has "WW","Z0","Z1","Z2" in Column D ( after the step1,
Need macro to get file output to look like tab 3 whether the input file
looks like tab 1 or tab 2. What I think needs to happen is look for the
column headers in the file and if they are there copy the entire column and
paste to new tab, if they are not create just the column header and paste
that
Any progress on the file formating?
*Joel*
On Sun, Jul 25, 2010 at 03:35, Sandeep Kumar Maurya
wrote:
> Hi,
> I got your file but next time use gmail and attach in the mail.
>
>
> Thanks & Regards
> Sandeep
>
> On Sun, Jul 25, 2010 at 1:02 AM, JD <5635.daw...@gmail.com> wrote:
> > How do I atta
hi friend,
i attached an excel file, which having some information in it, now i want
that if i will do any type of change in it, i will be able to trace it,
means, i change in some of the column or row, or i introduce any new row ,or
delete any row. every type of change i want to trace.,
plz help.
Hi Team,
Can anyone provide me a macro which can extract the sent items mail details
from Microsoft Outlook 2007
I want the details in excel sheet
& required Details are
Mail Recd from Recd Date recd Time Mail Sent date Mail sent to
Subject Mail sent Date mail sent Time
All details Can
Hi,
I got your file but next time use gmail and attach in the mail.
Thanks & Regards
Sandeep
On Sun, Jul 25, 2010 at 1:02 AM, JD <5635.daw...@gmail.com> wrote:
> How do I attach? I placed in file section of
> MS EXCEL AND VBA MACROS.
>
>
> On Jul 24, 5:35 am, Sandeep Kumar Maurya
> wrote:
>> Hi
How do I attach? I placed in file section of
MS EXCEL AND VBA MACROS.
On Jul 24, 5:35 am, Sandeep Kumar Maurya
wrote:
> Hi JD,
>
> You forgot to attach file.
>
> Thanks & Regards
> Sandeep
>
> On Sat, Jul 24, 2010 at 5:52 AM, JD <5635.daw...@gmail.com> wrote:
> > I am looking to clean up a file
Hi JD,
You forgot to attach file.
Thanks & Regards
Sandeep
On Sat, Jul 24, 2010 at 5:52 AM, JD <5635.daw...@gmail.com> wrote:
> I am looking to clean up a file that gets sent to me weekly see
> "example file.xlsx" on file page. The file may look like the first tab
> the 1st week it is sent to me
I am looking to clean up a file that gets sent to me weekly see
"example file.xlsx" on file page. The file may look like the first tab
the 1st week it is sent to me and like the second tab the 2nd week it
is sent to me but I need it to look like the 3rd tab all the time for
import into database. Ca
I'm rather new to Excel macros so any help is appreciated.
I would like to highlight every other row in a range (A5:L40). I do
not want to use conditional formatting, because I'm already using some
in this range. So, I need to use a macro.
I've seen lots of macro samples to shade alternate rows,
Hello Group,
Does any one have vba code which move excel files from one folder to
share point folder.
I have 40 files and which i need to export to sharepoint 40 different
folders. Is there any way to do in VBA.
Regards,
Vinu.
--
Dear Group,
I have excel sheets containing sales data on daily basis (from about 150
sites) (The columns are similar in all the daily sale files but rows change
from time to time as new sites either become operational or stop working). I
wish to consolidate all the data in one excel file in such a
smile
> *To:* excel-macros@googlegroups.com
> *Sent:* Fri, June 11, 2010 9:32:14 AM
>
> *Subject:* Re: $$Excel-Macros$$ MACRO WHICH CAN FILTER THE CURRENT CELL
>
> Thanks
>
> But my problem is filter *the current cell by raw wise *
>
> I have try your option bu
suggestion.
>>
>> if you want the selected cell to be filtered in the
>> selected column, then use:
>>
>> Selection.AutoFilter field:= activecell.column, criteria1:=
>> activecell.value
>>
>> Paul
>>
>> --
&
ltered in the
selected column, then use:
Selection.AutoFilter field:= activecell.column, criteria1:= activecell.value
Paul
From: big smile
To: excel-macros@googlegroups.com
Sent: Fri, June 11, 2010 1:11:41 AM
Subject: Re: $$Excel-Macros$$ MACRO WHICH CAN FILTER THE CURRENT
Thanks for immediate reply.
My 2 nd question solved about print screen.
But to the main question still not resolved.
The problem is i want to filter full raw .
for ex. my cursor is on Raw No. 9 Cell no. B - i.e. - B9
I want to full raw to filtered .
but it does not work.
I have rewrite my m
Criteria1:=ActiveCell.Value
TO TAKE THE PHOTO PRESS "printscreen" or"prt scr" button and goto ms
paint press ctrl +v or paste it then cut the image and send it
On Thu, Jun 10, 2010 at 5:00 PM, big smile wrote:
> Hellow Gorup Masters,
>
> I want the help to write the macro as follows.
>
-Macros$$ MACRO WHICH CAN FILTER THE CURRENT CELL
Hellow Gorup Masters,
I want the help to write the macro as follows.
Sub Macro2()
'
' Macro2 Macro
' FILTER LIKE THIS
'
' Keyboard Shortcut: Ctrl+Shift+F
'
ActiveSheet.Range("$A$3:$IX$681").AutoFilter
Hellow Gorup Masters,
I want the help to write the macro as follows.
Sub Macro2()
'
' Macro2 Macro
' FILTER LIKE THIS
'
' Keyboard Shortcut: Ctrl+Shift+F
'
ActiveSheet.Range("$A$3:$IX$681").AutoFilter Field:=1, Criteria1:= _
"CURRENT CELL CONTENT "
End Sub
when ever i select the pa
Thanx Swapnil!!!
Its working
On Thu, Jun 3, 2010 at 10:05 AM, Swapnil Palande wrote:
> Hi Deepak,
>
> Save you excel as "Microsoft Office Excel Add-In". After saving excel as
> add-in, you will get access to macros of this excel in all other excels. You
> can add your own menu in menu bar.
> If y
Hi Deepak,
Save you excel as "Microsoft Office Excel Add-In". After saving excel as
add-in, you will get access to macros of this excel in all other excels. You
can add your own menu in menu bar.
If you search on google you will get code for it. I have a code for it, if
you want I can forward it t
Hi all,
I have made some macros for some data cleaning, my problem is that whenever
i have to use that macros in some other file, i have to open the file
which contains that macros.
is it possible to make some buttons in Excel Ribbon to use that utility
every time hassel free without opening that
Hi,
I want build a macro open a Userform showing the corresponding values
from a worksheet by entering a value in a Input box. For Example if i
enter a ID Number and click ok button, then one userform with
corresponding values (Name, address, sex, date of birth) should open
to view the values. Ple
Hi
I have workbook consist of 4sheets
I want to Autofilter each cell value in column A from sheet1
and same cell value will get Autofilter in sheet2, sheet3, sheet4 also
i got below mention code on net but it autofilter only particular Criteria
in all sheets
i want to Autofilter each value from sh
> Hello Team,
>
> I am using macro for mail merge and wanna know how to make changes in font
> type and how to bold a particular line/word while doing mail merge.
>
> Can you please help me.
>
Thanks and Regards
Atul Kesaria
--
---
Hello Team,
Please help me.
Thanks and Regards
Atul Kesaria
On Fri, May 21, 2010 at 9:35 AM, Atul Kesaria wrote:
> Hello Team,
>
> I am using macro for mail merge and wanna know how to make changes in font
> type and how to bold a particular line/word while doing mail merge.
>
> Can you please
Use this Code
Sub range()
R = Application.WorksheetFunction.CountA(RANGE("A1:A65536"))
RANGE("A1:B" & R).Select
End Sub
On May 19, 2:40 pm, SANJAY SONI wrote:
> Dear All,
>
> Please help me to provide a macro code for selecting a variable range.
>
> Suppose for example the data enter fro
Hello Team,
I am using macro for mail merge and wanna know how to make changes in font
type and how to bold a particular line/word while doing mail merge.
Can you please help me.
Thanks and Regards
Atul Kesaria
--
l <
> harpreetguj...@gmail.com> wrote:
>
>> FYI
>>
>> -- Forwarded message --
>> From: Harpreet Singh Gujral
>> Date: Wed, May 12, 2010 at 11:04 PM
>> Subject: Re: $$Excel-Macros$$-Macro to Prepare Letters
>> To: Atul Kesaria
>
Hi Ashish,
This below code might help you.
lstrow = Range("A65000").End(xlUp).Row
Range("A1:" & "B" & lstrow).Select
On Wed, May 19, 2010 at 10:40 AM, SANJAY SONI wrote:
> Dear All,
>
> Please help me to provide a macro code for selecting a variable range.
>
> Suppose for example the data ent
Dear All,
Please help me to provide a macro code for selecting a variable range.
Suppose for example the data enter from (A1:B10) but if the more data
is entered into a cell by changing a range to (A1:B20) or (A1:B18).
Thanks in advance
Please provide solicit inputs if you can
Sanjay
+9193
This is Superb Mahesh. really helpful for anyone who wants to send
repetitive emails to a list of persons.
Can anyone please also tell me its utility from Finance Dept. point of
view, what functions have you used this Macro for.
thanks
Sameer
On May 15, 10:49 am, Mahesh parab wrote:
> Hi
> In
Hi Mahesh,
Thanks a lot, this is working fine now. i m great full to you.
could you pls give me one more help. i want to use check names option
in outlook. so what code should i use in this macro.
Thanks
Pankaj k Pandey
On 5/18/10, Mahesh parab wrote:
> Hi
>
> You can do below menti
Hi
You can do below mention changes to add CC,BCC in mail
.To = Cells(cell.Row, "D").Value
.CC = Cells(cell.Row, "E").Value
.BCC = Cells(cell.Row, "F").Value
change the column name as per your requirement.
if you want to add yesterday's date in boday of mail then you can use below
mention code
.B
Hi Mahesh,
Thanks a lot for this help, this is really too
helpfull for all outlook users.
I also want to know that if i have to add CC or BCC in mail so what
the changes i have to do in macro. & n pls also tell me if i have to
add yesterday date in body of the mail every da
Dear friends
Below you can find the code I wrote to make Excel send emails thought a list
of names
My problem is the attachment talk.
I need a code that gets all files from a certain directory and attach into
the email using the " .attachment.Add"
Does anyone know how to do that ?
Atul,
So you mean, that you need to use different format of a letter, basis
on some condition. Is that correct?
If the answer is yes, please provide a condition on how you want to
select a particular letter and mail it
Harry
On May 11, 3:54 pm, Atul Kesaria wrote:
> Hello Team,
>
> Can some on
Hello Team,
Can some one please help me.
Thanks and Regards
Atul Kesaria
On Sun, May 9, 2010 at 6:20 PM, Atul Kesaria wrote:
> Hello Andy,
>
> I can use mail merge, but thats a manual process and I want to use
> different format for for preparing letters which might go above 1000+
> letter. Th
Hello Andy,
I can use mail merge, but thats a manual process and I want to use different
format for for preparing letters which might go above 1000+ letter. Thge
problem using mail merge manually is that it again require formatting and
whicd adds up to more time in preparing letters.
Looking forw
Hi atul,
Why dont u use mail merge.
Regards,
Andy
On Fri, May 7, 2010 at 12:38 PM, Atul Kesaria wrote:
> Hello Team,
>
> I am looking at a macro to write letter in word (a predefine letter format)
> with certain field to be picked from an excel-sheet source.
>
> Request you to send me macro cod
Hello Team,
I am looking at a macro to write letter in word (a predefine letter format)
with certain field to be picked from an excel-sheet source.
Request you to send me macro code.
Thanks and Regards
Atul Kesaria
--
=" & s.Name & "!C30"
Cells(B, 5) = "=" & s.Name & "!D30"
Cells(B, 6) = "=" & s.Name & "!E30"
B = B + 1
End If
Next s
End Sub
Regards - Dave.
> Date: Mon, 3 May 2010 18:51:55 -0700
> Subject: Re: $$Excel-Macros$$ Macro to d
ot;)
> Cells(B, 6) = s.Range("E30")
> B = B + 1
> End If
> Next s
> End Sub
>
> Regards - Dave.
>
>
>
>
>
> > Date: Wed, 28 Apr 2010 21:24:29 -0700
> > Subject: $$Excel-Macros$$ Macro to display specific
On Apr 27, 2:41 am, Swapnil Palande wrote:
> Hi Rupin,
>
> Please find attached excel for solution. Select the range and press Ctrl and
> Q.
>
> Regards,
>
> Swapnil.
>
> On Mon, Apr 26, 2010 at 2:59 PM, Rupin Goel wrote:
Thank you for your help. It seems someone was asking the same
question
Cells(B, 3) = s.Range("B30")
Cells(B, 4) = s.Range("C30")
Cells(B, 5) = s.Range("D30")
Cells(B, 6) = s.Range("E30")
B = B + 1
End If
Next s
End Sub
Regards - Dave.
> Date: Wed, 28 Apr 2010
1101 - 1200 of 1302 matches
Mail list logo