Dear Friends,
I am using outlook 2010. Does anyone know how to print outlook attachment
and body of email.
As a request from new client, we print close to 1000 email per day.
Please share if you any code which can either run in outlook or in excel
sheet.
Thanks
--
Chethan
--
Are you
I am trying to download PDF attachment.. It is working, But need to add
Subject along with file name when file is saved in the folder.
Kindly advise.
--
Chethan
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page
Respected sir,
I am using the following code to download PDF from Outlook. But it is
giving error message. Kindly let me know how to fix it.
Sub Test()'Arg 1 = Folder name of folder inside your Inbox
'Arg 2 = File extension, is every file
'Arg 3 = Save folder, C:\Users\Ron\test or
'If
--
Chethan
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent,
Yes. it is single column A:A
On Thu, May 7, 2015 at 12:20 PM, Mandeep Baluja rockerna...@gmail.com
wrote:
how is your sheet data.??? it contain a single column or multiple columns
??
On Wednesday, May 6, 2015 at 11:11:10 PM UTC+5:30, Chethan wrote:
Hi,
I need some help in modify the
, May 7, 2015 at 6:33 PM, B.N.Chethan Kumar
chetankumar1...@gmail.com wrote:
Yes. it is single column A:A
On Thu, May 7, 2015 at 12:20 PM, Mandeep Baluja rockerna...@gmail.com
wrote:
how is your sheet data.??? it contain a single column or multiple
columns ??
On Wednesday, May 6, 2015
Hi,
I need some help in modify the Macro. Current it combine multiple sheet in
one column. I need to copy each sheet to one column,
Like
Sheet 1 to A
Sheet 2 to B
Sheet 3 to C
Sheet 4 to D
Etc..
Sub Combine()
Dim J As Integer
Dim rey As Range
On Error Resume Next
Sheets(1).Select
Hi
Please help me with macro code. I am trying to send file to each individual.
I need to filter and send the file to each individual. Current i have macro
it work on person.
--
Chethan
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) !
Hi,
Can we create macro in open office calc. I need to send file every hour
using outlook.
Regards
CK
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM
Hi. Please let me how to use HTML code in excel macro. I am trying to login
into a tool and pull a report in PDF format.
Regards
Ck
On Dec 21, 2013 12:46 AM, B.N.Chethan Kumar chetankumar1...@gmail.com
wrote:
Thanks. It worked.
On Dec 19, 2013 11:44 AM, Ravinder ravinderexcelgr...@gmail.com
to extract…
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *B.N.Chethan Kumar
*Sent:* Thursday, December 19, 2013 4:19 AM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Ie
Hi
I am trying to connect IE 9 using vba and create
It worked. . thanks
On Dec 10, 2013 11:29 AM, Ravinder ravinderexcelgr...@gmail.com wrote:
give some examples
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *B.N.Chethan Kumar
*Sent:* Monday, December 09, 2013 6:13 PM
*To:* excel-macros
Hi
I am trying to connect IE 9 using vba and create a loop download data. Any
help.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise,
I am trying to connect Google \ analytics and pull report.
On Dec 19, 2013 10:35 AM, Ravinder ravinderexcelgr...@gmail.com wrote:
Provide website and data you want to extract…
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *B.N.Chethan Kumar
=sharepointdevelopmentlegacy
On Sat, Dec 14, 2013 at 4:15 PM, B.N.Chethan Kumar
chetankumar1...@gmail.com wrote:
Please help.
On Dec 14, 2013 1:58 AM, bhupendra singh raghav
raghav.bhupen...@gmail.com wrote:
Yes
On Dec 14, 2013 1:56 AM, B.N.Chethan Kumar chetankumar1...@gmail.com
wrote:
Hi.
I am
Please help.
On Dec 14, 2013 1:58 AM, bhupendra singh raghav
raghav.bhupen...@gmail.com wrote:
Yes
On Dec 14, 2013 1:56 AM, B.N.Chethan Kumar chetankumar1...@gmail.com
wrote:
Hi.
I am upload excel file to a SharePoint portal. In a day close to 100 file
need to be upload at different
Hi.
I am upload excel file to a SharePoint portal. In a day close to 100 file
need to be upload at different folder. Any macro which can automated it.
Regards
Ck
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of
I have to send excel as attachment to end user. But using different
account. Like using from as a Common I'd
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
You can use code2 outlook addins. It does the same work with ease.
On Apr 9, 2013 12:01 PM, Prabhu Pinky prabhupin...@gmail.com wrote:
Hi,
For testing purpose, i have attached three mail herewith.
This is not (.pst), i have copied sent items in my local folder.
On 9 April 2013 11:56,
://blogs.office.com/b/microsoft-excel/archive/2009/10/23/using-powerpivot-with-excel-2010.aspx
http://blogs.office.com/b/microsoft-excel/archive/2011/05/24/getting-started-with-powerpivot-for-excel.aspx
Regards
Ashish
On Wed, Mar 27, 2013 at 1:04 AM, B.N.Chethan Kumar
chetankumar1...@gmail.com wrote:
Hi
Please help.
On Oct 15, 2012 8:08 AM, B.N.Chethan Kumar chetankumar1...@gmail.com
wrote:
Dear Experts,
Please help me with Macro. I need to assign a auditor for each Policy and
create worksheet for each auditor in same workbook by copy the policy to it.
Kindly refer the attached file. Based
Apology for delay response.
Please find the example of how to use max function with conditonal.
note: these is an array formuale.
Regards
CK
On Fri, Sep 21, 2012 at 3:31 AM, dguillett1 dguille...@gmail.com wrote:
And just HOW is it MORE dynamic??
Don Guillett
Microsoft Excel Developer
Use max function
On Sep 21, 2012 12:43 AM, dguillett1 dguille...@gmail.com wrote:
Put this in the SHEET module
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range(b1)) Is Nothing Then Exit Sub
Dim ss As Worksheet
Dim mf As Range
Set ss = Sheets(Monthly End
check..if these help. check and let me know
Regards
CK
On Wed, Sep 19, 2012 at 2:45 PM, SG sonal...@gmail.com wrote:
Experts,
plz help mei need solution.plz look in to this
On Monday, September 17, 2012 8:20:53 PM UTC+5:30, SG wrote:
Hi Experts,
I'm again in to a problem whic is
, B.N.Chethan Kumar
chetankumar1...@gmail.com wrote:
Apology friends,
Please ignore my previous email.
I need to convert attached PDF to Excel and we have close to 500
documents on weekly basis.
Kindly advice do we have any easy and alternation method for doing it,
Regards
Chethan Kumar
Hi Don,
kindly explain how did you do that.
Regards
CK
On Fri, Jul 20, 2012 at 8:56 AM, dguillett1 dguille...@gmail.com wrote:
See attached file that automatically makes a drop down in range d9 when
you activate the sheet and when you select the date from the drop down will
populate the
Hi,
any update on my request
On Fri, May 25, 2012 at 12:03 PM, B.N.Chethan Kumar
chetankumar1...@gmail.com wrote:
Thanks Pascaal,
Apology for delay response and thanks for working on the macro.
As i was busy with kids first birthday, i did not reply to ur email.
on the query raised
Thanks Pascaal,
Apology for delay response and thanks for working on the macro.
As i was busy with kids first birthday, i did not reply to ur email.
on the query raised. Current, i apply filter and search anything which
start as Win group them under Brokerage win. Like wise TCAP under
Dear friends,
Do we have any macro which will automatic will update slide in PPT with
same size and shape. If it is possible, please help with it.
--
B.N Chetan kumar
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
Please find the data in required format.
Regards
Chethan Kumar BN
On Wed, Dec 14, 2011 at 12:46 PM, Anil Saxena anilsaxena170...@gmail.comwrote:
Plz let me know that how can possible to % in pivot table. base of Caller.
Plz show the snap short also.
--
FORUM RULES (934+ members already
Please find the table in comparsion model. I have used pivot table option.
Regards
Chethan kumar BN
On Wed, Dec 14, 2011 at 11:07 AM, Darwin Chan
darwin.chankaw...@gmail.comwrote:
Dear all,
I have 2 tables concerning sales volume of several customers across 2
months. I want to make a
Please find the information as requested
On Sat, Dec 3, 2011 at 1:25 AM, Aamir Shahzad aamirshahza...@gmail.comwrote:
Dear Group,
I am using Countifs function how I give the second criteria e.g. I want
9 it's mean only pick the buckets of 10,11 12. See the attached file
plz.
Regards,
*From:* B.N.Chethan Kumar chetankumar1...@gmail.com
*Sent:* Tuesday, November 29, 2011 5:03 PM
*To:* excel-macros@googlegroups.com
*Subject:* Re: $$Excel-Macros$$ Need Help
Hi,
Thanks these help.
But need some additional input. these work only PST or OST file...can u
help with any
Guillett
SalesAid Software
dguille...@gmail.com
*From:* B.N.Chethan Kumar chetankumar1...@gmail.com
*Sent:* Tuesday, November 29, 2011 4:04 PM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Need Help
Hi All,
I got these Macro template from one guys of these group some
Hi Sunnie,
The attached file with the condition format. Hope these is what your
requirment was.
Regards
Chethan Kumar BN
On Thu, Nov 24, 2011 at 5:18 AM, Susan 1 sunni...@gmail.com wrote:
I’m having trouble using the conditional formatting.
I’m trying to get a calculated value (would like to
Hi Kent,
I have attached the file with custom format. Kindly check if these help.
Regards
Chethan Kumar BN
On Fri, Oct 28, 2011 at 9:57 PM, HarryP Knuckles kent.bouc...@tbs-sct.gc.ca
wrote:
Hi guys!
I have a quick question regarding formats. I have to
convert english accounting
Thanks SAM,
I missed that part. please find the updated format.
Regards
Chethan Kumar BN
On Sat, Oct 29, 2011 at 3:15 AM, Sam Mathai Chacko samde...@gmail.comwrote:
The OP had requested for the decimal separator to be a comma (,)
Sam
On Sat, Oct 29, 2011 at 3:07 AM, B.N.Chethan Kumar
Hi,
Please find some more example on sum product.
Regards
Chethan Kumar BN
On Tue, Oct 18, 2011 at 10:59 AM, ashish koul koul.ash...@gmail.com wrote:
http://www.bygsoftware.com/Excel/functions/sumproduct.htm
http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/
Hi,
Lot of option you as suggested by many expert.
if the data need to extract to 2 different formt..
Use below formualeInt( a1)Date and Mod(a2,1)---time...change the
format of cell as required.
Happy learning
Regards
Chethan Kumar BN
On Tue, Oct 18, 2011 at 3:02 PM, Muhammad Arslan
Hi,
http://datapigtechnologies.com/blog/index.php/recordset-tricks-in-excel-1-filling-a-combobox-with-unique-values/
Hope these link help u better.
On Mon, Oct 17, 2011 at 11:03 PM, ICWAI Help icwai.answ...@gmail.comwrote:
Hello,
I have a pivot table which is dynamic which is going to be
Hi,
Hope these help, Drag the file down untill last row of the data sheet.
On Wed, Oct 12, 2011 at 6:40 PM, Ahmed Honest ahmedhon...@gmail.com wrote:
Dear Mr. Shiek,
Tons of thanks for your help. I hope that U achieved it by VBA but is there
any formula of excel to achieve this?
Dear Mr.
On Thu, Oct 6, 2011 at 10:56 AM, B.N.Chethan kumar
chetankumar1...@gmail.com wrote:
Hi,
As the data volume is high... i will have 100 to 200 sheets in a
month..hence take more time
Can we write any macro to convert for all sheet in the work book.
Thanks Asa Rossoff...i will try
Once i faced some issue. these happen because of comments updated in
previous excel sheer from where data was copied..
i also not able hide columns. Select worksheet and remove comments (excel
2007 steps)
Removing Comments from All Cells
1.
Open the sheet with the comments to be deleted
Hi All,
I have attached file where i get some data in text format. I need convert to
date and time format.
Currently using text to coloumn method which is manually pocess. As sheet
count is high in a workbook, these is very painful work to do in month end.
Kindly request your help to very
(A3,FIND( ,A3)+1,3)/RIGHT(A3,4))
Regards,
Sam Mathai Chacko (GL)
On Thu, Oct 6, 2011 at 10:20 AM, B.N.Chethan kumar
chetankumar1...@gmail.com wrote:
Hi All,
I have attached file where i get some data in text format. I need convert
to date and time format.
Currently using text
-macros@googlegroups.com] *On Behalf Of *B.N.Chethan kumar
*Sent:* Wednesday, October 05, 2011 9:50 PM
*To:* excel-macros@googlegroups.com
*Subject:* $$Excel-Macros$$ Need a help -very urgent
** **
Hi All,
I have attached file where i get some data in text format. I need
Hi,
you have option to group the file...Bring the data in excel pivit..and right
clickselect group...and select group by year..
you can also group my month Quarter too..
Regards
Chethan Kumar BN
On Tue, Oct 4, 2011 at 1:32 AM, John A. Smith johnasmit...@gmail.comwrote:
Attached is
congrate mate
On Sun, Oct 2, 2011 at 8:40 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Group,
Our Group Manager Mr. Ayush Jain has been awarded the Microsoft MVP award
for the 2nd year in row...
Congrate Ayush
--
Thanks regards,
Noorain Ansari
(d2-c2)*24*60 ...change format to number
Regards
Chethan Kumar
On Fri, Sep 30, 2011 at 1:36 AM, dguillett1 dguille...@gmail.com wrote:
=(D2-C2)*24
*From:* John A. Smith johnasmit...@gmail.com
*Sent:* Thursday, September 29, 2011 2:55 PM
*To:* excel-macros@googlegroups.com
*Subject:*
49 matches
Mail list logo