Computer Support Forum

How do I get Microsoft Excel 2007 as an add on to Outlook 2007

Question: How do I get Microsoft Excel 2007 as an add on to Outlook 2007

I have Microsoft Outlook 2007 that I have purchased as a standalone program. Is there a way to get Excell 2007 as an add on for free if I produce the product key from Outlook 2007?

Relevance 100%
Preferred Solution: How do I get Microsoft Excel 2007 as an add on to Outlook 2007

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Answer: How do I get Microsoft Excel 2007 as an add on to Outlook 2007

No.

However, there are free versions of Excel (later versions), such as the web version and the UWP version.

11 more replies
Relevance 100.45%

Have been trying to follow suggestions from similar posts, but nothing working. Have tried to save as .xls and .csv, as well as trying to 'define names' of the various columns, but nothing allows me to import complete contact into Outlook. Please help, very important to get these contacts into Outlook asap. Thank you
 

Answer:Issues importing large contact list in Excel 2007 to Outlook 2007

Hi hbsurfer

Try going about it backwards.
Create one Contact in Outlook 2007, then Export that one Contact to a .csv file.
Then you will be able to see the format Outlook 2007 is using and reconfigure your headers in the Excel spreadsheet.
When all headers match, you should be able to Import it. Or copy the excel information to the one contact .csv file and Import that.

Let us know if that works for you or not.
 

1 more replies
Relevance 100.04%

Hello,

I have upgraded to Office 2007 from Office 2003. When I open an Excel attachment from email in Outlook 2007, the Excel application opens but the document itself does not. The document has a .xlsx extension. I need help resolving this issue please. If anyone knows why this is happening or the fix, I'd appreciate your insight.

JayT908
 

More replies
Relevance 99.22%

When I try to open an Excel document attached to a email Excel opens but the document doesn't appear until I click on the minimize button. Has anyone seen this before?

I'm Using Excel 2007 and Outlook 2007.
 

Answer:Opening 2007 Excel documents in Outlook 2007

12 more replies
Relevance 98.81%

Running Vista Ultimate (32 bit) on HP Media Center Desktop Unit (8100y). Each time system is booted up and Outlook 2007 is accessed for the first time, Microsoft Office 2007 begins to reconfigure itself. Neither canceling of the configuation process nor allowing the process to complete seems to have any apparent effect on subsequent operations.

Performed repair function on the Office application without any discernible effect. Any help in resolving this issue would be truly appreciated!
 

Answer:Starting Outlook 2007 causes Microsoft Office 2007 to reconfigure itself

8 more replies
Relevance 98.81%

The following hyperlink in Microsoft Word opens up a contact from Outlook. Is there an easy macro that goes to that contact, and adds to the work document, the words from a certain field in the contact. I have new fields in my contact form, and want the word document to show the words from some of those fields.
Here is the easy hyperlink to a contact in a subfolder of contacts:
Outlook:Contacts/Subfolder Name/~Contact Name Thanks very much.
 

More replies
Relevance 97.99%

Tech Support Guy System Info Utility version 1.0.0.1
OS Version: Microsoft Windows 7 Ultimate , 32 bit
Processor: Intel(R) Core(TM)2 Duo CPU T5750 @ 2.00GHz, x64 Family 6 Model 15 Stepping 13
Processor Count: 2
RAM: 3070 Mb
Graphics Card: ATI Mobility Radeon HD 3400 Series, 256 Mb
Hard Drives: C: Total - 113859 MB, Free - 60738 MB; D: Total - 110275 MB, Free - 61717 MB;
Motherboard: Acer, Inc., Chapala , Not Applicable, LXAQB0X612826017F32500
Antivirus: AVG Internet Security, Updated and Enabled

For no apparent reason my version of MS Outlook has suddenly gone belly-up. All other apps. in Office work fine.
When I now try to open Outlook I receive the following "Cannot open your default email folders. The file C:\User\Maurice\AppData\Local\Microsoft\Outlook\Outlook.pst is not a personal folders file"

I have tried uninstalling and re-installing Office from the original disks a number of times, I have successfully installed this on another Win7 desktop computer partition and it works fine. I have attempted to follow the MS repair online notification for .pst but it doesn't seem to work (or maybe it is me that isn't working). Most frustrating. Any word by word suggestions greatly appreciated.
 

More replies
Relevance 97.17%

1) do I save excel as CSV (MS-DOS) or simply CSV (which i presume is "windows" version2) when following steps to import file into outlook, I select the file from which I want to import in "browse" and click next. most videos show the option to map custom fields, but that does not show for me....when I click next i simply get an error. I have read mention of exchange server...do I need to have that running. Trying to save my wife a ton of work in consolidating a museum membership database from excel to outlook for email distribution of newsletters. Any tips would be appreciated

Answer:how to import csv from excel 2007 to outlook 2007

Where did you get the .csv file from in the first place? - the 'import' function in Outlook will only work if it was created on a similar email program - Outlook, Outlook Express etc. and no, you don't need exchange server to complete the task."I've always been mad, I know I've been mad, like the most of us..." Pink Floyd

3 more replies
Relevance 97.17%

I have a database of names, addresses, telephones numbers in excel 20007 Would someone please tell me how to export the list to Outlook 2007?

Thanks.
 

Answer:Solved: Excel 2007 to Outlook 2007

16 more replies
Relevance 94.71%

Microsoft Office (Word, Excel, Outlook)  and printer Slow When Connected To Network, But Fast When Not. with windwos vista , I have reintall the OS but still the same .
network environment  (Win server )

Answer:Microsoft Office 2007 (Word, Excel, Outlook) and printer Slow When Connected To Network, But Fast When Not.

Hi,
 
Please temporarily disable the third party security programs and boot in
Clean Boot
to test this issue.
 
Also, please
create a new user account
to test the issue.
 
Regards,
 
Sabrina
This posting is provided "AS IS" with no warranties or guarantees, and confers no rights. |Please remember to click ?Mark as Answer? on the post that helps you, and to click ?Unmark as Answer? if a marked post does not actually answer your question.
This can be beneficial to other community members reading the thread.

2 more replies
Relevance 93.89%

Hi everyone, first post so I apologise if this topic is cover in depth somewhere else....!!

I use stacks of rules and alerts on my Outlook to save me bags of time forwarding emails to the relevant people etc etc. Its really useful and I believe it saves me at least one employee when used correctly.

Anyway, Im pretty sure they is away to automate outlook to update excel. My excel automatically updates my accounting software, Sage, so is there away to make outlook update excel?

For example...

When I get an email from a certain client it alway has a specific sales ref ie ABCSALE ******. That email is then forward directly to a supplier and filed without me doing anything. I then receive an email form the supplier confirming dispatch & cost.

I want to find a way for this to trigger something on excel to update a certain cell or row.

Any ideas without going down the Visual Basic road....?

Thanks in advance!
 

Answer:Outlook 2007 into Excel 2007

8 more replies
Relevance 85.69%

The ?problem? I?m concerned about is that I noticed existingExcel 2007 xlsx files are now saving with fewer Kb.
I have a Lenovo W700ds and a W541. Both computers are running Windows 7 Pro 64bit.The W700 has Office 2007 and theW541 has Office 2013.Both versions ofExcel are 32 bit as far as I can tell.
Until recently I was primarily using the W700ds but have nowswitched to the W541.


after I saw a larger file losing KB when saved, I did a test with a file that had not been altered or openedfor over two years. I copied it twiceand added a -1 and a -2 to change the names.The file was a small 832 Kb file.When I opened and saved on the W541 running Windows 7 with Excel 2013,the file saves with 771 Kb.When Iopened the file using the W700 running Windows 7 with Excel 2007, the computeron which it had originally been created, the file saved as 830 Kb.Both saved smaller but the newer computerrunning Excel 2013 was much smaller.Iam seeing these same types of ratios of reduction in size for much larger Excelfiles as well.

I have not documented any actual problems or loss of data withany of the files to date and I have used an Ultra-Compare text file comparison which found no differences.
Is there any reason to be concerned about this? And, if so, what to do?

As with many people, some of my files are the result of manyyears of work and I don't want to do anything to compromise any of the data butI don?t know whether or not what I?m seeing is normal due to both Excel 2007and Exce... Read more

More replies
Relevance 85.69%

Is there a way to make Excel 2007 simulate Excel 2003 in the way it looks? It's like learning a whole new programme. I haven't a clue where anything is.

Thanks
 

Answer:Microsoft Excel 2007

I don't believe you can. That's why I'm still using 2003!
 

5 more replies
Relevance 85.69%

Hey everyone,

Quick question.........I have to present my paper tomorrow to the class and I noticed that my A+ teacher put a story in Excel and it read it back to the class. Does anyone know how to get that to work?

Answer:Microsoft Excel 2007

Not understanding what you're asking...

If you mean a story like a text story? Just copy and paste it / type it into a cell and there you go...but why don't you just use Word for this?

2 more replies
Relevance 85.69%

I am attempting to sum a column of figures but only want to sum the ones that have a certain name in another column. For instance, column E has costs for certain items. Column F has the names of the people related to those costs. If I want to find out how the figures for just one individual, how would I go about writing that formula in Microsoft Excel 2007?
Thanks
 

Answer:microsoft excel 2007

try using SUMIF

ex: =SUMIF(F1:F5,"PETER",E1:E5)

F1:F5 would be the area where the names are, PETER is the name to look for, and E1:E5 is the range where the formula will look for the values to sum.
 

3 more replies
Relevance 85.69%

Hello

So I have this excel document with many sheets. Whenever I do a search I want it to search the entire workbook. However the default search is always set on: sheet. How can I make it so that the default search whenever I open excel is: workbook?

Answer:Microsoft Excel 2007

I have not tested this myself but it looks promising:http://excel.tips.net/Pages/T008801_Changi...h_Settings.html

1 more replies
Relevance 85.69%

This is probably bit of a long shot, but i have two documents that i need to check if the barcode numbers match up with the other document.
I am having to manually check every barcode to see if it matches my barcodes, i was wondering if there is a way to do this on excel or another program?

Answer:Microsoft Excel 2007

are they all unique?

you could sort the columns.

then just conditionally format the columns to say, turn red if the rows are not equal.

9 more replies
Relevance 85.28%

I have an Excel workbook in which I keep racing records. The data goes back about 5 years and as i have accumulated several hundred thousand records, I have moved much of the historical data onto separate sheets in the workbook so that values for calcs that rely on the historical data can be auto updated.

For current data I use a separare sheet as i was finding that it was takin g a long time to perform calcs when all the data (up to 200,000 rows) was all on the 1 sheet.

I wanted to know if it was possible to convert what i have to Access as it has been suggested that a database would do a better job of handling so much data, rather than Excel. I have moderate knowledge of Excel and have been able to build up the series of formulas for calculations in Excel over the years and have it pretty well doing all the things i want now but I have very little knowledge of Access design so not sure if I can convert and how to do it.

The Excel workbook contains a lot of formula that do calcs on past results and then use those calcs to do predeictive calcs for upcoming races. Because it was very "maths"based to start with, I started off using Excel and it has all grown from there. Is it possible to convert what I have to Access? Is is reasonably able to be done (by a moderate user like me with some expert help)?.
The files i have are too big to attach here, but would be happy to prepare some sheets without much data to show what i am doing and get advice.
 

Answer:Help required to sucessfully convert Large Excel 2007 Workbook to Access 2007

13 more replies
Relevance 85.28%

I'm trying to run an Excel 2007 macro from Access 2007, when I get to the point where I want the macro stored in the active workbook I'm getting the following run-time error: run-time error '91' object variable or with block variable not set . It won't run the macro at all. I would greatly appreciate it if someone could help me fix my code so the macro will run. The code is listed below; step 10 is where I get the error.
Code:
Option Compare Database
Sub GetJournal_Entry_Data_transfer_to_Excel()
'Step 1: Declare your Variables
Dim MyConnect As String
Dim MyRecordset As ADODB.Recordset
Dim MyQueryDef As DAO.QueryDef
Dim MyDatabase As DAO.Database
Dim MySQL As String
Dim MyRange As String
Dim s As String


Dim Db As Database
Dim xl As Excel.Application
Set xl = CreateObject("Excel.Application")
Dim xlwkbk As Excel.Workbook
'Dim xlworkbk As Excel.Workbook
Dim xlsheet As Excel.Worksheet
Dim i As Integer


'Step 2:Declare your connection string
MyConnect = "Provider=Microsoft.ACE.OLEDB.12.0; Persist Security Info = False;Data Source= P:\FINANCE\Balance Sheet\Inventory\Project TAN\Project TAN.accdb; User ID = Admin;"

'Step 3: Build Your SQL Statement
MySQL = "Select* From [mtb-TantasticJE's]Where [mtb-TantasticJE's].[Dscrptn_Text]='Culls_Stat34'and [mtb-TantasticJE's].[Co_Code]='1381'"

'Step 4: Instantiate and specify your recordset
... Read more

Answer:Access 2007 VB code to run Excel 2007 macro in active sheet

7 more replies
Relevance 85.28%

My employer just upgraded to Microsoft Office 2007. According to the help files, I should be able to paste Excel charts into Word that update automatically when changes are made to either version.

I am clicking "Link to Excel data" and "Keep source formatting" when using the little popup clipboard to paste a chart into Word. But after closing both files, opening Excel and updating data on the chart, saving and closing Excel and re-opening Word, the chart is not updating with the new information. I can't get it to update by clicking on "refresh data" either.

Does anyone know how this is supposed to work? I was looking forward to being able to update just the Excel file and having it update in all the Word documents where it is pasted.

Our OS is Windows XP Professional, Version 2002, Service Pack 2. My work computer has a Pentium 4, 3 GHz processor and 2 GB of RAM.
 

More replies
Relevance 84.87%

Hello,

I am having difficulty linking Excel data from a simple worksheet table to a table in Word 2007. I would like to retain all the formatting currently used in the Word table, but can't get the Paste Options working at all despite following all the advice on the Microsoft Knowledge Base.

If I copy the Excel data and then place my cursor at the first cell location within the Word table where I want the information to be pasted I get different paste options compared to placing my cursor outside of the table.

I am using the "Medium Grid 3 - Accent 3" Table Style in Word.

I have attached a couple of simple files to demonstrate the formatting and content in both apps.
'
Step by step help would be appreciated.

Thanks!
 

Answer:Paste link from Excel 2007 to Word 2007 table

Thought I would try one more time to get this one resolved. Is what I am asking not possible to do?

Cheers!

wmorotn01
 

2 more replies
Relevance 84.87%

I have Office 2007 on Windows 7.

When I am working on a sheet (or document) the ribbon can become inaccessible, nothing works when I click it (like a 'Not Responding' screen).

If, I switch to another open sheet/doc and then switch back the ribbon is accessible again!

I have uninstalled/reinstalled Office plus SP's twice but the problem persists, and, as is usually the case, this does not happen all the time but enough times for it to be really annoying!

Any ideas?

Thanks for your time on this

Neil

Answer:Cannot access the Ribbon functions in Excel 2007 or Word 2007

Could you please post a screenshot or two?
And what are file sizes (MB)?

1 more replies
Relevance 84.87%

I'm trying to get the results of Access queries to be linked to an Excel workbook. I've been using the Data tab in Excel, clicking the "From Access" button in the upper left, and choosing the Access database. Then it asks what query I want to link.

The problem arises when I try to link a specific query, which we'll call qry_x. This query is based on several other queries, one of which is qry_z. Frustratingly, when I try to link qry_x to the Excel workbook, I get an error message that says that Access can't find qry_z, and suggests maybe I spelled the name incorrectly.

However, qry_z definitely exists as part of the database, and when I run qry_x (which is based on qry_z) in Access, the correct results are displayed with no error.

Note: qry_x is the only query this is happening to. I can link any other query with no problem at all, including qry_z!!!

What could be going wrong?

Thanks in advance.
 

Answer:Solved: Access 2007 / Excel 2007 - Linking to a database

16 more replies
Relevance 84.87%

I'm using Windows XP, Microsoft Office 2007 Professional. When I highlight a column, the highlighted color is so light that when I do a "Find" (Control F) command and it finds the value you can't tell it found the value. (The found value is in white which isn't much different than the highlighted column.) Is there any way I can darken the highlighted column? I've tried changing the color scheme for the entire program and that doesn't help.
 

Answer:Microsoft Office 2007 Excel

8 more replies
Relevance 84.87%

Please look at the screenshot below, it shows an eBay spreadsheet I am designing for this year. I use this as I have multiple members of the family using my eBay account (I will duplicate the form for each person when I am done so they have their own grand total figure) I have two problems with it.

1) See the Paypal fee tab? The formula for that is =SUM(D29+E29)*G29+0.2. Unfortunately when a row has not been completed yet, the total will show -£0.20. Considering how many cells I will have by December, that will be a lot of £-0.20 added to the grand total at the top, distorting the true money I have. To get round this, I have added an adjustment column, adding £0.20 back.... there must be a better way than this right? Can I tell Excel to only implement the Paypal fee formula when the Paypal type cell has been filled in?

2) I have the grey table at the top frozen so as I scroll down my spreadsheet, I am still able to see the grey table. This feature however has added some ugly lines to my sheet at the left and top (sort of like frames on a website page). How do I hide these lines?

Thanks in advance!
 

Answer:Need help in Microsoft Excel 2007 (2 things)

How about something like:
Code:
=if(d29<>"",SUM((D29+E29)*G29+0.2),"")
See if that helps out.

As to the second part, I've never seen a way to get rid of the frame lines, but that doesn't mean there's not a way.
 

5 more replies
Relevance 84.87%

When I try to click on a graph in Excel in order to change line width, or other parameters, Excel is not responding. This is the first time I'm trying to use Excel with Vista, and I thought that if I convert it from compatibility to Vista mode it will work, but it didn't. Any suggestions?

Thanks,

Talicu

Answer:Microsoft Excel 2007 not responding

Uninstall Excel. Reboot. Reinstall and patch it.

2 more replies
Relevance 84.87%

Hi,i need a little bit help,i got tracker where i track information and dates when information has been entered,what i need is Excel to help me:to flag me 30 days since information been tracked.for example date: 20/05/2012 goes red after 30 days on 20/05/2012how can i do that?i am using Microsoft Excel 2007Thanks for Your help :)

Answer:Microsoft excel 2007, please help with formulas

Your looking for Conditional Formatting.for example date: 20/05/2012 goes red after 30 days on 20/05/2012But not sure how your data is set up.What Cells are you using?How is your data set up?Are you check two dates against each other, or are you looking to use today's date?To post a small sample of your work sheet read this:http://www.computing.net/howtos/sho...MIKEhttp://www.skeptic.com/

4 more replies
Relevance 84.87%

Hi everybody. I have a bit of a problem with Microsoft Excel 2007 and its files.

There a the file name "Y." However "Y" is a 696 kb file, which means it has an amount of information within it. But however whenever opened it has an error of: Excel found unreadable content in 'Y.' Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.

So I click Yes, but however information from an other Excel File: "X" shows up.

Is there a reason for this? How can I fix it?
Thank you very much.
 

Answer:Microsoft Excel 2007 Problem

totalvita,

Sounds like file 'Y" is using file "X" for an external data source. Look at the formulas in "Y" and see if it is looking at "X".

Hold down crtl and tilde to toggle the formula view.

Stoneboysteve
 

5 more replies
Relevance 84.87%

on my 2007 excel instead of labeling columns with letters it has numbers just like the rows which makes typing in formulas a real hassle. does anyone know how to fix this?
 

Answer:Microsoft Excel 2007 Columns

In Excel, click on the "Office" button (top left) and select "Excel Options" from the bottom of the resulting dialog box.

Then in Formulas (in the left panel) you will get an option in the right panel for "R1C1 reference style". Uncheck it and click OK.
 

1 more replies
Relevance 84.87%

Hi,

Currently i am using microsoft excel2007 and today i have faced a duplicated data problem in microsoft excel file.I tried lot to short the duplicated data but i failed. Now if anyone have any short trick to solve this problem in quick time, then pls share.

Thanks!
 

Answer:microsoft excel 2007 support

Hello.
You question is too vague. Do you have duplicated data in a column, or in a row, or in multiple sheets? Can you post an example of the excel file and also explain how the duplicate data was input to the file (Input from another source or manual entry, for example). Be sure to clean out and private data before posting a file, (Use 'Go Advanced" button to get to the Attach File option here)
 

1 more replies
Relevance 84.05%

http://www.ideawins.com/

Admit it.
You've got one.
We believe people everywhere have great ideas. But they do no good trapped in your head. We want to help you turn them into a flourishing business by taking the hassle out of accounting and business management. So we're offering Microsoft Office Accounting Express 2007 software absolutely free! No strings attached. Get your free download here.

More replies
Relevance 84.05%

Hi,

I'm having trouble running a mail merge with word 2007 and using an excel 2007 file as the data source. I've used this same word and excel file to run this mail merge 3 times a week for the last 12 mths.

Recently I had a spyware infection and had someone at spywareinfoforum sort it out for me. Ever since I've had this problem.


Ok, when I open my prepared word document that I want to use for the merge I get the following message:

"Opening this document will run the following SQL command"

I never used to get this come up. When I select "yes" I get the following error:

"Error has occured: Catastrophic failure:"

When I select "no" the document opens which is ok.

However, if I go to mailings--->start mailmerge--->step by step mail merge wizzard. This is ok but when it comes time to select the datasource I get the problem.

I select "Use existing list" ----> "browse" then navigate to the excel file I want to merge. When I click on the excel file it appears to not recognise the document type. By this I mean that when I click on the excel file nothing displays in the "File Name" box. This happens even if I change the "Files of Type" box to all files.

If I double click the file I want I get the following error:

"Error has occured: Catastrophic failure:"


I've tried to fix the problem by creating a new word and excel ... Read more

More replies
Relevance 83.64%

I work as a staffing clerk in hospital. I created a excel worksheet that I would like to e-mail to our employees. But I would like the file to open in the e-mail and not as an attachment. Have the employee enter there schedule in the file and then sent it right back to me. I hope that made sense.
 

Answer:Excel & Outlook 2007

Hi martes, welcome to the board.
your question makes sense however I don't think that's will work, at least, I can't figure it out.
I think you should send a sheet to the emplyees, they'll will have to open the file, fil the data and terun the mail also as an attachment, then you'll have to be able to import their data to a totaling sheet or something to regsiter it, at least that is waht I expect you want / need.

I used something similar where I maield a sheet with a whole week so that people could fill in what they did that week so I could regsiter it, you want planning, so maybe a momthly sheet.

An altenative is a user form / tempalte in Outlook, but you'll still have to figure out how to get it in Excel.

Maybe some of the other members have an idea, I'll think about it too.
Hoe miércoles brings an answer
 

3 more replies
Relevance 83.64%

When I try to export my Outlook 2007 contacts to Excel 2003 (as per the options available), I get only headers in the Excel file and no contacts. Can anybody guide me?

Answer:Outlook 2007 to Excel

No too sure which options you mean but the safest one to choose is 'Comma separated Values (Windows)' which can be understood by any spreadsheet program."I've always been mad, I know I've been mad, like the most of us..."

4 more replies
Relevance 83.64%

In Microsoft Excel 2007, I'm trying to sum the results of a IF equation but I keep on obtaining an answer of 0 (the results are either 0 or 1) so the answer cannot be 0. I've tried the sum function elsewhere in the worksheet and it is working fine. The only way I have found that I can sum the IF equation results is by adding each cell individually and as there is over 52,000 cells this isnt feasible. Any help on this issue would be greatly appreciated as I can't seem to solve it.

Answer:Microsoft Excel 2007 -summing IF eqn. results

Since you haven't posted any example data, or any of the formulas you've tried, there's no way we can help you. Your post can essentially be reduced to this:"My formula isn't working. Please help."There's not much we can do with that.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

8 more replies
Relevance 83.64%

Greetings.I run Windows XP and Microsoft Office 2007.  I don't think further specs will be pertinent to this situation.I do not know a lot of database or spreadsheet jargon, so I may use confusing words.I am beginning to think that LOOKUP might not be what I need to do what I am trying to do.  All I want is for it to look at a cell reference, use the word therein to match up to the same word in another list, and then return with the adjacent number in the same row.I do not explain things well, so I will provide pictures as attachments.  The words were all replaced with random ones for the purpose of these screen shots for privacy reasons.  They may also be blurry because I saved them as jpegs set to high compression to lower their file sizes.Anyhow, for the purposes of these images, I use the formula: =LOOKUP(A35,DummyList,Sheet4!B3:B24)Where A35 is assigned a word from the list on Sheet4 via a drop-down.  The list is called DummyList.  I then intend it to match the word in A35 to the word in the list on Sheet4, and then return the corresponding number.  In this example, I selected the words Salt (in A33, and yes, the upper one is LOOKUP(A33....) and Forget.  Beside them they should return the numbers 1.1 (Salt) and 2.1 (Forget).  Instead I get 6.0 (Salt, and 1.0 (forget).If I do it the other way, where it looks up the number and then returns the corresponding word, it is usually bang-on.  Here it gets the wrong numb... Read more

More replies
Relevance 83.64%

Hi,

I encounter an error while opening an excel file, i could not view the file and it tell me to enable the macro. But after i enable the marco. The file still cannot be view, there is a error saying " RUN time error '1004' the specific dimension is not valid for the current chart type. i am using microsoft excel 2007. Please try to help. thank you. I need to solve this urgently thanks

Answer:Microsoft Excel 2007 Run Time Error

The code of the macro have some error.

Can you post the code here?

2 more replies
Relevance 83.64%

I need to make a fill in the blank formula. the problem is that the text i need surrounding it is used by excel for functions. it is going to be used for html.

this is what it should look like look like: this is ofcoarse referncing to an adjacent cell. But i need ALL of the text to show, including the punctuation marks.
<option value="A1">A1

so in short if A1 has text that says "abc" in it, then i need it to look like
<option value="abc">abc

can someone pls send me a formula that will do that.
 

Answer:Microsoft Excel 2007 Formula question

So, this is really for a web page, not an actual Excel application? Are you trying to create a form for a web page where the visitor chooses from given answers to certain questions? If so, have you tried just creating a form in HTML?

This discussion might be helpful: http://forums.majorgeeks.com/showthread.php?t=199681
 

2 more replies
Relevance 83.64%

I just bought over my friends laptop. Can someone please help me to understand and what need to be done about the following message:-
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
- <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error043560_01.xml</logFileName>
<summary>Errors were detected in file 'C:\Users\Soo Ling\AppData\Roaming\Microsoft\Excel\XLSTART\NitroPDF.xla'</summary>
-
<info>This workbook has lost its VBA project, ActiveX controls and any other programmability-related features.</info>
</recoveryLog>
Thank you and if anyone could offer some advice on how to fix it. : Marc.
 

More replies
Relevance 83.64%

I am utilizing Microsoft excel 2007 to create an employee database for mandatory training compliances, I have over 275 employees that have to be notified for upcoming and reoccurring training compliances that are required for each employee. How do I write the VB code for EXCEL to notify each employee of upcoming training modules that have to be completed? I would like to notify each employee via E-mail regarding these training modules. I also would like to know how to (blacken, or darken, or eliminate)cells or modules that only pertain to certain individuals. In other words, if the individual that I am observing in Excel does not have to meet certain requirements regarding training modules that are specific to their field of study how do I eliminate the cell by (shadowing, or darkening), the cell that is under the module that is listed in the column. There are 22 columns and 275 employees. Thank You in an extreme abundance if you can help me with these issues that I am having with Microsoft Excel 2007. I NEED HELP!!
 

More replies
Relevance 83.64%

Hi all,
help needed please for a excel formula for the following problem.
In my daughter in laws work she as to occasionally alter the the price of a lot of the goods they supply by 1 or 2 percent. The problem is that the manager/owner does not want the price to be exactly a round figure eg £1:00 it can be £0:95 or £1:05 in divisions of 5p So she is in need of a excel formula to round up/down the price to the nearest 5p omitting the .00 Can this be done?

Answer:Microsoft office 2007 excel formula

tonyq
Not sure if this will work in 2007, I use 2010. There are two functions 'ceiling' & 'floor' that you can use.
EG: - Cell A1 has original price (£1 for example)
Cell A2 =b1*98/100 (a reduction of 2% so £0.98p)
Cell A3 = Ceiling(A2,0.05) will go to the nearest 5p above £0.98p (£1) or
Cell A3 = Floor(A2,0.05) will go to the nearest 5p below £0.98p (£0.95p).
Cells need to be formatted for currency.
Hope that helps

10 more replies
Relevance 83.64%

I set up a powerpoint presentation with graphs on each slide. Each graph is linked to a different Excel spreadsheet. The way that they're linked is I created the chart in Excel, Copy and Special Pasted the graph to Powerpoint. It all works fine with my computer but when I send the documents to my co-worker, who has the same program, the link doesn't work anymore. When I try to re-do the copy/paste connection it'll work once then the next time I try to open or edit the Excel sheet from the graph a Microsoft Office Security Notice pop-up with come up saying

"Microsoft Office has identified a potential security concern

Warning: there is no digital signature available

*File path*"

Then asks me if I want to Enable add-in for this session only or to leave it disabled. no matter which one I click it still won't work.
No clue how to fix it.
 

Answer:Microsoft Powerpoint/Excel Graphs 2007

Candice,

Have you looked into OLE and embedding the spreadsheet into the PPT file? Insert>object>from file

I recently used OLE to embed .DOC and .PPT files into Access. If you have a use case please add it and I will see if it aligns with my recent activity.

Stoneboysteve
 

7 more replies
Relevance 83.64%

I'm using Micorsoft 2007 and trying to open a file with a .PRN extension. This is a comma-delimited file and created several years ago from our legacy system. In the past, I would open the files using the Wizard and I would open it as a comma-delimited file in Excel. The file today only opens in Wordpad of Notepad. I must have it open in Microsoft EXCEL 2007. Any ideas?

Answer:Opening a .PRN file in Microsoft Excel 2007

That is not a comma deliminated file but a print file. You could go copy filename lpt1 to print it.You may want to associate the prn extension with excel or do a right mouse click and open with choosing excel.Moderator please move to Office forum where you may get a better answerAnswers are only as good as the information you provide.How to properly post a question:

4 more replies
Relevance 83.64%

Hello everyone,

I have two questions regarding Microsoft Office Excel 2007, that are no doubt simple ones to answer.

Firstly, is it possible to have a column where every entry added would appear automatically with quotation marks? For example, if I entered Movie #1 in to a cell in Column A, when I click out of that cell, can it automatically change it to "Movie #1"?

Secondly, on a seperate work-sheet (but within the same work-book), how can I have a display telling me how many cells appear in a particular column on another work-sheet? For example, if I have Column A in Work-Sheet #2 filled with entries, can I have a cell in Work-Sheet #1 tell me how many entries there are there in total?

I hope that all makes sense.

Any help would be appreciated!
 

Answer:Solved: How Do I Get Microsoft Office Excel 2007 To Do This...?

7 more replies
Relevance 83.64%

Product
Microsoft Office Excel

Problem
Stopped working

Date
4/4/2010 3:04 PM

Status
Solution Available

Problem signature
Problem Event Name: APPCRASH
Application Name: EXCEL.EXE
Application Version: 12.0.4518.1014
Application Timestamp: 45428263
Fault Module Name: OLEAUT32.dll
Fault Module Version: 6.0.6001.18000
Fault Module Timestamp: 4791a74f
Exception Code: c0000005
Exception Offset: 00004580
OS Version: 6.0.6001.2.1.0.768.2
Locale ID: 17417

Extra information about the problem
LCID: 1033
Brand: Office12Crash
skulcid: 1033
Bucket ID: 645573241

Anyone kind enough to help me by offering step by step instruction to put the above solution to good effect. My computer literacy level is 'beginner Level'. Thank you very much. - Mak
 

More replies
Relevance 83.64%

Dear All, I am facing a big problem regarding Microsoft excel 2007 with Lenovo R400, operating system is Windows XP SP2.Microsoft excel 2007 always shut down and ask for recovery the file. Do anyone face this problem? and How did you solve it? Regards,Ahmed

Answer:Conflict between R400 and Microsoft Excel 2007

have you update the office software? also is original or bootleg copy of Office? Do you have any other version of the office installed?

3 more replies
Relevance 83.64%

This is a question about the search functions within Microsoft Office Word 2007 and Excel 2007. I want to be able to do searches that would yield both "e" and "é" in the results of a single search. Right now all I can do is two separate searches. This may mean setting up a way to ignore accent marks, or a way of defining "e" as "e or é" for the search process. My operating system is Windows Vista. Thanks for your help.
 

More replies
Relevance 83.64%

I have Microsoft Office 2003 installed and also the Microsoft Office Compatibility Pack 2007. However, when I receive an e-mail with a Microsoft Word 2007 attachment, the document will not open even with the Compatibility Pack installed. I can not convert .docx to .doc. Any advice please?
 

Answer:Microsoft Outlook 2003 - Attachments in Microsoft Word 2007 will not open

Hi again,

Anybody able to help me with this please?
 

3 more replies
Relevance 83.64%

From earlier posts a solution was offered to this problem (see below). After executing these instructions I received an error (also below).The "debug" option highlighted the code line: objRecipients.Add (Range("C" & i).Value).

Your suggestions for a fix would be greatly appreciated.

_________________

Open the Excel workbook containing the list of records. Make sure the first record is on line 1. Press ALT + F11 to open the VBA editor and then click TOOLS --> REFERENCES and set reference to Microsoft Outlook and then click OK. Next, in the VBA editor, click INSERT --> MODULE and copy and paste the code below into the blank module. Close the VBA editor, save the workbook and run the code by clicking TOOLS --> MACROS and then selecting the macro "DistributionList" When the distribution list comes up you can manually save it.

____________________

Error message: There must be at least one name or distribution list in the TO, CC, or BCC box.

 

Answer:Importing Excel directly into a new Outlook Dist List Using Outlook 2007...

This macro work-around was originally submitted by Rollin_Again on 30 March 2007. If Rollin_Again is still 'rollin' perhaps he would jump back in this problem . . .
 

1 more replies
Relevance 82.82%

Can someone help me create a macro or tell me how to accomplish the following? I would like to change the font color of the text in a cell depending on what is in the cell. I do not want to change the entire font color for everything in the cell, just the specific attribute to chage. For example, when "Microsoft 2012" is in the cell, the font color would be "orange" for 2012, but no change to Microsoft.I'll have multiple worksheets in a workbook to search and change the font to. We use a lot of dates/years in Excel and would like to isolate to a given year with a particular color so it could be easily recognizeable when looking at the worksheet/workbook. I hope this makes sense.Thanks in Advance

Answer:Changing Font Color in Microsoft Excel 2007

There is a major difference between Microsoft 2012 and August 9, 2012Microsoft 2012 is a Text String while August 9, 2012 is a Date, stored internally by Excel as 5 digit number, specifically 41130. Excel stores Dates and Times as numbers, with the integer being the Date and the decimal portion being the Time. 1/1/1900 is Day 1, 8/9/2012 is Day 41130.Regardless of how the date is formatted for display, Excel only knows it internally by it's Serial Number.Therefore, you cannot isolate any portion of a Date and change the Font color. All of the cells containing your "Dates" would have to be formatted as Text. However, if the cells are formatted as Text, you may lose some of the functionality that comes with a Date.Try this:- Put 8/9/2012 in a cell- Format it as mm/dd/yyyy- In the formula bar, highlight the 2012 and pick a font color for the year- I'm guessing it won't hold when you click out of the formula barNow...- Put an apostrophe (single quote) in front of the date to force it to be text '8/9/2012- In the formula bar, highlight the 2012 and pick a font color for the year- I'm guessing this time it will workIf you are willing to Format all of the Dates as Text, code similar to this will change the "year" (the last 4 characters) to Red:Sub RedYear()
Range("A1").Characters(Start:=Len(Range("A1")) - 3, _
Length:=4).Font.Color = -16776961
End SubClick Here Before Posting Data or VBA Code ---> How To Post Data or Code.

3 more replies
Relevance 82.82%

I have an ongoing issue...various spreadsheets (none in particular...could be one or two or all of them) will start taking on this behavior for no apparent reason: when you click an individual cell, it highlights that cell plus usually two to the right of it. Reformatting by using the format painter from an unaffected cell (if you can find one at that point that hasn't been affected) usually corrects it but it's time-consuming to manually go back and reformat each affected cell. What causes this behavior and how can I stop it? Or is there an easier fix for it? TIA!

Have found related posts @ Microsoft, but MS apparently has not yet acknowledged that this is, in fact, an "issue":
http://www.microsoft.com/office/com...=en-us-excel&lang=en&cr=US&sloc=en-us&m=1&p=1 http://www.microsoft.com/office/com...=en-us-excel&lang=en&cr=US&sloc=en-us&m=1&p=1

My suggested workarounds are as follows:
1. Try tapping the wheel of scroll mouse, if applicable.
2. Try changing the page view from Page Layout to any other View option: View tab > Normal
3. Close the spreadsheet, open again and see if behavior still exists.
4. Close Excel, open the spreadsheet and see if behavior still exists.
5. If cell still selects multiple cells, up keyboard up/down/left/right arrows to navigate away and then back to cell, then click in the formula bar to edit
6. If it says EXT or Extend Selection in the bottom left corner of Excel, then it is in Ext... Read more

More replies
Relevance 82.82%

I am creating a worksheet about financial repayments, where the repayments are irregular.

Say for example the total repayment is £1000 and I put this in cell D1 ( alongside other headers). I am putting the repayments in column C, so the first entry would be in cell C2.

What I want to know is whether or not there is a very (I mean VERY) simple way to format column D so that any entry in cloumn C will be automatically subtracted from the first figure of £1000 and subsequent running totals and if so will I also be able to format column D as a £ figure (I know how to do that but not with any other formatting)

Yes, I know I sound very lazy (I am), but my maths are poor and it will be a long list, so if I make just one error it will be a load of hassle.

I would be obliged for any assistance.

Thank you
 

More replies
Relevance 82.82%

I have an ongoing issue...various spreadsheets (none in particular...could be one or two or all of them) will start taking on this behavior for no apparent reason: when you click an individual cell, it highlights that cell plus usually two to the right of it. Reformatting by using the format painter from an unaffected cell (if you can find one at that point that hasn't been affected) usually corrects it but it's time-consuming to manually go back and reformat each affected cell. What causes this behavior and how can I stop it? Or is there an easier fix for it?

Have found related posts @ Microsoft, but MS apparently has not yet acknowledged that this is, in fact, an "issue":
Discussion Groups Home Discussion Groups Home

My suggested workarounds are as follows:
1. Try tapping the wheel of scroll mouse, if applicable.
2. Try changing the page view from Page Layout to any other View option: View tab > Normal
3. Close the spreadsheet, open again and see if behavior still exists.
4. Close Excel, open the spreadsheet and see if behavior still exists.
5. If cell still selects multiple cells, up keyboard up/down/left/right arrows to navigate away and then back to cell, then click in the formula bar to edit
6. If it says EXT or Extend Selection in the bottom left corner of Excel, then it is in Extended mode - try tapping the F8 key once
7. Try zooming out then clicking the cell selection again: View tab > Zoom > Edit % in Custom field > Click OK

... Read more

Answer:Microsoft Excel 2007 highlights multiple cells

Hello,

I am sorry but i can not give a answer becuase i can not replicate the issue. So either this is something that is only with your machine or something else wrong. Cause i can not recreate this issue in order to try and find a resolution. I have search Microsoft.com and Google and the only thing i have found is your various posts across the net.

As for your searches i found only 1 other person who has even mentioned it. That does not make for a bug or a issue in Microsoft eyes. 2 people who come across a issue does not make it a issue.

In every case no one has a answer. We can not provide a answer as we can not reproduce the problem. I have gone back to opening spread sheets from 1997 and still can not get this issue to come up.

I have tried in XP, XP SP1, XP SP2 and XP SP3. I have also tried in Vista. All via VM Ware. Still no luck reproducing the issue. I am sorry but the only advice i can give is to uninstall Office with something like Revo Uninstaller to get rid of the Registry entries. From there reinstall with just Office 2007 and not upgrade from a previous version.

Cheers,
Mak

9 more replies
Relevance 82.82%

Hi guys,

My customer facing this issue Excel 2007 not responding during Calculation 1% checked the task manager cpu usage running 100%.She has allot formulas and trying to combine it and need to be submitted.
Hope you guys know a way to solve it.

Spec Laptop
HP Elitebook 840G1 - 8gb ddr3L ram

Thanks,
Sunny
 

More replies
Relevance 82.82%

Hello,Installed Outlook 2007 from Office CD, only outlook. Trying to use openOffice3 instead of the usual MS Word, Excel, etc.When I run Outlook a Windows installer 1605 message appears saying that it can?t find neither Excel nor Word.I click yes on both messages and the program runs smoothly, but those messages are annoying.Is there a way to acomplish this? Any other Outlook substitute?Thank you . . .Edit: Moved topic from XP to the more appropriate forum. ~ Animal

Answer:Outlook 2007 without Word and Excel

Go to the control panel and internet properties, the select the programs tab, what does it say your html editor is.

4 more replies
Relevance 82.82%

I am frustrated. Since our upgrade to Office 2007 I have had several users complain that when they try to open excel spreadsheets sent as attachments in Outlook they cannot see anything. It does not even open the excel program.

I thought at first it might be a size issue, but these files are relatively small in size.

If you choose the option to preview that works.

What am I missing and does anyone have any ideas on how to resolve this issue? This is extremely important to resolve.

Please help!!!!
 

More replies
Relevance 82.82%

Hi Guys,
I have following queries regarding Outlook 2007 contact management .I am trying to export excel format using the following code to outlook 2007,contacts list, but its not working ..can someone assist me in sorting this out ..i am attaching the format i need to export and here is the code i am using

Code:
Dim appOutlook As Outlook.Application
Dim objNameSpace As Outlook.Namespace
Dim objContactFolder As Outlook.MAPIFolder
Dim objContacts As Outlook.ContactItem
'Dim myDistList As Outlook.DistListItem
Sub ContList()

Set appOutlook = GetObject(, "Outlook.Application")
Set objNameSpace = appOutlook.GetNamespace("MAPI")
Set objContactFolder = objNameSpace.GetDefaultFolder(olFolderContacts)
Set myMailItem = appOutlook.CreateItem(olMailItem)
Set myRecipients = myMailItem.Recipients
'Set myDistList = appOutlook.CreateItem(olDistributionListItem)
For i = 3 To Cells.Find("*", SearchOrder:=xlByRows, SearchDirection:=xlPrevious).Row
Set objContacts = objContactFolder.Items.Add(olContactItem)
With objContacts
'.Secs = Range("B" & i).Value '.CompanyName = Range("B" & i).Value
.BusinessName = Range("C" & i).Value '.LastName = Range("C" & i).Value
.ContactName = Range("D" & i).Value '.FirstName = Range("D" & i).Value
.Custemail = Range("E" & i).Value '.BusinessAddress = Range("E" & i).Value
.Traderemail = Range("F&qu... Read more

More replies
Relevance 82.41%

I have microsoft office 2007 of which Microsoft Outlook is part, installed on my machine, The O.S is Windows Vista! When ever i try to open/follow a link from an email i get the message "This opperation has been cancelled due to restrictions in effect on this computer! Please contact your system administrator"Help is needed please!

Answer:Microsoft Outlook 2007

take a look at this click here

4 more replies
Relevance 82.41%

Does anyone know how to disable ClearType in Outlook 2007? I can't find it anywhere, I found it in Word, Excel and those but can't find it in Outlook.
 

Answer:Microsoft Outlook 2007

There are two methods you can try.

Online:
http://www.microsoft.com/typography/cleartype/tuner/Step1.aspx

Or offline:
Right click on the desktop, select properties, click the appearance tab, click the "effects" button. Within "Use the following method to smooth edges of screen fonts". Make sure this reads "standard". (instead of clear type)
 

12 more replies
Relevance 82.41%

A kind friend of mine loaded some software on my PC Windows XP Pro also running MS Office Pro 2007 and Programme which he has uninstalled which caused Outlook to open immediately you start up your Computer. I do not want this he doesn't know the name of the Programme I have tried uninstalling Office I have tried System Restore but to no advail. Any solutions please.

Answer:Help Microsoft Outlook 2007

See if Outlook is listed in msconfig and disable it click here

3 more replies
Relevance 82.41%

I have set up an e-mail in my outlook, but I am only able to receive e-mails I cannot send them. Anyone know what is causing this or how I can fix it?

Answer:Microsoft outlook 2007

You have to configure SMPT. I'm unsure how to fix it, as I haven't used Outlook in a while.

2 more replies
Relevance 82.41%

I have windows 7 and Microsoft outlook 2007. I have set up the email accounts correctly as I get all my emails and sending emails is no problem as well. Occassionaly I get the "Enter Network Password" box and when I click ok no emails are sent. If I then click send and receive the emails are then downloaded and sent respectively. I am connected to the internet via a wireless card in my laptop. I have not changed any details such as service provider or changed router. It was working for a few months fine but only just the last month has started this. any advice would be greatly received.Can any one help with why this is happening and how I can stop it.If you need more information please let me know what you need.

Answer:Microsoft Outlook 2007

As a test, could you connect via cable instead of wireless and try that for awhile and see whether you still get the "Enter Network Password"  box?

8 more replies
Relevance 82.41%

My users are on Outlook 2007 and we connect to an exchange server 2007. We recently migrated from Exchange Server 2003 to 2007. The problem we are having is that previously shared calendars are suddenly becoming unavailable. The message that pops up is:

'The set of folders cannot be opened.'

A more detailed message suggests the following:

'This error usually occurs if the OST or PST file you are using is:
> Unavailable
> Protected with file permissions.
> On a share on a server and the network is down.
> Corrupt

To correct this problem, store the OST or PST file on the local computer.

You may also want to run the scanost.exe and scanpst.exe tools to verify file integrity.'

I have tried scanning them and they are fine. When I look at the permissions they are gone. When the user re-shares the calendar it is ok again but often looses the permission after a re-boot (but not always).
 

More replies
Relevance 82.41%

Hi my Pc is new and runs Windows Vista Home Premium I have purchased Microsoft office 2007 and Outlook keeps prompting me to configure it. Is this ok to allow and can I be sure it will not interfear with my Broadband account with Tiscali but simply run along side it?Thank youKind regards

Answer:Microsoft Outlook 2007

It should not change any internet/broadband settings but it will take over your email programme eg Outlook Express and it does take a bit of getting used to but it also has some useful features in it.

1 more replies
Relevance 82.41%

I am using Microsoft Outlook 2007 on my Desktop. I am having trouble getting all my emails to get to the destination.

I can go into properties and press the test and the test goes through just fine...

I have the same software on my laptop and it doesn't have this problem.

Anything that you guys would know about this?

Derek Goodson

Answer:Microsoft Outlook 2007

What email types are you using? Are they thru a exchange server like with hotmail or a ISP email? Or are you using gmail or something liek that?

If you use hotmail or a Exchange server you have to isntall KB933612.

A mail program cannot connect to an Exchange Server 2007 server by using SSL over SMTP port 587

Download the right one for XP or VIsta and it should work just fine for you.

1 more replies
Relevance 82.41%

 ::)How do I remove an email from my outbox that won't send because it is 220MG.

Answer:Microsoft Outlook 2007

Just had the same problem three days ago. Follow the link below to get rid of the message that is stuck in your outbox.Peterwww.howto-outlook.com/faq/messagestuckinoutbox.htm

2 more replies
Relevance 82.41%

Afternoon every one.
With Windows 8 I am using Microsoft Outlook 2007. What I would like to know is can I get this program too give some indication when mail arrives. arram.

Answer:Microsoft Outlook 2007

Yes, the settings are somewhere in options, can't remember quite where but seek & ye shall find

3 more replies
Relevance 82.41%

Hello All,
i recently upgrded my outlook 2002 to outlook 2007, but any time that I try to open the out look I get this message; The add-in "ESET Oulook plugin" (c:\progra~1\ESET\ESETNO~\EPLGOU~1.DLL) cannot be loaded and has been disabled by outlook. Please contact the add-in manufactur for an update. if no update is available, please unistall the Add-in.
I don't understand what this mean? can anyone help?
thank you for all or any help.
Jon
 

Answer:Microsoft Outlook 2007

Your anti-virus must have some type of email addon for scanning in Outlook. Maybe it's not compatible with 2007 or it needs an update or patch. Check with ESET.
 

2 more replies
Relevance 82.41%

Hi all,

I use Microsoft Outlook 2007. When receiving emails I have no problems with their incoming size i.e. 2mb, 6mb, 10mb etc. However whenever I send an email with an attachment that is 1mb or larger it appears to be taking a very long time to send to the point I usually cancel the send. However unbeknown to me the person to whom I have been trying to send the email to has in fact received some 30, 40 or 50 copies of the email yet it sits in my outbox as if it has not been sent at all.

Totally confused with this one.

Any help or guidance would be greatly appreciated.

Thanks,

Hampo
 

Answer:Microsoft outlook 2007

Hi Hampo,

Im a complete n00b on this too but have had some experience in the past. Is your Outlook connected via POP3 or exchange server?
Have you tried compressing your attachments by using winzip or winrar?

Brock_UK
 

3 more replies
Relevance 82.41%

Just upgraded from Microsoft Outlook 2003 to 2007. For some reason the empty deleted items on exit (email) does not work although it is set to do so. In addition the auto spell check fails to check before sending, again this is set to do so. Can any one advise.

Answer:Microsoft Outlook 2007

I assume you clicked 'apply' before making the settings?

2 more replies
Relevance 82.41%

hi,

not untill recently am unable to recieve mail in my outlook but i can send. when i test my account setting everything is just fine. however there is an error message about my settings not matching that of my server in the send/recieve dialogue box
am using the interenet and mine is a gmail account.

thanking you in advance for the help you will provide
 

Answer:microsoft outlook 2007

am inlove with this website. you guys always sort out the chocks in my system.

thanks!
 

1 more replies
Relevance 82.41%

ok, heres my problem, if someone can help i would be so grateful.

if i were to run 2 concurrent connections to my exchange email account, one offline, one online... why is it that i send an email using the offline version, it appears in the outbox, but on the online version, it sends the email and is found in the sent items folder.

any suggestions??

More replies
Relevance 82.41%

Hi,
when i start microsoft outlook 2007, i get a message migrating settings, and then it goes onto say cannot connect microsoft network, and promptly shuts down, before i can input any settings. it works fine on my desktop. but will not work on my laptop,
can you please help anybody

best wishes
daibach

Answer:Microsoft Outlook 2007

Can you post the message in it's entirety?

3 more replies
Relevance 82.41%

I have 3 e-mail accounts.

Hotmail
Uni [Microsoft Exchange]
A pop3 account
When i open Outlook it opens the Microsoft Exchange folders up automatically whereas i want the Hotmail account to be opened up and the other two closed. Anyone got any ideas? The Hotmail account is already set up as the default e-mail account.
 

More replies
Relevance 82.41%

Can anyone advise how to highlight or change colour of folders in outlook 2007

Answer:microsoft outlook 2007

Pretty sure that you cannot change the colour of the folders only the colours of e-mails using organise.

2 more replies
Relevance 82.41%

Hello,

I've been trying to figure out a way to send all spam into the "Junk E-mail" folder and automatically add the senders of the spam to the blocked list. I got tired of individually blocking domains and senders.

Creating a macro to send the spam into the Junk E-mail folder wasn't a problem.

The issue that I am having is with adding the senders to the blocked list.

I've done some digging around, and it seems that I would have to decode an undocumented binary to get a start on this. Can anyone verify if this is true? If this is indeed true, then it appears that what I'm trying to do is simply not possible. If my inference is wrong, can someone please help me out? Even a recommendation to a 3rd party add-on would be great.

If what I said above isn't an option, is there a way to block multiple IP addresses of the senders using a macro? Although, the IP addresses are most likely dynamic...Anyways, any input on this option would be greatly appreciated.

Thank you very much,
Phil
 

Answer:Microsoft Outlook 2007 Help

9 more replies
Relevance 82.41%

Hi I run Windows Vista Home Premium and have Microsoft Word & Works 2007 which includes Outlook 2007. My Broadband supplier is Tiscali. So far I have not configured Outlook as I am concerned it will mess up my email setup with Tiscali. Can someone please assure me this will not happen and they will work together with Tiscali as my main account.Thank you very muchKind regards

Answer:Microsoft Outlook 2007

This is how to set it up click here

1 more replies
Relevance 82.41%

So i have a laptop running outlook 2007 and i seem to be running into many problems with general software issues along with IMAP issues.
Right now i am trying to move all of the folders in my archive to IMAP folder by folder... (IF anyone knows an easier method to do this i would love to know ) Takes forever but I will not blame the program for that. It was working out decently at first now i keep getting spammed with an error "Failed to update headers"
The TCP/IP connection was unexpectedly terminated by the server
protocol : imap
server: imap.secureserver.net
port: 143
But in general outlook just seems to always run very slow. even on my desktop which is a lot faster then the laptop

Two more problems i just ran into while moving folders:
1. error telling me that the folder is a duplicate and can not move (When there is no other folder with the same name or email's) "CAnnot move items. The server responded: Database failure occurred, possible duplicate folder"
2. telling me the folder does not exist.
 

Answer:Microsoft Outlook 2007

9 more replies
Relevance 82.41%

I have Microsoft Outlook 2007 setup with an IMAP email address. I have a problem where mulitiple times throughout the day Outlook will either crash and state it has to restart after sending an error report or it will just hang until I try to close it when it then tells me it stopped responding. Do you have any ideas what troubleshooting steps could be taken to see what is the issue?

OS: XP Pro
RAM: 1 GB

I have tried another machine running the same OS with a clean install of Office Basic and it is doing it as well. Other was an upgrade from Outlook XP

Answer:Microsoft Outlook 2007

How large is your .PST file? I've found that once it gets about 1 gig it starts to cause problems.

8 more replies
Relevance 82.41%

I have uninstalled and reinstalled Outlook 2007, but still, when I click on it, it will come up, then disappear and leave the message:
Cannot start Microsoft Office Outlook. Cannot open the Outlook window. The set of folders cannot be opened. Errors have been detected in the file C:\Users\Deserie\AppData\Local\Microsoft\Outlook\Outlook.pst. Quit Outlook and all meal-enabled applications, and then use the Inbox repair tool (Scanpst.exe) to diagnose and repair errors in the file. For more Information about the Inbo repair tool, see Help.

I don't know how to get to help or scanpst.exe because outlook disappears too quickly to do anything.

Anyone have a solution?
 

Answer:Microsoft Outlook 2007

Thanks for the reply. I managed to resolve the issue. Can't remember the steps now, but it was using the PST tool in the end.
 

1 more replies
Relevance 82.41%

Hi,how does one move all the pop3 email accounts settings from Microsoft Outlook 2007 to another Microsoft Outlook 2007? Thank youArun

Answer:Microsoft Outlook 2007

Click Tools> AccountsFind the account, click on it, and click "Export"Save the file to a disc or somewhere where you can get it to the other computerOn the other computer, click Tools> Accounts> and click Import, and import the file. ORManually write down the pop3 settings that you see after doubleclicking the account you need to move. The main parts you need:Username, password, incoming server, outgoing server, secure authentication y/n?

1 more replies
Relevance 82.41%

hi i have microsoft outlook 2007 when you open inbox normally there is the column that says inbox drafts etc next to that is the emails if you put the blue line on one of the email you can read the email in the right hand side now you cannot read the email on the right its just one long email which you cannot read until you double click it please help cheers pete.

Answer:microsoft outlook 2007 help

the "View" tab, choose "reading Pane" >right.However, I believe your system is more secure from malware etc. if you have the reading pane off!Hope this helps :-)

2 more replies
Relevance 82.41%

I am a new user to Bleeping Computer. I have an I3 Toshiba Laptop with windows 7 4G ram and 160 G HD. I use office 2007 specifically outlook for email. It has consistently crashed on me since installing it about 2 months ago. Any ideas as to what I can do to eliminate the crashing?

More replies
Relevance 82.41%

Does anyone have any ideas if it is possible to locate a set of master databases for BCM on a storage point online - options are varied - and for two people to sync with it from two different physical locations?
 

Answer:Microsoft BCM for Outlook 2007

you're supposed to be able to do that. I can't even get my toolbar to come up....
 

1 more replies
Relevance 82.41%

I am running Microsoft Office 2007 with Windows 7. I have had no problems with it until now. Suddenly I am unable to open Outlook at all. It comes up with a message 'Cannot start Microsoft Office Outlook. Cannot Open the Outlook window'. All other Microsoft Office programs are working ok.
 

Answer:Microsoft Outlook 2007

Try this thread - http://forums.techguy.org/business-applications/544134-cannot-start-microsoft-office-outlook.html
 

2 more replies
Relevance 82.41%

Does anyone know if it is possible to share a contacts list or address book if you are not using exchange?  We are a small 4 computer office, and don't have the need to run our own email server.  Any help would be appreciated.

Answer:Microsoft Outlook 2007

So you want to share the contacts list with the other four computers, yes?

8 more replies
Relevance 82.41%

On computer1, I have successfully created a customized form with user-define fields in Outlook 2007 and a merge document in Word 2007 that works (starting the merge from Outlook 2007). I want to copy the custom form with the user-define fields and the merge document to a second computer (computer2).

I saved the custom form with fields from computer1 to a *.fdm file using the Tools, Options, Other, Advanced Options, Custom Forms, Manage forms. On computer2 I used the same process to install the custom form file (*.fdm) into Outlook 2007 and created a new contact folder that uses the form and displays/adds new contact records correctly. I also copied the Word merge document to computer2. Computer1 and computer2 both have Office 2007.

All the problems occur on computer2. First, when I attempted to merge (starting in Outlook 2007), Word gave messages that all my user-defined fields did NOT exist in the database although I could see them in the Contact records. I attempted to create a new document and the user-define fields do NOT show up in the Word merge field list either.

On computer2, I created from scratch a new contacts folder with a new custom form and user-define fields which works when merging. Therefore, the problem seems to be that Word can not see the fields I created from the *.fdm file I installed.

Can anyone please help me with this? Thank you in advance.

Don
 

More replies
Relevance 82.41%

Please can you help?
How can you set up an outlook.com email account in Office Outlook 2007 these days? I've tried using imap, exchange and the Outlook connector. I'd really appricate any help.
Thanks

Answer:How can I setup an outlook.com email account on Microsoft Office Outlook 2007?

https://support.microsoft.com/en-us/kb/2735989
This article, if you scroll down, shows how to do it for Outlook 2007. It was last reviewed/updated in November 2014, so should be up-to-date on what is needed.

more replies
Relevance 82.41%

I recently formatted my HD and reinstalled MS Office Enterprise 2007, I last used MS Excel on the 08/06/2014 without a problem, today I go to use my Excel spreadsheet and for some weird reason it wants to roundup my cells.
I have cleared the cells formatted the number but it still keeps on rounding up 25799 to 258. I downloaded a stack of MS Office updates 3 days ago, is it possible one of these Updates has corrupted - broken my Excel program?

I am considering uninstalling all of those updates and turning off Updates for MS Office altogether.

Answer:Excel 2007 (MS Office 2007 enterprise)

Hi there.

To test if it's really a software issue, please try out on a new excel spreadsheet and see if the problem is still there. It might not necessarily be the software. Once we have confirmation that the problem exist on a fresh new spreadsheet, then try to do a repair first before uninstalling.

7 more replies
Relevance 82.41%

I am trying to create a report/form that will have a client's address and information at the top and whoever worked the case one the bottom. We would have the client information in a spreadsheet and our various employees information in another. I'd like the users to have some way of selecting the cleint/employee information, possibly from a drop down box, then have the information inserted into the document in the appropraite fields. I am not that familiar with the advanced features of word/excel and have been having trouble figuring out a way to do this. I'd like to have the form with the data in it to save as a file. Most of what I have seen involve mail merges which doesn't seem to work in this case or references to VBA. Any help or guidance would be greatly appreciated.
 

Answer:Word 2007/Excel 2007 integration

Welcome on board.
Can you please give some more information, about the data structure you have, the needed result, and if possible provide some example files (with some dummy data)
 

1 more replies
Relevance 82%

hebrew font is not recognised in Outlook 2007 although it is installled in office 2007 and works well in word 2007 & exel 2007 - the hebrew text always comes up as ?????.?????? when displaying the senders name in an email received - instead of the hebrew text.Can anybody correct this ?

Answer:hebrew font is working in word 2007 but not in outlook 2007

Do you have any COM add ins? Can you copy and paste the Hebrew lettering from word to an email in outlook (may be a quick work around)?Im unsure of the specifics to your problem but I did find this on the internet:in order to display multibyte (ie hebrew) characters correctly,- you must use a Unicode-type PST file- you must run Outlook in Unicode mode- the incoming message must be properly encoded (by the sender) as Hebrew.

3 more replies