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 =EXP(E:
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 of
--
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,
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 ""
'
xlPasteAll
> Else
> Selection.Offset(0, 1).PasteSpecial Paste:=xlPasteAll
> End If
>
> Next
> End Sub
>
>
> On Thu, May 7, 2015 at 6:33 PM, B.N.Chethan Kumar <
> chetankumar1...@gmail.com> wrote:
>
>> Yes. it is single column "A:A
Yes. it is single column "A:A"
On Thu, May 7, 2015 at 12:20 PM, Mandeep Baluja
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 Macro.
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
Worksheets.A
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) ! Join
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 RULE
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"
wrote:
> Thanks. It worked.
> On Dec 19, 2013 11:44 AM, "Ravinder" wrote:
>
&g
It worked. . thanks
On Dec 10, 2013 11:29 AM, "Ravinder" 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
> *
Thanks. It worked.
On Dec 19, 2013 11:44 AM, "Ravinder" wrote:
> Try this if looking for this.. actually in this you can login in yahoo
> and gmail through form…
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behal
I am trying to connect Google \ analytics and pull report.
On Dec 19, 2013 10:35 AM, "Ravinder" wrote:
> Provide website and data you want to extract…
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *B.N.Chet
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,
arepointdevelopmentlegacy
>
>
> 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:
>>
>&
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"
> wrote:
>
>> Hi.
>> I am upload excel file to a SharePoint portal. In a day close to 100
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 this
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" 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, Abhishek Jain wr
aspx
>
> http://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
Hi, please help me some material on useage of power pivot in ms office 2010.
--
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, accurat
Please help.
On Oct 15, 2012 8:08 AM, "B.N.Chethan Kumar"
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 attac
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 wrote:
> And just HOW is it MORE dynamic??
>
> Don Guillett
> Microsoft Excel Developer
> SalesAid Softwa
Use max function
On Sep 21, 2012 12:43 AM, "dguillett1" 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 Prices")
> Se
check..if these help. check and let me know
Regards
CK
On Wed, Sep 19, 2012 at 2:45 PM, SG 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 silly but
gt;
> Sagar
> On Tue, Sep 11, 2012 at 10:22 AM, 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
>> docum
Hi Don,
kindly explain how did you do that.
Regards
CK
On Fri, Jul 20, 2012 at 8:56 AM, dguillett1 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 cells.
>
>
> Don Gu
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 em
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 Pl
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
wrote:
> Dear all,
>
> I have 2 tables concerning sales volume of several customers across 2
> months. I want to make a comparison on the sales volume
Please find the data in required format.
Regards
Chethan Kumar BN
On Wed, Dec 14, 2011 at 12:46 PM, Anil Saxena wrote:
> 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 BANNED for violation)
>
Please find the information as requested
On Sat, Dec 3, 2011 at 1:25 AM, Aamir Shahzad wrote:
> 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,
>
> Aamir Shahzad
oftware
> dguille...@gmail.com
>
> *From:* B.N.Chethan Kumar
> *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 on
Guillett
> SalesAid Software
> dguille...@gmail.com
>
> *From:* B.N.Chethan Kumar
> *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
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 wrote:
> I’m having trouble using the conditional formatting.
> I’m trying to get a calculated value (would like to use the IF functi
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 wrote:
> 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 Kuma
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 wrote:
> Hi guys!
> I have a quick question regarding formats. I have to
> convert english accounting procedures into French a
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 w
Hi,
Please find some more example on sum product.
Regards
Chethan Kumar BN
On Tue, Oct 18, 2011 at 10:59 AM, ashish koul wrote:
> http://www.bygsoftware.com/Excel/functions/sumproduct.htm
>
> http://chandoo.org/wp/2009/11/10/excel-sumproduct-formula/
>
> http://www.exceluser.com/explore/sumpro
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 wrote:
> Hello,
>
> I have a pivot table which is dynamic which is going to be change
> every time whe
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 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. Don Guillet,
>
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
t testing the previous one.
>>
>>
>> Regards,
>>
>> Sam Mathai Chacko (GL)
>>
>>
>> On Thu, Oct 6, 2011 at 10:57 AM, Sam Mathai Chacko
>> wrote:
>>
>>> Range("A3:A6").TextToColumns Range("A3"), 0, 1, False
problem.
>
> ** **
>
> Asa
>
> ** **
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *B.N.Chethan kumar
> *Sent:* Wednesday, October 05, 2011 9:50 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Exc
quot;&MID(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 f
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 painf
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 wrote:
> Attached is a spreadsheet from th
congrate mate
On Sun, Oct 2, 2011 at 8:40 PM, NOORAIN ANSARI wrote:
> 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
> *http://excelmacroworld.blogspot.com
(d2-c2)*24*60 ...change format to number
Regards
Chethan Kumar
On Fri, Sep 30, 2011 at 1:36 AM, dguillett1 wrote:
> =(D2-C2)*24
>
> *From:* John A. Smith
> *Sent:* Thursday, September 29, 2011 2:55 PM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Incremental Time Ca
50 matches
Mail list logo