Using 2002 To Send Emails Via Outlook 2002

Feb 20, 2009

I am trying to send emails using a table in Xl2002 via outlook2002.

The code below is from Walkenbach's VBA Bible for Excel 2003 and I am getting "Uesr-type not defined" error with the 1st Dim statement.

Do I need a different statement such as set OutObj = blahblah or similar?? I have searche dthe net hi & lo for a solution to this problem & I do have JW's excel VBA bible.


Sub SendEmail()
'Uses early binding
'Requires a reference to the Outlook Object Library
Dim OutlookApp As Outlook.Application
Dim MItem As Outlook.MailItem
Dim cell As Range
Dim Subj As String
Dim EmailAddr As String
Dim Recipient As String
Dim Bonus As String
Dim Msg As String

View 9 Replies


ADVERTISEMENT

Excel Macro That Will Send Emails From Outlook

Feb 13, 2014

I got this VBA code from a colleague which he uses when sending multiple emails from Outlook. This code sends email based from the last cell. What I would like to do is send emails to all the recipients listed in column C. Column A will be the sender and column B will be email subject. Attached is the sample file.

[Code] .....

Send email.xlsm‎

View 2 Replies View Related

Excel 2007 :: Send Automatic Emails To Outlook?

Jun 16, 2014

I am working on a spreadsheet that keeps track of upcoming contract and service renewals. Within the spreadsheet there is a column named "Status"; using a formula based on the renewal and engagement dates this column will automatically state one of the following -

"Contract Status OK"
"Up for Renewal"
"Renewal Due"

When I open the the file I would like excel to email 2 specific email addresses. The email should only contain data from the rows that state "up for renewal"; this email will act as trigger for my team to engage with the suppliers in question.

View 2 Replies View Related

Hlookup Stonedead In 2002

Apr 5, 2008

Is the Hlookup funktion not included in Excel 2002? I've been trying to run basic exemples from microsoft, and ones made by myself, and I just can't get it to work. Excel just keeps telling me that's it wrong in the formula. I really need hlookup work.

View 13 Replies View Related

Reviewing Toolbar In 2002

Nov 5, 2008

I hate this toolbar.

I have no need for it but would like it to remain in the list of available toolbars (eg when i go View>Toolbars).

When i uncheck it from the list it disappears (hooray!) but the little b*stard is always back on my screen the next time I open Excel (this is in contrast to any other toolbars I hide/make visible which are always hidden/visible as expected - hence I don't think it's an .xlb problem).

has anyone got an explanation as to why and, better yet, a way to get the problem child off of my Excel (without removing it from the toolbar menu list)? Because I'm at work I can't modify Registry settings by the way.

View 9 Replies View Related

2002 Sheet Protection

Feb 20, 2003

Is it true that the sheet protection in excel is practicaly none ?

Not even excel 2002 (XP) prevents simple cracking software from removing sheet protection.

Are there any master keys that cause that ?

Is there a way to protect a sheet with strong encryption ?

View 8 Replies View Related

2002 Recalculating With Every Change To Spreadsheet

Jun 27, 2008

I have a workbook in xl2002 that has a data sheet with approx 50 columns and 500 rows which is populated from a querytable querying another workbook. There are no formulas on this data sheet.

I have another 5 sheets, only one of which actually has formulas on it and these refer to the Data sheet above (some fairly beefy Sumproduct formulas in the main, but only 1056 in total (only about 650 of these are Sumproducts - the remainder are simple = A1 type or Match formulas with the third argument as True (ie quite efficient)).

There are also 3 dynamic named ranges in the workbook, which are utilised by the Sumproducts/matches. An example Sumproduc is as follows:....

View 9 Replies View Related

2002 XP Pro, Says 65536 Cells But Only 1407

Aug 14, 2008

I have excel 2002 XP Professional, and the problem I am having is that Excel keeps saying I am using 65536 cells but I am only using 1406, I have tried pressing clear contents on them and delete, but this only makes it lag for 15 minutes and still says the same.

Code:

View 9 Replies View Related

Creating Written Summary In 2002

Sep 1, 2008

I am creating a financial summary on a worksheet and I want to be able to write up a summary about each category. Is there a way that I could write text on my worksheet and create a parameter where my text could go to the next line such as a word document?

View 9 Replies View Related

VBA Code For Text To Column In 2002

Mar 6, 2006

I have a report with details for a large number of countries. Each month, I need to copy the country details and move them to a sheet specific to that country,
e.g. UK details to a UK folder, Germany details to a DE folder. The level of details available is different for each country. So there may be 10 lines for the UK but only 5 for Germany. However, the country details always start with (e.g.) 'COUNTRY: UK' and end with ' TOTAL FOR: UK.'

View 9 Replies View Related

Excel 2002 :: Limitations In Shared Workbook

Jul 20, 2013

I am using excel 2002 and I have found that when the workbook is shared and getting 2 or more users to open the workbook around the same time brings up a read only type prompt box for the 2nd ( and 3rd) user when the book hasn't fully opened for the 1st user/is still fully opening. Is this a limitation within excel or is there a way around this for example via vb code.

I know the more data a workbook has can cause it open a lot slower but is this the same for shared mode.

View 5 Replies View Related

Excel 2002 :: Formula To Display All Errors?

May 27, 2012

In a worksheet the data (text or numerical) from five columns are compared using the following formula.

=IF($A10$G10,"1ERROR",IF($B10$H10,"2ERROR",IF($C10$I10,"3ERROR",IF($D10$J10,"4ERROR",IF($E10$K10,"5ERROR","-")))))

The formula is working well. The problem is I get the result for the first column of error even if the error is in more than one column. I want the result should display all the errors with the column number 1, 2, 3 (or with column name A, B, C etc). The total number of error is not required. The exact columns which have the error should be displayed. For example if the error exists in 3, 4 and 5 columns, I should get the result as "345Error" or "CDEError".I use excel 2002.

View 6 Replies View Related

Excel 2002 :: Updating Separate Sheets

Oct 8, 2012

I've got Excel 2002. I am devising a sheet for checking work (sheet A) which feeds onto a separate sheet (sheet B). If I wanted to delete info from sheet A can I retain the info on sheet B? I want sheet A to be used repeatedly for each case but the info for every case to be recorded row by row on sheet B.

View 4 Replies View Related

Excel 2002 :: Conditional Formatting And Formulas?

Jun 11, 2013

I'm currently trying to set up a spreadsheet on excel, when certain documents need updating. Basically I have a column with the dates in that each document was last updated, I want the cells to turn red (fill colour) if the document has not been updated within the last 6 months and orange (fill colour) if the document has not been updated in the last 4 months. How do I do this?

I am currently using Excel 2002 and am on a Windows XP computer.

View 1 Replies View Related

SaveAs Method Working In Both 2002 & 2000

Sep 19, 2007

We're gradually moving over to Excel 2007 (from 2002) at my workplace.

My problem is that I need to run macros on both versions but I'm having trouble with the SaveAs method.

I have Excel 2007 set to save automatically in Excel 97-2003 File Format but this doesn't seem to apply to files saved using VBA.

My original 2002 code is as follows:

Workbooks.Add
ActiveWorkbook.SaveAs Filename:="C:ReportsNewFile.xls"
and 2007
Workbooks.Add
ActiveWorkbook.SaveAs Filename:="C:ReportsNewFile.xls", FileFormat:=xlExcel8

How can I get it to switch depending on the version it's run on? Unfortunately Excel 2002 doesn't recognise '=xlExcel8' so I don't think I can use an If/Else statement on the version number.

View 10 Replies View Related

Convert Date Format 3/31/2002 To 1Q2003

Apr 2, 2008

Need the formula to turn a date into a quarter and year

1/15/2003 would be 1Q2003
5/15/2005 would be 2Q2005
11/10/2007 would be 4Q2007

View 9 Replies View Related

Differences With Find Method In 2000 And 2002

Jun 15, 2007

I am using the following code which works in microsoft 2002, but not in 2000. When I run it in 2000 it says " Named argument not found." The debugger highlights the line Set C through delete.

Sub DeleteRows()
Dim c As Range

With Worksheets("Sheet1").Range("A1", Worksheets("Sheet1").Range("A" & Rows.Count).End(xlUp))
Do
Set c = . Find(What:=" ", After:=[A1], LookIn:=xlValues, _
LookAt:=xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False)
If Not c Is Nothing Then c.Resize(12).EntireRow.Delete
Loop While Not c Is Nothing
End With
End Sub

View 7 Replies View Related

Excel 2002 :: VBA Looping Copy / Paste Special For Each Row

Jan 25, 2012

Excel 2002.I have data in columns A and B on sheet 3, starting at row 100. The total number of rows of data is variable (max is 50 rows). I want to take the values in A100:B100 and copy them from Sheet3 and paste values transposed to SheetTL Range C1:C2. I have started to write the following code but as you can see I will have to repeat the code upwards of 50 times. It seems I should be able to do a COUNT function to see how many rows of data exist and then somehow loop the code to copy the data from each subsequent row that many times, but how to put that together.

Sheets("Sheet3").Range("A100:B100").Copy
Sheets("TL").Range("C1").PasteSpecial Paste:=xlPasteValues, Transpose:=True
ActiveSheet.PrintOut
If Sheets("Sheet3").Range("A101") = "" Then

[Code] .........

View 5 Replies View Related

Excel 2002 :: Binding Fill Color To A Cell

Jan 26, 2012

I have a workbook in which there is a sheet containing a table.

Excel 2002ABC123Specific Gravity6 Volt ValuesSOC40.0000.000Dead
51.1345.97010%61.1485.99020%71.1626.02030%81.1766.06040%91.1906.10050%101.1976.12055%
111.2046.14060%121.2116.16065%131.2186.18070%141.2256.20075%151.2336.23080%161.2416.26085%
171.2496.31290%181.2576.32095%191.2656.350100%SOC Chart

From another sheet I query this table using the LOOKUP function to obtain values from column C such as 25% 60% and so on. A typical query formula looks like this:

=LOOKUP(B2,'SOC Chart'!B4:'SOC Chart'!C19)

It would be nice if the fill color came along with the value.

View 3 Replies View Related

Excel 2002 :: Activate Macro By Clicking A Shape

Feb 3, 2013

I found in an old file that i triggered the macro by clicking a button! I would post a pic but i don't know how. How do I activate a macro by clicking a shape on the excel 2002 page?

View 7 Replies View Related

Excel 2002 :: Running Total With Dropdown Lists?

Sep 10, 2013

Basically, I have an excel spreadsheet with different valued items for example,

TV Essential l £15
TV Essential extra l £20

Broadband Essential l £ 8
Broadband Extra l £12

I have options for TV, Broadband and Phone. At the bottom of the spreadsheet I want three drop down lists to pick what TV, Broadband and Phone package I want. For example: TV Essential, Broadband Extra and Phone Weekend. I can create the lists but I was wondering if there was anyway where, as you select the option on each of the lists, a running total will be created. So when TV Essential is selected £15 is added to a cell, say F20. Then when Broadband Extra is selected another £12 is added to cell F20. And as you select different ones in each list the total in F20 changes.

I'm using Excel 2002.

View 1 Replies View Related

Excel 2002 :: Does Saving File As Unicode Save It In UTF-8 Or UTF-16 Format

Jan 14, 2011

what format is used when you save an excel file as "unicode." I am using excel 2002 on XP.

I have been asked to provide a UTF-8 formatted unicode file for use by another program but I am not sure which formatting excel uses.

View 3 Replies View Related

Excel 2002 :: Setting Variable To Select All Worksheets In Workbook

Jan 20, 2012

I've got some code which some one posted me a link to on here which set up a pivot table on more that 1 sheets (using excel 2002).

I inserted this code into a rountine I do daily which works fine.

The problem Im having is that Im getting more and more info which I need to pivot over more than one sheet. So I was going to amend the rountine so It picked what ever sheets are in the work book to pivot.

At the moment I have to go into the code and name the sheets to pivot. Is there some code which can work out how many sheets that need pivoting and just do it with out naming them? and also just add a new sheet with the pivot on rather than having to name the destination?

I've posted the code i got given below and have highlighted the bit where I have to name the sheets.

Code:
'---------------------------------------------------------------------------------------
' Procedure : CreateConnection
' Author : KL (Kirill Lapin)
' Date : 18/08/2009

[Code]....

View 8 Replies View Related

Excel 2002 :: Modify Formula To Merge Numerical With Text

Apr 21, 2012

I am using the following formula to find out the No. of "HH" in the range given and I am getting the results simply with numerical value as 2, 3 etc. I want the result should be displayed as 2HH, 3HH depending upon the No. of "HH" available in the given range. The result should be displayed as (the No. added with the text "HH").

=IF(AND(DJ10="HH"),COUNTIF(DF10:DJ10,"HH"),"-")

I use excel 2002.

View 2 Replies View Related

Excel 2002 :: Conditional Formatting Based On Date In Adjacent Cell

May 22, 2012

I have columns of figures with times like 5:52:54 and next to them cells with values that i wish to format based on the time.
that is if the time on the adjacent cell is before 8AM then make the value cell have a red border it does not have to be conditional formatting - Excel 2002 in win7/64

View 9 Replies View Related

Excel 2002 :: Conditional Formatting - If All Cells Match Background In One Cell To Change To Green

Apr 7, 2014

Excel 2002

I have a simple spreadsheet and am trying to get some Conditional Formatting to work.

Cell1 = Name
Cell2 = 1
Cell3 = 2
Cell4 = 3

If cells 2, 3, and 4 all match I want the background in cell 1 to change to green.

I've tried (Formula Is =B1=C1=D1 green) with no luck.

View 5 Replies View Related

Excel 2002 :: Files Corrupted - No Cells Just A Grey Space Where Cells Should Be?

Mar 9, 2012

I am using Excel 2002 and have had a couple of files that seem to have become corrupted recently. When I try to open the files there is nothing there, no cells just a grey space where the cells should be. When I try to close Excel it asks me if I want to save changes when no changes have been made.

I had not made any changes to the sheets prior to this happening so am struggling to work out what is going on.

View 2 Replies View Related

VBA To Create Outlook Emails?

Jul 21, 2014

I have successfully adapted some code to create e-mails in outlook, insert text, add an attachment and specific who to send - all from within excel.

However, all of the recipients are contacts in our internal address book and what I would like to do is use the "shortened" version of their contact to send the e-mail.

e.g. Simon Jones e-mail address might be simon.jones@mycompany.co.uk - but if I simply type in Simon Jones; and then tab to the next line, outlook works out who this is all on it's own.

The problem is, if I specify in my code to send to Simon Jones; it does not convert it / work out who it is.

Is there a way of doing it via VBA?

View 8 Replies View Related

Count Emails In Outlook

Dec 14, 2007

If there is mailbox in outlook called "MIS". What VB should I use to count emails in Mailbox.

View 9 Replies View Related

Outlook Emails To Excel Sheet?

Mar 6, 2014

I have the need to convert regular emails to a excel sheet,

The emails are always sent from the same email address, and will have the same format ( however can contain small or large amounts of data eg 1 part number or 50 ).

sample email below

" PowerForce v4.00
Report : INR3050 v4.5
Title : EDI PURCHASE ORDER INBOUND ERROR EXCEPTION REPORT
For : ch3inl
Date : 05-Mar-14 06:06

[code]....

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved