Re: $$Excel-Macros$$ Re: Outlook 2016 - Macro Help!

2016-09-19 Thread Learner Excel
No, You can not record macro on Outlook, if you are looking for basic of outlook macro thn please refer below url- http://www.easytweaks.com/add-macros-outlook-2016/ -- On Mon, Sep 19, 2016 at 8:54 PM, dza49 wrote: > Anyone have any idea on how to record macros in Outlook and have a place > w

$$Excel-Macros$$ Re: Outlook 2016 - Macro Help!

2016-09-19 Thread dza49
Anyone have any idea on how to record macros in Outlook and have a place where I can research each individual step in VBA? Thanks, Daniel -- 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

Re: $$Excel-Macros$$ Re: Outlook Mail Details to Excel

2015-05-27 Thread Sundarvelan N
We have option to export from outlook. But in that export there is no date, if that possible my problem would be solved. Thanks N.Sundarvelan 9600160150 On Wed, May 27, 2015 at 7:01 PM, Mandeep Baluja wrote: > Mail is too huge to reside in a cell. > > On Wednesday, May 27, 2015 at 6:58:27 PM U

Re: $$Excel-Macros$$ Re: Outlook Mail Details to Excel

2015-05-27 Thread Mandeep Baluja
Mail is too huge to reside in a cell. On Wednesday, May 27, 2015 at 6:58:27 PM UTC+5:30, Sundarvelan wrote: > > Sorry, > > Im getting the attached error. > > Thanks > N.Sundarvelan > 9600160150 > > On Wed, May 27, 2015 at 6:44 PM, Mandeep Baluja > wrote: > >> check this out >> >> Regards, >> Ma

Re: $$Excel-Macros$$ Re: Outlook Mail Details to Excel

2015-05-27 Thread Mandeep Baluja
check this out Regards, MandeepBaluja Learningzmypassion. https://www.facebook.com/groups/825221420889809/ https://www.linkedin.com/profile/view?id=312532939 On Wednesday, May 27, 2015 at 6:11:07 PM UTC+5:30, Sundarvelan wrote: > > Sorry, I'm getting error. > > I expecting file like the attach

Re: $$Excel-Macros$$ Re: Outlook Mail Details to Excel

2015-05-27 Thread Sundarvelan N
Sorry, I'm getting error. I expecting file like the attached. Could you please include Body of the mail in the attached macro file. Thanks N.Sundarvelan 9600160150 On Wed, May 27, 2015 at 5:02 PM, Mandeep Baluja wrote: > Working find just enable microsoft outlook 14.0 librarary and set the da

Re: $$Excel-Macros$$ Re: Outlook Mail Details to Excel

2015-05-27 Thread Mandeep Baluja
Working find just enable microsoft outlook 14.0 librarary and set the date as per your requirement basically what the code is doing to fetch details of mails of last two days. On Wednesday, May 27, 2015 at 4:53:57 PM UTC+5:30, Sundarvelan wrote: > > I'm using this code in Outlook > > Thanks > N.

Re: $$Excel-Macros$$ Re: Outlook Mail Details to Excel

2015-05-27 Thread Sundarvelan N
I'm using this code in Outlook Thanks N.Sundarvelan 9600160150 On Wed, May 27, 2015 at 4:19 PM, Mandeep Baluja wrote: > send me the file with this code then I can understand the problem. > > Regards, > Mandeep Baluja > > > > > On Wednesday, May 27, 2015 at 3:37:00 PM UTC+5:30, Sundarvelan wrote

Re: $$Excel-Macros$$ Re: Outlook Mail Details to Excel

2015-05-27 Thread Mandeep Baluja
send me the file with this code then I can understand the problem. Regards, Mandeep Baluja On Wednesday, May 27, 2015 at 3:37:00 PM UTC+5:30, Sundarvelan wrote: > > Dear Mandeep, > > I'm getting error in the below line. > > Please help. > >lr = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).Of

Re: $$Excel-Macros$$ Re: Outlook Mail Details to Excel

2015-05-18 Thread Mandeep Baluja
Enable outlook library in reference and use this code. you can change the date criteria to get the updated mails. Sub GetFromInbox() Dim olApp As Outlook.Application Dim olNs As Namespace Dim Fldr As MAPIFolder Dim olMail As Variant Dim i As Integer Set olApp = New Outl

Re: $$Excel-Macros$$ Re: Outlook Mail Details to Excel

2015-05-18 Thread Sundarvelan N
But I want Macro Excel File that will auto update all mail details in excel periodically. Please help!!! Thanks N.Sundarvelan 9600160150 On Mon, May 18, 2015 at 2:11 PM, Sundarvelan N wrote: > Thanks Mandeep!!! > > Thanks > N.Sundarvelan > 9600160150 > > On Mon, May 18, 2015 at 11:21 AM, Mande

Re: $$Excel-Macros$$ Re: Outlook Mail Details to Excel

2015-05-18 Thread Sundarvelan N
Thanks Mandeep!!! Thanks N.Sundarvelan 9600160150 On Mon, May 18, 2015 at 11:21 AM, Mandeep Baluja wrote: > Go to file option Click on open then export it to excel , you can export > any folder to a excel file. > > Regards, > Mandeep Baluja > > > > > On Monday, May 18, 2015 at 10:47:24 AM UTC+5

$$Excel-Macros$$ Re: Outlook Mail Details to Excel

2015-05-17 Thread Mandeep Baluja
Go to file option Click on open then export it to excel , you can export any folder to a excel file. Regards, Mandeep Baluja On Monday, May 18, 2015 at 10:47:24 AM UTC+5:30, Sundarvelan wrote: > > Dear Friends, > > Is there any possibilities copy, Subject, From Name with email Address, >

$$Excel-Macros$$ Re: Outlook 2010 : VBA Macro for sending image in HTML Body doesn't display correctly

2014-02-02 Thread Edouard Letort
Hello, First you need to create an outlook mail object, then, write the mail body (in html) with the appropriate tag. Please note following points : - embedded images must be save on your computer (as a jpg file or png file) ; - Since outlook 2013, embedded images must be attached to the ema

$$Excel-Macros$$ Re: Outlook 2010 : VBA Macro for sending image in HTML Body doesn't display correctly

2013-09-29 Thread Trabelsi Hichem
Any news since ?? Le jeudi 26 septembre 2013 08:03:18 UTC+1, Trabelsi Hichem a écrit : > > Hello, > > I Use the following code to send emails automatically with embedded image > in the HTML body, this worked with Office 2003, but when i upgrated to > Office 2010 it doesnt work anymore, the image

$$Excel-Macros$$ Re: Outlook 2010 : VBA Macro for sending image in HTML Body doesn't display correctly

2013-09-26 Thread Trabelsi Hichem
I already found the solution, i shouldnt use the cid method, but i had to > put the entire path of the image > Thank you so much anyway :) -- 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:/

RE: $$Excel-Macros$$ Re: Outlook 2010 : VBA Macro for sending image in HTML Body doesn't display correctly

2013-09-26 Thread Ravi Kumar
Ok, I’ll try. Warm Regards, Ravi Kumar. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Trabelsi Hichem Sent: Thursday, September 26, 2013 12:52 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Outlook 2010 : VBA Macro for

$$Excel-Macros$$ Re: Outlook 2010 : VBA Macro for sending image in HTML Body doesn't display correctly

2013-09-26 Thread Trabelsi Hichem
Hello Again, Thank you Ravi for your quick answer , but the instruction here " .Body = Ebody " will show in the body the string " Testing VBA's ability to send an email.", i want the attached image to be displayed normally in the body that's the problem, it worked before on Office 2003 but no

$$Excel-Macros$$ Re: Outlook Folder Items Information

2010-12-15 Thread roberto mensa
look here if that's what you mean: http://www.erlandsendata.no/english/index.php?d=envbaolecontroloutlook Sub ListAllItemsInInbox() regards r 2010/12/13 Santosh Vishwakarma > > Hi > > Can any one let me know how to get the information about outlook folder > items (Inbox) and get them in reco

Re: $$Excel-Macros$$ Re: Outlook Problem

2010-07-14 Thread Devang Bhatt
i have been in huge trouble using delay delivery in MS outlook 2003. it did not work when i set it beyond 1 week by a specific date and time. it worked if i set it on the same day. dont know what went wrong with longer time frame. On Thu, Jul 15, 2010 at 9:38 AM, Rajender Soni wrote: > Hi > > The

$$Excel-Macros$$ Re: Outlook Problem

2010-07-14 Thread JsinSk
Open a new message, in the tool bar (same row as the send button) is the options tab, click. A new screen will open and you can check under delivery options do not deliver before a set time. >From what I know, Outlook must be left open for it to send. Someone else may know differently though. I'v

Re: $$Excel-Macros$$ Re: Outlook and excel integration

2010-03-24 Thread rf1234 rf1234
Hello Dear Please have a view in.. http://groups.google.com/group/excel-macros/browse_thread/thread/460883072a940f4e Hope it Will Help Happy to Help :) Shyam On Tue, Mar 23, 2010 at 4:05 PM, rf1234 rf1234 wrote: > Hello Dear > Mail sent macro is already discussed with code. > > Try to e

Re: $$Excel-Macros$$ Re: Outlook and excel integration

2010-03-23 Thread rf1234 rf1234
Hello Dear Mail sent macro is already discussed with code. Try to execute that code if expiry date condition fulfill. Hope it will Help Happy to help :) Shyam On Mon, Mar 22, 2010 at 5:12 PM, ~ Z A H E E R ~ wrote: > Sorry, Plz read as > Is it possible to integrate MS Outlook 2007 and M

$$Excel-Macros$$ Re: Outlook and excel integration

2010-03-22 Thread ~ Z A H E E R ~
Sorry, Plz read as Is it possible to integrate MS Outlook 2007 and MS Excel 2007. On Mon, Mar 22, 2010 at 12:39 PM, ~ Z A H E E R ~ wrote: > Dear Members, > > Is it possible to integrate MS Office 2007 and MS Excel 2007. > > For Eg. > I have 1 excel file contains Employee ID, Employee Name, CI

$$Excel-Macros$$ Re: Outlook

2009-08-12 Thread Paul Schreiner
Paul From: Sahil Thakkar To: MS EXCEL AND VBA MACROS Sent: Tuesday, August 11, 2009 1:56:34 PM Subject: $$Excel-Macros$$ Re: Outlook thank for the reply. But I do not want to use excel to send email. May I know if there is a work around to automatically fill subject lin

$$Excel-Macros$$ Re: Outlook

2009-08-11 Thread Sahil Thakkar
thank for the reply. But I do not want to use excel to send email. May I know if there is a work around to automatically fill subject line, TO and CC field whenever I click on reply or forward? Regards On Aug 2, 7:10 pm, mahesh parab wrote: > Hi Sahil > > below mention link will help you. > > h

$$Excel-Macros$$ Re: Outlook

2009-08-02 Thread mahesh parab
Hi Sahil below mention link will help you. http://www.rondebruin.nl/sendmail.htm On 8/2/09, Sahil Thakkar wrote: > > > Hi, I need your help. > > I use to send about 400 emails daily and want outlook to autofill the > subject line whenever I click on reply or forward. (Do not want it for > new

$$Excel-Macros$$ Re: Outlook urgent

2009-07-08 Thread Chidurala, Shrinivas
Sent: Wednesday, July 08, 2009 1:33 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Outlook urgent I am no expert with Outlook. But as I figure it out, it looks like if the attached file is embedded in RTF. If this is exact, you can't have plain text format with attached

$$Excel-Macros$$ Re: Outlook urgent

2009-07-08 Thread Daniel
gards. Daniel > -Message d'origine- > De : excel-macros@googlegroups.com [mailto:excel- > mac...@googlegroups.com] De la part de Chidurala, Shrinivas > Envoyé : mardi 7 juillet 2009 18:54 > À : excel-macros@googlegroups.com > Objet : [Norton AntiSpam] $$Excel

$$Excel-Macros$$ Re: Outlook urgent

2009-07-07 Thread Chidurala, Shrinivas
- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]on Behalf Of Daniel Sent: Monday, July 06, 2009 6:10 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Outlook urgent Hello. Try : Sub SimpleMail() Dim olApp, m Set olApp = CreateObject

$$Excel-Macros$$ Re: Outlook urgent

2009-07-06 Thread Daniel
> Please can u help on this. > > Regards, > Shrinivas > Query Unit > Securities Services > Global Transaction Services - India. > Ph: +91-80-41446339 > E-Mail: shrinivas.chidur...@citi.com > > -Original Message- > From: excel-macros@googlegroups.com > [mail

$$Excel-Macros$$ Re: Outlook urgent

2009-07-05 Thread Chidurala, Shrinivas
- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]on Behalf Of Daniel Sent: Saturday, July 04, 2009 8:06 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Outlook urgent Hi, Shrinivas. Try : Sub SimpleMail() Dim olApp, m Set olApp

$$Excel-Macros$$ Re: Outlook urgent

2009-07-04 Thread Daniel
Hi, Shrinivas. Try : Sub SimpleMail() Dim olApp, m Set olApp = CreateObject("Outlook.application") Set m = olApp.CreateItem(olMailItem) With m .Subject = "Subject" .Body = "Dear All," & Chr(10) & Chr(10) & _ "Find attached report as of 04-Jul-2009." &