Windows Support Forum

Problem put my excel 2007 email database to outlook 2003

Q: Problem put my excel 2007 email database to outlook 2003

Please can someone help me.I manage a band and we have a database of 3,000 contacts. The headings are name,location,email, website. I wanted to put all this into my contacts sheet so that rather than getting a mailing list program I'll just use outlook and distribution lists. I was going to set up different address books for each location. i.e USA.

A box saying you have not named the ranges keeps coming up. Honestly i dont have a clue and could really do with a step by step, baring in mind i know nothing.

Problem is that it wont import from Excel into Outlook. Im getting desperate now their album is out in February and i have not used the direct mailing yet.

I cant find a step by step idiots guide to doing this anywhere.

Can someone help there is a free album in it if you can lol

Please help.

https://forums.techguy.org/threads/problem-put-my-excel-2007-email-database-to-outlook-2003.766140/
Relevancy 100%
Preferred Solution: Problem put my excel 2007 email database to outlook 2003

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/directdownload.php. (This link will automatically start a download of Reimage that you can save to your computer.)

Relevancy 92.45%

I ve seen this issue on email Office Problem Merge 2003 HTML Outlook 2007 other postings but have not seen the answer yet I have Vista Outlook and Office I have been trying to send an email merge works fine on my other XP machine with office in HTML I can send a merge in text but the HTML option Office 2003 Outlook 2007 HTML email Merge Problem yields nothing I purchased outlook because Msft Mail was not working either I am about to throw out outlook and try to downgrade to outlook to see if this option works as it does on my XP machine Any ideas before I totaly frustrate my wife by reloading her software again When the quot text email merge is initiatied I get a message for each mail that asks me to accept that another program is trying to send an email This seems to happen for each email which could really be a problem for several hundred emails I have tried turning off the firewall but the box still appears This whole Vista thing is making me crazy I have to reconfigure my outlook and transfer the list of names and the word doc to my xp laptop just so I can send the Office 2003 Outlook 2007 HTML email Merge Problem mail merge What is the setting to turn this off I am wondering why I paid for Vista and the Oulook sw Sorry just frustrated This should not be so difficult nbsp

https://forums.techguy.org/threads/office-2003-outlook-2007-html-email-merge-problem.739840/
Relevancy 88.15%

Hi,

I need to send an email notification(To Outlook Inbox) to specific users that, the excel/Access database has been updated and saved by an user with his name.

This notification should be sent everyday at a specific time.

Can anybody help me out in achieving this using macros or by any means.?

Thanks in advance!!!

Regards,
Krishna
 

A:Send email notification from Excel/Access Database to Outlook

Have you looked at the "sendObject" method?

DoCmd.SendObject , , , "YourEMAIL", , , "TEST"

Leave the Object name /format blank and you can send without attachement, you can do with a macro or VBA....this is from Access only, if you need Excel let me know, it is different.

Not clear on how you want to trigger, because essentially the UPDATE, should be the trigger, but you mention same time everyday...that may not be relevant because what ever action does the update maybe able to trigger the send.

I also use this to get around Outlook security...
http://www.contextmagic.com/express-clickyes/pro-version.htm
 

https://forums.techguy.org/threads/send-email-notification-from-excel-access-database-to-outlook.906301/
Relevancy 84.28%

I just recently upgraded my Outlook from 2003 to 2007 and although some of the icons and things are flashier, I am having loads of trouble trying to figure out how to do a mailmerge. Currently, I have all of my email addresses in an Excel 2003 file under two columns "Name" and "Email".

Can anyone help me figure out how to do a mail merge from Excel to Outlook 2007? I basically want to have an existing message where it will insert the "name" into the message and send it to the "email" listed in Excel. I could do it no problem in the old version.

Thanks!
 

Relevancy 82.56%

I know that 07 Word saves files in a .docx file that is not usable by the 97-03 Word and same goes for PowerPoint and Excell. My question is does this occur with Outlook 2007 also? I have a friend who said that he can't read my Outlook 2007 email to him (he uses the older version of outlook). Is there a way to change it so that I can send 2007 Outlook emails to people with the 97-03 versions?
 

Relevancy 82.56%

OK... well I thought I had it covered but.... I copied the pst file from 2003 and tried to open in 2007. I recently read somewhere that you have to copy the pst when Outlook is closed. I did not close Outlook and copied the file while Outlook was open. Anyway to rescue these Emails? The old drive is toast so I can't do that. The pst file is 79mg so I suspect the info is there. Any thoughts? Thanks!
 

https://forums.techguy.org/threads/outlook-2003-email-to-outlook-2007.941577/
Relevancy 82.56%

Dear Expert We have configured and enable in Exchange under Organization Configuration -- gt Hub Transport -- gt Transport Rules Junk Email with Priority - when the Subject field or the body of the message contains specific words Apply rule to messages when the Subject field or the body of the message contains https mail mmc com my appl set the Email 2007 Exchange 2003 Junk via Outlook in spam confidence level to Junk Email with Priority - when the Subject field or the body of the message contains specific words Apply rule to messages when the Subject field or the body of the message contains http mail mmc com my appl set the spam confidence level to The problem is Junk Email in Exchange 2007 via Outlook 2003 the user still get the email and notification from our internal Lotus Notes system that we developed system like Leave Claim to Junk E-Mail folder in Outlook Example example subject New Message RESTRICTION FOR MMC OFFICE AT KOMPLEKS ANTARABANGSA DURING PUBLIC HOLIDAY body of the message contains System Junk Email in Exchange 2007 via Outlook 2003 Message Please click the following link for new Message https mail mmc com my appl announce nsf A B D AB E F OpenDocument example Subject Service Report - Month of August body of the message contains Total no of closed support services recorded for the month of August Average day Junk Email in Exchange 2007 via Outlook 2003 spent on one issue estimated days Please click on the link below for detail https mail mmc com my appl break-d nsf Analysis OpenPage Note - No of services should be higher please log in all service call and close the issue promptly How to solve this so that the email from our Notes server going direct to the user Inbox in Outlook Regards Shamsul nbsp

https://forums.techguy.org/threads/junk-email-in-exchange-2007-via-outlook-2003.685139/
Relevancy 82.56%

I just got Outlook 2007 but only have Word 2003. I want to set Word as my email editor. I've looked at all the Outlook Options and checked the Microsoft website but can't find how to set Word as the editor. If there is a way, please let me know.

The reason I want Word as the editor is I send a lot of screen snapshots and I used to be able to crop them in Word editor. I can't find a crop option in Outlook 2007. If there is a way to crop screenshots in Outlook editor then I don't need Word.

Thanks for the help!
 

A:Word 2003 as Outlook 2007 email editor?

If you don't have the rest of Office 2007, you won't get the rich features it provides. With Office 2007, you can crop any picture right in an email message; just hit the contextual tab Picture Tools | Format.
 

https://forums.techguy.org/threads/word-2003-as-outlook-2007-email-editor.563278/
Relevancy 82.56%

I have just been upgraded to Excel 2007. I find that some of the macros that were recorded in Excel 2003 no longer work in Excel 2007. We use the Analysis Toolpak VBA add-in and I have added this in to 2007 ok, but when running a macro I get a run time 1004 error ATPVBAEN.XLA cannot be found. After some searching it would appear that some of these functions have been renamed in 2007 e.g. it is now a .XLAM file rather than .XLA which is why the macro code can't find it. I guess I could manually edit all the macros and change the fucntion names but there are other colleagues in my team that are still using 2003, so I don't want to break things for them. Is there any solution to this? Thanks
 

Relevancy 81.7%

I am trying to get way from the nightmare of Windows Live Mail mostly due to two bugs that are still in the latest version of the program I'm trying to migrate from WLM to Outlook or into email ACCOUNTS Importing WLM2011 from Outlook 2003 2007 and I have run into a brick wall on importing Importing email ACCOUNTS from WLM2011 into Outlook 2003 or 2007 my email accounts Microsoft has extensive help pages on migrating TO Windows Live Mail but apparently they do't think anyone would ever want to go FROM Windows Live Mail There is a good article at Migrate from Outlook Express or Windows Live Mail to Outlook HowTo-Outlook which covers migrating the messages and contacts but no one seems to have found any way to get your account data from WLM into Outlook WLM will export the account data as iaf files just like Outlook Express did but Outlook doesn't recognize the iaf files I found a couple of old Outlook help pages that talk about importing IAF files but the procedure shown does not work because Outlook doesn't ever give you any chance to tell it where to look for the IAF files it just says quot No internet accounts were found to import quot

A:Importing email ACCOUNTS from WLM2011 into Outlook 2003 or 2007

I usually just manually copy the Account Settings data from one program to another. There isn't much data to copy and it reminds me of my server login information.

http://www.sevenforums.com/browsers-mail/199094-importing-email-accounts-wlm2011-into-outlook-2003-2007-a.html
Relevancy 81.7%

Outlook amp encrypted email forwarding I have a question about forwarding encrypted emails Scenario Outlook I have received an encrypted email from outside our exchange from an existing client not within our office 2003 encrypted 2007 & HELP email forwarding URGENT Outlook We have completed the DIGITALLY SIGNED process and we can send Signed and encrypted emails to each other just fine all is working NON-ISSUE -- once I receive the encrypted email with the little blue lock I open it then at that point IN OUTLOOK I can then forward it to a co-worker within our office and within our exchange environment perfectly Actually it seems as though once the email is open in outlook it unencrypts it allowing me to send it anywhere to anyone even to an outside email address Scenario Outlook I have received an encrypted email from outside our exchange from an existing client not within our office We have completed the DIGITALLY SIGNED process and we can send Signed Outlook 2007 & 2003 encrypted email forwarding URGENT HELP and encrypted emails to each other just fine all is working NON-ISSUE -- once I receive the encrypted email with the little blue lock I open it then at that point IN OUTLOOK I can not forward it to a co-worker within our office or within our exchange environment Actually it seems as though once the email is open in outlook it it stays encrypted unchanged and will not allow me to forward it to a co worker or outside email address UNLESS I manually uncheck the blue lock in the top options pane when the message is open The problem with this is that we get s of emails and we used to just open then forward to another email internally NOTE This worked at one point in OUTLOOK for almost a year then Outlook 2007 & 2003 encrypted email forwarding URGENT HELP something changed in the enviroment and we can no longer complete the above action the way we can in OUTLOOK I HOPE THIS MAKES SENSE SO BASICALLY WE WANT THE OUTLOOK TO KEEP WORKING LIKE THE OUTLOOK We want to get the encrypted email then open it and forward it to an internal email address without having to uncheck the blue lock on each email one at a time We used to also use a shortcut ctrl s and this would open the email and un-encrypt it but this seems to no longer work I would assume that if we had say emails in a box and all were encrypted is there not a way that we can select all and quot Unencrypt quot all of them so then we can do what we want with them Is there a global settings somewhere We do not have the setting checked that says digitally sign or encrype all outgoing emails I figured I would add that cause someone will assume we have that checked Thanks this is a bit URGENT I would appreciate any replies Thanks JN nbsp

A:Outlook 2007 & 2003 encrypted email forwarding URGENT HELP

BUMP

Can anyone help with this ?
 

https://forums.techguy.org/threads/outlook-2007-2003-encrypted-email-forwarding-urgent-help.847777/
Relevancy 80.84%

Hi,
Sorry if I sound like a complete idiot I am extremely new and lost!!!!
I would like to develop a macro to for fill the following functions,
I require it to search a folder called REPORTS in Outlook 2007 copy the first, second and third lines of body text into the columns A, B, and C respectively, so email one is a1 b1 c1 email 2 is a2 b2 c2 etc… then I need excel to check all the values in column c to see if they are TX2, RFD2 or HGT88, then I need to be able to use the data from B1& c1 in Attachmate EXTRA! To paste into two separate function boxes and then to go back and do the same for B2&C2 etc etc..

Sorry but as a complete novice to Macros could anyone advise?
 

https://forums.techguy.org/threads/information-strip-from-outlook-2007-drop-in-excel-2003-and-use-in-attachmate-extra.969704/
Relevancy 79.98%

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 quot From Access quot button in the upper left / - 2007 to database Access Solved: a 2007 Excel Linking and choosing Solved: Access 2007 / Excel 2007 - Linking to a database 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 Solved: Access 2007 / Excel 2007 - Linking to a database 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 Solved: Access 2007 / Excel 2007 - Linking to a database 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 nbsp

Relevancy 79.12%

Hi Everyone, I am new here so hope I get right.
On using Excel 2007 I encountered a problem, hyperlinks did not work. I asked help from a different forum to this and it was suggested to go through the microsoft fix it, it worked and hyoerliks were activated, but now the programm is ever so slow while calculating cells, I have to admit that I do ask quite a bit from it but it never took so long, i estimated its taking about 3 to 4 minutes to calculate cells and this after disabling the auto calculation.

Can anyone help please.

Thank you
 

A:Problem with Excel 2007 - 2003

few neat tricks on here http://www.decisionmodels.com/
 

https://forums.techguy.org/threads/problem-with-excel-2007-2003.978747/
Relevancy 78.26%

Thanks for taking a look at my issue. I new to the boards but not new to the IT industry.

I have a user running Windows XP on a desktop and until recently he had Office 2003 loaded. I've done an email (exchange) upgrade migration that required me to upgrade his 2003 to 2007. I uninstalled 2003 completely and then loaded 2007 fresh. In the new 2007 Excel, when I open a document created in 2003 (a .xls) everything looks great except for a few subtle differences that I can deal with. The problem is when I try to print or even do a print preview, some of the cells in the workbook shift to a different location further down the page. I have loaded the Office file converter program and saved the .xls to a .xlsx with no change. I am able to open the same file on my Win7/Excel 2007 desktop and it previews and prints as it should.

Any ideas?

Thanks,
IslandHopper
 

A:Excel 2003/2007 Printing Problem

Hi, welcome to the forum,
Sounds strange, there is no difference except maybe that you have chosen a special font?
Have you checked your printer settings?
 

https://forums.techguy.org/threads/excel-2003-2007-printing-problem.1043991/
Relevancy 76.97%

Hi

I have a problem in my office that two systems are taking long time to send Excel attachments in MS Outlook 2003.
Even a 35 kb of excel attachment takes 2 minutes to send email.

The system I have WIN XP operating system
Symentec Antivirus client 10.1.5

I reinstalled the symentec and outlook 2003 but the problem remains the same
Please help
 

A:Symentec email scanner taking long time to send Excel attachments in MS Outlook 2003

You could turn off your email scanner.

Why you don't need your anti-virus to scan your email:

http://thundercloud.net/infoave/tutorials/email-scanning/index.htm
Email scanners can be bypassed:

http://www.virusbtn.com/news/2006/12_11a_virus.xml
 

https://forums.techguy.org/threads/symentec-email-scanner-taking-long-time-to-send-excel-attachments-in-ms-outlook-2003.742161/
Relevancy 76.97%

Hi

I have a problem in my office that two systems are taking long time to send Excel attachments in MS Outlook 2003.
Even a 35 kb of excel takes 2 minutes to send email.

The system I have WIn XP operating system
Symentec Antivirus client 10.1.5

I reinstalled the symentec and outlook 2003 but the problem remains the same
Please help
 

https://forums.techguy.org/threads/symentec-email-scanner-taking-long-time-to-send-excel-attachments-in-ms-outlook-2003.741149/
Relevancy 76.54%

I am having a problem in Excel opening an Excel- created workbook that contains links to other workbooks I have no problem in Excel opening this file with the quot Don t Update quot option - the value of the formula displays even though the other workbooks are not accessible In Excel when opening this file it prompts that the workbook contains links that cannot be updated Selecting the first option of the prompt quot Continue quot retains the workbook references in the cells and displays the quot VALUE quot error message If I click on one of those error cells the smart tag show the message quot A value used in the formula is of the wrong data type quot The cell type is numeric and the cell contents should be numeric The second option when opening is quot Edit Links quot According to Microsoft breaking the link to these other sources should replace the formula 2007 Excel Solved: Problem Worksheet to Link 2003 with the formula value My does not do that Neither option works for me I ve tried adjusting the error checking and update options under quot Excel options quot I ve tried copy amp paste special w values with the referencing cells I ve tried changing the cell format Nothing seems to allow me to open the workbook in Excel and see the values of cell that reference an inaccessible Solved: Excel 2007 Link Problem to 2003 Worksheet workbook nbsp

A:Solved: Excel 2007 Link Problem to 2003 Worksheet

Can you upload a sample spreadsheet?
 

https://forums.techguy.org/threads/solved-excel-2007-link-problem-to-2003-worksheet.861388/
Relevancy 75.68%

I want to know how to set up and use a database in Microsoft Excel 2003 .This
could be in the form of a tutorial using simple examples . Microsoft help
does not help much.

Regards
 

Relevancy 75.25%

started workbook with data input sheets Those are where I cut and paste monthly financials from other Excel spreadsheets Using this formula to pull data from the input Building database 2007 Excel spreadsheets into the main database spreadsheet That s mapping okay as an example using this formula IF ISERROR HLOOKUP Core Data L amp Core Data M amp Core Data O DI NonVPPM B XFD FALSE TRUE quot quot HLOOKUP Core Data L amp Core Data M amp Core Data O DI NonVPPM B XFD FALSE problem is I want to pull the data from the main database spreadsheet into reports where I want to present the data sliced several ways Was using this type formula to pull it before in a smaller workbook and it seemed to work okay But now with a bigger data set I m getting a Value message back saying Building 2007 Excel database the data is Building 2007 Excel database not the type need for the formula Here s what I ve been using IF SUMPRODUCT Core Database H H B Core Database M M C Core Database K K E Core Database Q Q SUMPRODUCT Core Database H H B Core Database M M C Core Database K K E Core Database N N D Core Database T T SUMPRODUCT Core Database H H B Core Database M M C Core Database K K E Core Database N N D Core Database Q Q Lookinig for help I m pretty good with Excel but think this project may be a little above my head but I m determined to learn and get it done By the way I m using an HP Laptop with G ram Windows XP Building 2007 Excel database and the Excel file has grown to about meg thanks in advance for any help you can give dpatrickassoc nbsp

A:Building 2007 Excel database

welcome to the board.

All the message says is that the expected value in one of the fields is not what the formula can work with, it's either an empty field where no 0 values or null values are allowed or whatever.

With this information and no access to the source data it's like looking for a needle in a pitch dark room with no flashlight.

What I mean to say is I think insert a new (empty) worksheet and then put each value in a different cell and see what you get in return:

e.g.

A1 ='Core Database'!$H$2:$H$8400=$B4
A2 ='Core Database'!$M$2:$M$8400=$C4

etc...

Then you can build the formula based on A1, A2 , etc and see what happens with which one.

Step-by-step will get a longer way than running when you keep tripping (wow that's philosophical )

I mean, just try this, I'm sure the problem is quite simple since it worked before.

Good hunting.
 

https://forums.techguy.org/threads/building-2007-excel-database.979345/
Relevancy 74.39%

I posted a message yesterday and that issue was more or less solved, but today I've discovered a new issue. I had office 2007 and while I liked some of the new features, I found it in general to be way to slow, so I downgraded to 2003. I've had a number of issues (I think many of which had to do with dll file versions. I've worked through most of the issues and nearly everything seems to be functioning as it should... EXCEPT.... When I try to hit "reply to all" in Outlook, I get the following error:

The messaging interface has returned an unknown error. If the problem persists, restart outlook.

Needless to say, restarting outlook does not help. It was suggested that I type Regsvr32.exe %Windir%\System32\Ole32.dll
in the command line. That didn't help either.

Any thoughts anyone has would be greatly appreciated!
 

A:Downgrading Office 2007 to 2003 - Outlook problem

Another user on another forum had the same exact problem and managed to solve it like this (Other users tried this method and it worked for them too):
Summit-IT
07.03.2008 at 07:31AM PDT, ID: 21925812
This is not the only solution to this issue. I had the same exact issue. I was using office 2007 and downgraded to 2003 and my reply to all button was not working at all. With some trial and error and some searching on the internet I found this solution and it worked very well without having to completely rebuild and reimage the computer, which was not an acceptable solution for the time that it would have taken to do that.

The solution that worked for me was this:

First make sure outlook is closed. Because you are using an exchange server it should be no problem to delete your .ost file. Go ahead and delete that as well. Then go into your control panel and click on the Mail icon. When the profile box comes up go ahead and remove your email profile. I didn't have to reboot but you may want to go ahead and do that. When the computer gets back into windows then reopen outlook and it will ask you to rebuild your profile. Go through the profile rebuild and select the cached mode in your outlook to rebuild your .ost.

That fixed the issue for me and now my outlook is working as it should. I would say try this before reimaging your entire machine, but definitely try this first.
 

https://forums.techguy.org/threads/downgrading-office-2007-to-2003-outlook-problem.808502/
Relevancy 73.96%

I have found from several forums and support sites including Microsoft that many users are asking solution for the error generating by MS Access 2010 or 2007 while running their custom made Access 2003 database usually after after upgrade.
The error is showing as "The expression On Click you entered as the event property setting produced the following error: The expression you entered has a function name that Microsoft Office Access can't find."

The solution is as below:
This error is causing due to disabled macro setting by default. So you will need to enable the macro as per the following method.
Go to File > Options > Trust Center
Then Click on "Trust Center Settings".
Here click on the Option " Show the Message Bar ... ..."
Re-open the Access File in exclusive mode
Now click on the yellow message bar on to to enable macro..... ..... problem solved.
 

A:Access 2010 or 2007 upgrade error for 2003 database

Welcome to TSG and I appreciate the pro-active post.

A another solution is to learn the Trust Center. In there you can enable all macros.
 

https://forums.techguy.org/threads/access-2010-or-2007-upgrade-error-for-2003-database.1091718/
Relevancy 73.96%

When we try and set an attachment with an email it strips the attachment but still sends the email. We've reinstalled outlook but this didn't make a difference. We've also turned off our anti virus software and it still doesn't attach. The email message itself is send but any attached file is stripped off the email and doesn't go to the recipient or our outbox.
If any one could help or have any ideas it would be great.
 

https://forums.techguy.org/threads/outlook-2007-email-problem.794617/
Relevancy 73.96%

I'm looking for a free DVD Movie Database Template for my Excel 2003. I'd just want to have basic info in columns: Title/Genre/Release Date/Director etc. I want to be able to alphabetize columns A>Z. (Probably by clicking on column header.)

I've already tried 'The Google', but results were always ultimately 'Purchase'.

I'd be very grateful for some good suggestions to do this!

Kind regards,

Kenhort
 

Relevancy 73.53%

This is my first post here, hope I do it right.
I tried to send a spread sheet as an attachment but I keep getting an error message "the connection was interrupted"
error 451.
I suspect the attachment is just too large so I want to just delete it but I can't move it or delete it because outlook has already started sending the message.
Does any one have any suggesting how I can delete this message?
I keep getting this error every few minutes when ever I have outlook running.

Thanks

A:Outlook 2003 email problem

Welcome to Bleeping Computer, jscatam1128.

Here is the solution to your issue:

Turn off your computer.
Disconnect your PC from the cable modem. Now launch Outlook. Outlook will try to do a send/receive cycle, but it will fail pretty quickly. Now, you can open the outbox and delete the stuck message. Close Outlook, turn your computer off again, reconnect the PC, boot up, and you should be back in business.

http://www.bleepingcomputer.com/forums/t/215838/outlook-2003-email-problem/
Relevancy 72.67%

Receiving forwarded emails that are not addressed or sent to me. Senders did not include my address when they forwarded the email. There is nothing on the server that would suggest any time of rules or settings that would have these emails come to me from these senders.
 

A:Outlook 2003 Forwarded Email Problem

You could be in the message's Bcc list. Just tested this with Outlook 2003 on a POP3 account. The incoming forwarded message did not show my address. The header did show my address as a Bcc address.
 

https://forums.techguy.org/threads/outlook-2003-forwarded-email-problem.675220/
Relevancy 72.67%

Hardware: Dell Inspiron 700m
Operating System: Windows XP Home
Email Client: Outlook 2003
Anti-virus: PC-Cillin Internet Security 2006

Guys, I am having a problem recieving email on Outlook 2003 after I install the PC-Cillin Internet Security 2006. Sending email quite okay, but recieving is such a pain. I tried to disable the incoming mail scan on pc-cillin and it solves the problem, though its slow.

Is there any fixes for this issue? I still want to enable the incoming mail scan, while checking the mail.

Any response to this matter will be highly appreciated.

Thanks a lot.
 

A:Email Thru Outlook 2003 - problem with PC-Cillin

Hi noeluylee,

Welcome to TSG!

You can goto the Support-Knowledge Base website at Trend Micro and scan for a solution:
http://esupport.trendmicro.com/support/supportcentral/supportcentral.do?id=m1
Advanced search link allows your search to be more specific.

You can also send email to request support from Trend Micro on the issue at: [email protected]

-- Tom
 

https://forums.techguy.org/threads/email-thru-outlook-2003-problem-with-pc-cillin.464904/
Relevancy 72.67%

Hi,

I run outlook 2003 on a win xp sp2 system. I have recently been unable to send emails from outlook. I appear to be properly set up with pop3 to my yahoo mail account.

When I try and send or forward an email from outlook, it appears to leave the outbox and appears in the sent items folder. However it doesn't appear in my yahoo mail box either in the inbox of sent to my yahoo account or the sent items if sent to another account.

Does anyone know what is going on and how to fix it please?

Will
 

A:Outlook 2003 - problem sending email

First, you need all the Outlook 2003 updates downloaded and installed. There are at least three of them. Use the Office Updates header.
Then you need to look at the help site at Yahoo regarding outlook 2003 installs.
 

http://www.techspot.com/community/topics/outlook-2003-problem-sending-email.98393/
Relevancy 72.24%

Hi,

I have Outlook 2007 installed on laptop and have set-up an email account to use. The problem is that I can send email to other people's email addresses from this outlook 2007 account, but I am unable to receive email from other people?

Have read within this forum about correctly signing out of ISP accounts (if users read their email via web)- I personally never read via ISP's pages but did make a check to see if I had logged into ISP's web pages which I hadn't.

Not sure what's going on with the application in this instance & appreciate any help you can offer me for this particular prob in advance.

Thanks for reading.
 

A:Solved: Outlook 2007 email receive problem

If you are using Win Vista try this

http://support.microsoft.com/kb/935400

To determine whether this problem is caused by a network hardware device that does not support TCP Window Scaling, follow these steps:
1. Click Start , click All Programs, and then click Accessories.
2. Right-click Command Prompt, and then click Run as Administrator.

If you are prompted for an administrator password or for confirmation, type the password, or click Continue.
3. At the command prompt, type the following command, and then press ENTER:
netsh interface tcp set global autotuninglevel=disabled
 

https://forums.techguy.org/threads/solved-outlook-2007-email-receive-problem.599152/
Relevancy 72.24%

Please don't laugh but I am trying to use a contacts feature of Outlook 2003 as a CRM. There are some strange behaviors and I cannot find any documentation to explain them.

Telephone calls that were recorded as a “new journal entry for contact” two weeks ago have vanished from the activities ta if I searched the Journal. The phone calls are there. I don't know why they had moved away from the activities tab since I can't find any settings that a timeline on retention.

Similar things have happened with e-mail.

If you have some experience in this area I would appreciate your help
 

A:Outlook 2003 as a database

You need something like Outlook Business Contact Manager. It integrates with Outlook and does use a SQL based back end to store the data. I think it only works wiht Office Pro.
 

https://forums.techguy.org/threads/outlook-2003-as-a-database.998646/
Relevancy 72.24%

Hi,
I transferred all my old Excel (2003 and before) files to my new notebook which has Vista HP and Excel 2007. I open an old Excel file and it looks OK but when printing or print previewing, every line appears double-spaced and the document runs over to a second page.
If I change the row height it prints the squeezed up text but still double-spaces. If I copy the whole content of the spreadsheet into a new blank spreadsheet it prints normally.
Is there any setting in Excel 2007 that I might have missed ?
Thanks.
RB
 

Relevancy 72.24%

Running Windows Vista Premium Home Edition I have an Excel spreadsheet that I originally created on Excel Office Professional Edition Solved: won't applications 2007 Excel & Excel open on 2003 Windows Vista Some Also have Excel Home and Student Edition installed I uninstalled the Excel software but now when I clik on this created Excel spreadsheet with Excel it will not open It says there is an invalid path I reinstalled Excel and it opens I tried to save this as an xlsx extension and then uninstalled Excel It wouldn t open So something is occurring here On other Excel created spreadsheets they open without issue Then I have a program with an exe extension It needs to open using Excel With both Excel and Excel it will not open It freezes and then I get Solved: Some Excel 2003 & Excel 2007 applications won't open on Windows Vista an error message saying it cannot open with another Excel other than If I right clik on the exe program there is no quot Open with quot I even tried opening a blank Excel spreadsheet and then cliking on quot Open quot but it is a bunch of gibberish My IT person says you can t open the program that way You have to launch it as an exe program using Excel Any ideas on what is going on By the way I have both Excel versions on my laptop running Windows XP and I do not have these issues at all nbsp

A:Solved: Some Excel 2003 & Excel 2007 applications won't open on Windows Vista

Hi there,

If I said I was confused that'd be an understatement I think. You cannot open executable files (*.exe) with Excel. Recognized file types are things like .xls, .xla, (for 2007) .xlsx, .xlsb, .xlsm, etc. I don't know what your exe file is and I'm not sure I wanna know, but it certainly doesn't open in Excel. What is it exactly? If you don't know I wouldn't open it. Or if someone told you to open it with Excel then it's probably a virus. Unless I'm missing something here.

With the file in question which won't open, assuming it's not this strange and unknown exe file you're talking about, sounds like the file may have been corrupted. Does it open on any other machine? And if you uninstall Excel 2003, did you re-install 2007? It seems strange. I would try cleaning out your application and reinstalling 2007 fresh. You can't install 2003, then 2007, then take off 2003 and put it back on, you're gonna get things screwed up. I bet your registry doesn't know which way to turn here. Some good info on it can be found here...

http://officearticles.com/misc/best_install_procedures_for_microsoft_office.htm

Also, I would highly recommend you completely uninstall all versions, and I'm talking a deep cleaning, then reinstall. For that deep cleaning, take a look at this article (which I'd highly recommend you do) and then reinstall...

http://officearticles.com/misc/remove_microsoft_office_from_your_pc.htm

HTH
 

https://forums.techguy.org/threads/solved-some-excel-2003-excel-2007-applications-wont-open-on-windows-vista.876825/
Relevancy 72.24%

Hi Folks,
I have a valued Excel 2003 spreadsheet that, I can currently only open in Excel 2007. However, an error message has been displayed that Excel was unable to read some of the document and it did a recovery. The file has now lost a few key sections. I have attached the error log below.

Any suggestions please?

Thanks,
Dave

<?xml version="1.0" encoding="UTF-8" standalone="true"?>

-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">

<logFileName>error033640_01.xml</logFileName>

<summary>Errors were detected in file 'C:\Users\User\Documents\tool sourcing.xls'</summary>
-<additionalInfo>

<info>Excel recovered your formulas and cell values, but some data may have been lost.</info>

</additionalInfo>

</recoveryLog>
 

http://www.pcreview.co.uk/threads/lost-data-when-opening-excel-2003-spreadsheet-in-excel-2007.4069122/
Relevancy 72.24%

I m using Windows and I used a macro which worked totally Solved: Run Doesn't Excel 2007 - Macro in Excel Requested 2003 Help fine under Excel Now under Excel it does not run anymore but displays the following error message quot Run-time error Object doesn t support this action The function of the macro is to open up all other Excel spreadsheets located in the same folder and copy data out of them into the spreadsheet in which the macro is stored When I click on quot Debug quot the Visual Basic Editor highlights the row which says Set FilSrch Application FileSearch Can you help me with this I ve searched for Solved: Excel 2003 Macro Doesn't Run in Excel 2007 - Help Requested a solution for a long time but could not find anything which worked The following is the start of the macro code Sub UpdateTable Dim X As Range I As Integer J As Integer RecNo As Integer CopyVal As Variant Dim SourceBk As Worksheet DestBk As Worksheet StartRow As Integer IndRange As Range Dim ServRange As Range SrcOpen As Boolean SourceName As String Dim FilSrch As Object MyFilArray As String MsgBox quot This function not available in this version quot vbInformation quot Function Not Available quot Exit Sub Sheets quot LookUp quot a Now With Application ScreenUpdating False StatusBar quot Counting source files quot End With Set FilSrch Application FileSearch With FilSrch NewSearch LookIn ActiveWorkbook Path FileType msoFileTypeExcelWorkbooks If Execute gt Then ReDim MyFilArray FoundFiles Count For I To FoundFiles Count If FoundFiles I lt gt ActiveWorkbook Path amp Solved: Excel 2003 Macro Doesn't Run in Excel 2007 - Help Requested quot quot amp ActiveWorkbook Solved: Excel 2003 Macro Doesn't Run in Excel 2007 - Help Requested Name Then MyFilArray I FoundFiles I End If Next I Else MsgBox quot There were no files found quot End If End With nbsp

A:Solved: Excel 2003 Macro Doesn't Run in Excel 2007 - Help Requested

https://forums.techguy.org/threads/solved-excel-2003-macro-doesnt-run-in-excel-2007-help-requested.991531/
Relevancy 71.81%

Hi,

I have a user who is using Office 2003 on Win Xp pro.

The user is composing an email - which has a font of say Arial 10, and then they copy some text from a MS Word document where the font is Times New Roman 11 - and paste that onto the email.

Now they want to change all the font on that email onto the same - say Arial 10.

However, when they change it from the toolbar; it doesnt get reflect - i.e the different fonts dont get changed.

what should I do?

Thanks
 

https://forums.techguy.org/threads/outlook-2003-fonts-problem-when-composing-new-email.843761/
Relevancy 71.81%

Hello I am having a problem with my email not working correctly I can receive email but when I try to create a new email and click on my address 2003 Email Outlook Problem Book/new Address book the mouse icon disappears off to Outlook 2003 Address Book/new Email Problem the right hand side of the screen The program appears unresponsive as I am unable to select any tool bar icons shows no indication that I clicked on anything nor am I able to close the untitled message screen or minimize it I have opened task manager and selected end task untitled message When that task ends it switches back to the inbox screen with a Select Names window in the task bar At this point the Inbox screen is still unresponsive but now I can right click the Select Names window in the task bar and close it When that closes then the Inbox screen seems to restore control I have updated Microsoft Office to service pack after this situation presented itself The O S is X P Pro Microsoft Outlook This system has been running problem free for about year If anyone could help in solving this issue I would greatly appreciate it Thank You Mod Edit Topic moved to more appropriate forum TMacK

A:Outlook 2003 Address Book/new Email Problem

Hello to all,

I have resolved my issue with address book. It appears that my address book was opening up off screen on the right hand side. I am not sure what had changed in regards to why it had opened off screen or why it now has restored to the middle of the screen. The only thing that I had done recently was to send an email to a friend and typed in the email address then clicked send. After that when I tried to create a new email and select the address book it would open the window in view.

Basically I'm a moron but had to post the resolution to my problem anyways.
PROBLEM SOLVED.

http://www.bleepingcomputer.com/forums/t/109984/outlook-2003-address-booknew-email-problem/
Relevancy 71.81%

I've recently have a new laptop that has WV Operating System. I"m using Outlook 2003 and have just tried to add my new hotmail account into Outlook.

BUT I GET AN ERROR MESSAGE SAYING I NEED A PAID SUBSCRIPTION FOR THIS. IN RESEARCHING ONLINE THIS [APPARENTLY] THE STANDARD.

MY QUESTION IS....WHAT FREE EMAIL ACCOUNT WORKS WELL WITH VISTA AND OUTLOOK 2003? DOES YAHOO OR INSIGHT?

ANYBODY HAVE ANY IDEAS?????????
 

Relevancy 71.81%

Firstly I am a beginner of beginners but I try to learn as much as I can I have put the following protection code into an Excel workbook and everything runs ok I then opened the workbook in Excel and saved it as a xlsm file When I try to open the xlsm file in Excel I get a vba Runtime error quot Type mismatch quot and the code sticks at the first line below quot If Worksheets I have tried everything that my limited knowledge allows searched the web for days and still have no answers Any help would be greatly appreciated Private Sub Workbook Open If Worksheets A gt quot quot And Worksheets A Worksheets A False Then MsgBox quot Sorry this program is not registered for 2007 2003 Solved: Excel working in not Excel vba code this computer please e-mail for more info quot Application DisplayAlerts False Application Quit End If End Sub My system specs are shown below Tech Support Guy System Info Utility version OS Version Microsoft Windows Home Premium Service Pack bit Processor Intel R Core TM i CPU M GHz Intel Family Model Stepping Processor Count RAM Mb Solved: Excel 2003 vba code not working in Excel 2007 Graphics Card Intel R HD Graphics Mb Hard Drives C Total - MB Free - MB Motherboard Dell Inc WXY J Antivirus avast Antivirus Updated and Enabled nbsp

Relevancy 71.38%

I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The interesting thing is that if I try to open the same file that I have saved within the last year (before I got 2007) then I can do it? That is, I have a cache folder of files that I go get to do calculations then save in a new job folder. The ones in the new job folder will open (also 2003), but the ones in the original cache will not? I would truly appreciate any suggestions. Thank you.

A:Can't open 2003 Excel Files in Excel 2007?

Have you attempted to set them up in 'Compatibility Mode." Not sure if this will help, just hoping it will. I have been testing the new Microsoft Office 2010 Beta 64 bit, and have yet to have this problem, and like you I have a great deal of files in 2003 (never used 2007)'

I think you can still download MS Office 2010 beta from Microsoft's download site. Good Luck.

BTW, Welcome To The Seven Forums.

http://www.sevenforums.com/microsoft-office/55387-cant-open-2003-excel-files-excel-2007-a.html
Relevancy 71.38%

I purchased Excel 2007 to take advantage of the larger number of rows and columns. My SS applications are very large and I run out of columns. But after trying my Excel 2003 in the new 2007 software, I find that 2007 runs 10-20 times slower, making it completely unusable. Googling the problem shows it's a widespread issue. MS help desk essentially no help. Any suggestions?
 

A:Excel 2007 Runs MUCH Slower than Excel 2003

The biggest thing that slows Excel 2007 is also what you wanted it for - the greater number of cells. If your formulas have cell references like A:A or $1:$1, then that is a lot more cell references for it to process.
Read this http://msdn2.microsoft.com/en-us/library/aa730921.aspx and maybe you will get some ideas on how to make your files process faster.
 

https://forums.techguy.org/threads/excel-2007-runs-much-slower-than-excel-2003.686950/
Relevancy 71.38%

Hi can anybody tell me hoe to copy macros from excel 2003 to excel 2007?
The excel 2003 is running under windows xp and the 2007 under windows vista.
(The two versions of excel are installed at differnt computers)

A:Copy Macros From Excel 2003 To Excel 2007

I don't know Excel 2007 nor Vista.
But the usual way to copy macros brute force would be to open the VBA toolbar, get into the Modules, select each, and Export one by one. Then import into 2007 modules if Excel 2007 VBA permits that.
If export/import doesn't work, you can always copy out the entire text into Notepad text files, and copy/paste from the Notepad into your 2007 Excel.
If the VBA language or object model has changed between 2000 or 2003 and 2007, then some tweaking might be in order, but I suspect they left it alone, and the error messages, if any, might suggest what to fix.

Since these are different computers, either network them and share some common directory, or use USB flash drive for transfers of the, say, Notepad files.

Export is good, because it names the modules. They get saved someplace in your local settings. Notepad will not name, and doesn't matter really.

http://www.bleepingcomputer.com/forums/t/171245/copy-macros-from-excel-2003-to-excel-2007/
Relevancy 71.38%

Does anyone know how to run Excel 2003 print macro on Excel 2007 or higher? When I tried running my 2003 macro, the VBA editor pops up w dialogue box, " Run-time error '1004': Method 'ActivePrinter' of object'_Application' failed ".

This is my code: Application.ActivePrinter = "Epson LQ-300 ESC/P 2 on USB003"

Can anyone help?

Thanks!
 

A:How to run Excel 2003 print macro on Excel 2007?

Welcome to TSG hope we can help you and you can help others.

I'm not an Excel macro guy but you code looks reasonable. What happens if you run this. I suspect printer name is a little off.

MsgBox "The name of the active printer is " & Application.ActivePrinter
 

https://forums.techguy.org/threads/how-to-run-excel-2003-print-macro-on-excel-2007.1062379/
Relevancy 70.52%

Up until my old laptop melted down in the spring of I ACT! Outlook Contact 6.0 as Database Linking to 2003 a had my ACT database linked to my Outlook With my new laptop Windows bit where I run the Outlook and an XP Pro VM where I run the Act I have lost the link Act saves as Act or exports as ccx dbf or text delimited Outlook accesses Linking Outlook 2003 to ACT! 6.0 as a Contact Database the contact database as PAD Q Is there a way to convert one of these outputs into a PAD so I can connect it to Outlook Tech Support Guy System Info Utility version OS Version Microsoft Windows Professional Service Pack bit Processor Intel R Core TM i CPU M GHz Intel Family Model Stepping Processor Count RAM Mb Graphics Card Intel R Graphics Media Accelerator HD - Mb Hard Drives C Total - MB Free - MB D Total - MB Free - MB G Total - MB Free - MB Motherboard Dell Inc TKV Antivirus avast Antivirus Updated and Enabled nbsp

A:Linking Outlook 2003 to ACT! 6.0 as a Contact Database

PAD files are for ACT! 2005 (7.0) and later. ACT! 6.0 did it this way:
http://kb.sagesoftwareonline.com/app/answers/detail/a_id/12526

It doesn't always work on Win 7 as ACT! 6 wasn't designed for it ... and especially with 64bit
You might try disabling the User Access Control or running ACT! and Office in a virtual XP machine
 

https://forums.techguy.org/threads/linking-outlook-2003-to-act-6-0-as-a-contact-database.1033450/
Relevancy 69.66%

Why does the second line of the code shown below produce an error in Excel 2007 and not in Excel 2003? The error is:
Run Time Error ‘1004’, Unable to set the Text Property of the Characters class

ActiveSheet.Shapes("btnJobSummary").Select
Selection.Characters.Text = "Prepare Job Summary" & Chr(10) & "for " & CurrentJob

CurrentJob is defined as: Public CurrentJob As String

In this case it equals: RockMont Rev 7-9-04

No problem at all in Excel 2003 and earlier. If CurrentJob is something shorter (e.g. MyFile), there is no error. I don't think the spaces are a problem either because I still got the error after adding Chr(34) before and after CurrentJob in my code. Any ideas? Thank you.
 

A:Error in Excel 2007 but not in Excel 2003

Hello, welcome to the board!

The text is too long. Use an ActiveX control instead of a Forms control. Then you can use similar code...
Code:
Public Const strCurrentJob As String = "RockMont Rev 7-9-04"
Dim btn As CommandButton

Sub FooTest()
Set btn = Sheet1.CommandButton1
btn.Caption = "Prepare Job Summary" & Chr(10) & "for " & strCurrentJob
End Sub
HTH
 

https://forums.techguy.org/threads/error-in-excel-2007-but-not-in-excel-2003.643691/
Relevancy 69.66%

Is there a way to clear, and add Fill color to an Excel spreadsheet? Please see the attached file.

I need this to be compatible with Excel 2003 & 2007.
 

Relevancy 69.66%

Hi there.

I'm trying to open an Excel 2007 document with Excel 2003. I thought that I had downloaded what I needed to be able to do that, but I guess not. Is there a way to do this? I suppose I could upgrade to newer version if I need to. If so, should I go ahead and get the newest version and get it over with?

Thanks for your help and time. Have a good day.
 

A:Open an Excel 2007 doc with Excel 2003?

Have you tried the office 2003 compatibility pack https://www.microsoft.com/en-us/download/details.aspx?id=3
 

https://forums.techguy.org/threads/open-an-excel-2007-doc-with-excel-2003.1151846/
Relevancy 69.66%

Does anyone know the best way to setup a Macro in Excel 2007 that will work in Excel 2003 as well?

I have an Excel 2007 workbook that I am using a macro to change the "Fill Color" and "Font Color" of cells. However, I will get everything working in Excel 2007, but when I open the workook in Excel 2003 I get many debug errors.

If I change the code in Excel 2003, and then re-open in Excel 2007 I get debug errors.

There must be a way to setup teh workbook to work on both Excel 2007 & 2003.
 

https://forums.techguy.org/threads/excel-2007-excel-2003-macro.750745/
Relevancy 69.23%

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
 

A: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.
 

https://forums.techguy.org/threads/issues-importing-large-contact-list-in-excel-2007-to-outlook-2007.931697/
Relevancy 68.8%

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
 

https://forums.techguy.org/threads/trouble-opening-excel-2007-attachment-from-outlook-2007.742275/
Relevancy 68.37%

Hi,

I have a laser jet printer HP 2015. If i print email recd. with excel embedded cells in Landscape mode from a XP OS / Outlook 2003 / Excel 2003, the contents are fully printed.

But if i print the same email in landscape mode from Windows Vista / Windows 7 / Outlook 2003 / Excel 2003, the contents are not printed in full, i.e the last 3 to 4 columns of excel embedded cells are not printed.

Pl. help.

Thanks
 

https://forums.techguy.org/threads/landscape-printing-vista-home-outlook-2003-and-excel-2003.954065/
Relevancy 68.37%

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.
 

Relevancy 67.94%

I have designed a small program in both excel 2003 and 2007, both are set up identically, users can only enter data in 3 unlocked cells, all other cells on the sheets are locked, my problem is as follows

in the excel sheet 2007 the user can use the tab key, the enter key or the arrow keys to move between the 3 unlocked cells c1,c2,c3, if the user has entered data in c3 and then use's one of the above keys c1 is highlighted, but in excel 2003 the arrow keys and tab key works to move between c1,c2 and c3, but if thre user has entered data in c3 and press's the right arrow or tab key the excel sheet stops responding, the enter key doe's not work either

any idea's please
 

Relevancy 67.94%

I converted a excel 207 file to 2003 and it changed in size from 6MB to 31MB. How do I find the key reasons for the massive size and how to reduce it?

A:Excel 2007 to 2003

It happens in both versions when saving a file created with the other version and it will occur for almost all files. Basically it's because the data within the file gets saved twice. Once in the original format in which it was saved, and then again in the format you are saving it to.

http://www.techsupportforum.com/forums/f10/excel-2007-to-2003-a-389058.html
Relevancy 67.51%

I am looking for help in writing a macro that will do the following With Excel open and the current workbook open The macro should be able to save variables from the current spreadsheet Task or 2003 Excel help Outlook Macro 2003 some text a value and a date The Outlook 2003 or Excel 2003 Task Macro help macro should open up Outlook as a task attach the current workbook In the Subject field of the task it should add the user s name then the attached spreadsheet s filename then the text variable then the value variable and finally the date Also it would be great if the Priority of the task could be set to High and the Start and Due dates set to calendar days before the date variable Finally the macro would set a list of people the task is assigned to The macro should NOT save the task as a check would need to be done manually I have tried unsuccessfully to write a macro in Outlook as I cannot seem to access the attachment filename or any data from the file I have tried a macro in Excel which I can create a task and add some text to the Subject of the task but with no real progress on the attachment I have tried searching the net for help but a lot of code for Outlook is for the mail side of things rather than tasks and the little code snippets I have found have been of limited use I have limited skills in programming Visual Basic and C so quite prepared to get my use code which does similar things nbsp

https://forums.techguy.org/threads/outlook-2003-or-excel-2003-task-macro-help.788983/
Relevancy 67.51%

Hi there,
I want to push specific data from a selected contact in Outlook 2003 to a predefined Excel 2003 spreadsheet. The scenario is that I want a naive user to enter data into a new contact in outlook be able to push a button and insert that data into a quotation that exists as a excel file. The data that I am interested in moving includes.

Title
First name
Last Name
Company
Address Fields
Telephone Number

I have already created the spreadsheet based Quotation form in a file called Quote.xls. I have not named the individual cells at present just having the Name in Cell B1 The company in B2 and the address fields in B3 to B7.

I have done some macro and VBA programming in Excel, but have little or no experience in using Outlook macros.

Any help/suggestions/solutions gratefully received.

Regards

Michael
 

Relevancy 67.08%

Anyone know what's up with this, or how to solve it?

We've got a script written for Excel 2003, that seems to be working, but we need it to work in 2007... and it's not!!!

This makes no sense (except that it is on a Microsoft produce and should have been expected,... ).

Has anyone else had this issue, and solved it?

Can you share that solution please?

(I'm trying to find a Excel 2003 machine right now, but still trying to save time by getting this to work on the hardware in place...)

Much thanks,
J.
 

Relevancy 67.08%

I just put in a new hard reading 2003 folders Move not not 2007 from successful; Outlook to certain Outlook drive and installed the latest version of Office I kept the data and archive files from Outlook so I could import them into Outlook and get back to business However that did not happen It was able to read and bring up most of the data but I am missing some folders which are critical The critical folders are folders that were created manually They were used to store email messages that came in that were important They were simply dragged from the Inbox and put into that folder There were also folders within that folder I m not sure if these folders and subfolders were in the Inbox or not They may not have been The way I imported it was by going to TOOLS gt ACCOUNT SETTINGS gt DATA FILES tab gt and pointed to the old PST file I also pointed to the archive pst file as well but later went to FILE gt ARCHIVE and pointed to the Move from Outlook 2003 to Outlook 2007 not successful; not reading certain folders old archive pst file in there Bot ways did not reveal the folders that are needed Is Outlook not able to read all data from Outlook pst files or is there a fix for this Please advise nbsp

A:Move from Outlook 2003 to Outlook 2007 not successful; not reading certain folders

I purchased a new Notebook with Office 2007 installed and copied over my Outlook 2000 pst file. I also had manually created folders for filing important emails. Mine were sub folders within the Inbox folder. Everything copied over, but I could not see the manual folders at first until I double clicked the Inbox folder in the side panel and then they spilled out. I would look for them in that panel and double click anything there starting with Inbox, Sent etc. Also try doing a search for any subject or address of an email you may have saved.

When copying over the pst file I think everything is copied. Appears you did not just copy contacts for example, but the complete pst file. I think the folders are there as Sub Folders, just hidden within one of the main folders such as Inbox.
G
 

https://forums.techguy.org/threads/move-from-outlook-2003-to-outlook-2007-not-successful-not-reading-certain-folders.580711/
Relevancy 67.08%

Hello I originally posted this question on November in the Email section and in spite 2003 used Outlook 2003 email for Word as editor of many views there were no replies That is when I thought I might be going about asking the question the wrong way Windows XP - SP Microsoft Word and Microsoft Outlook I use Word as my email editor for Outlook Word 2003 used as email editor for Outlook 2003 I had had a problem or two awhile back and I used the Detect and Repair Function that comes with Outlook Problems cleared up HOWEVER I got a new and IMHO worse problem my emails that are advertisements like Newegg TigerDirect Overstock etc are fine but anything else that is actually text that is sent to me comes in very very small and I can not find a way to change it I have looked everywhere in Outlook Microsoft online and Google Sample attached I can t find it and it is driving me crazy If anyone could help I d sincerely appreciate it Thank you for your time nbsp

A:Word 2003 used as email editor for Outlook 2003

Hi and welcome to TSG.

From the main Outlook Mail screen, try ...

Tools ->
Options ->
Mail Format Tab ->
"Fonts ..." button in Stationery and Fonts section ->
"Choose Font ..." button under "When composing and reading plain text"
 

https://forums.techguy.org/threads/word-2003-used-as-email-editor-for-outlook-2003.961599/
Relevancy 67.08%

This appears to be a common problem, with many solutions, though I have yet to find one that works for me. When using Outlook 2003 with Word 2003 set to be the email editor, Word opens and works fine to CREATE a new email. However, when trying to REPLY TO or FORWARD an email, I get the error message "Microsoft Word is set to be your email editor. However, Word is unavailable, not installed, or is not the same version as Outlook. The outlook email editor will be used instead...," and when I click OK to that message the native Outlook email editor opens. Word 2003 worked fine with Outlook 2003 replying to or forwarding emails till this morning, but the behavior described above now applies. The OS, by the way, is Windows 10. I have tried to both "repair" and "reinstall" the 2003 Office 2003 suite, both to no avail. Would appreciate a much needed solution to this puzzle.
 

Relevancy 67.08%

We are using Exchange Server 2010.

Some staff are using Outlook 2007. They are creating calendars which need to be shared with other employees, most of which are running only Outlook 2003.

All Outlook 2003 users get an email with a link to Microsoft explaining how to open shared calendars. Off07 users get the icon to click and open specified calendar.

Outlook 2003 user then follows MS instructions, and pulls up the Outlook 2007 user's default calendar, then they get this message "Unable to display the folder. The Calendar folder could not be found".

Is there something lacking here? Anyone have any work-a-rounds for Outlook 2003 users to open a shared calendar of an Outlook 2007 user?
 

https://forums.techguy.org/threads/sharing-outlook-2007-calendar-with-outlook-2003-users.938467/
Relevancy 67.08%

Most of my users are on Outlook 2003, but some are on Outlook 2007. When a 2007 user uses the scheduling assistant to try and set a meeting, the message appears No Information. No free/busy information could be retrieved.

Note: a 2003 user can see the other 2003 user's schedule.

Is this something that needs to be set at the Exchange level? How do I resolve?

All users are on Windows XP SP2
 

https://forums.techguy.org/threads/seeing-outlook-2003-schedule-when-requesting-a-meeting-in-outlook-2007.845123/
Relevancy 67.08%

I have an external software that creates and distributes an email to users with a link to view a report. The external software creates the email with Outlook 2007. Recipients that are using Outlook 2003 do not see the link, just the plain text. The workaround is to highlight and paste into the browser.

The software company says that it is a Microsoft issue.

I see lots of posts about creating HTML in 2003, but nothing about reading...

Help?
 

A:Links created in Outlook 2007 not a link in Outlook 2003

Some mail servers do not accept HTML formatted messages and only allow plain text? Are these recipients on en Exchange server or just some random POP accounts?
 

https://forums.techguy.org/threads/links-created-in-outlook-2007-not-a-link-in-outlook-2003.1041521/
Relevancy 67.08%

I have been using the beta version of Office 2007 til it expired last month and during that time exported a back up of Outlook (contacts, calendar etc) to My Docs.
Not all that fussed with the '07 Office suite, I uninstalled it and then reinstalled Office 2002 but when I try to import the pst file to this earlier version of Outlook, it tellss me that it is not compatible and to contact the Administrator (me!).

If I cannot work around this somehow I intend laying on the railway tracks quite shortly as life without my files will no longer have any meaning to me!

I guess as a last resort I can download the latest trial of 2007 Office and see if that will let me re-import the backed up pst file but what a drama!
 

Relevancy 67.08%

Hi everyone,

At work we have outlook 2003 and I cannot upgrade that computer, at home I have recently upgraded to outlook 2007 but it left me with a little problem.

I use tasks to delegate jobs out to my team and I have it set up so categories are in fact their names. I used to send task requests with the name of the employee in the category section and when it arrived in the work inbox someone would accept the task and it would immediately go into that particular employees task category.

Now I have 2007 Outlook and although I have set categories up as they used to be (employee names) the task request gets accepted (at work) and instead of going under the employee name it goes into it's own category with no specific category.

Can anyone tell me (short of going back to outlook 2003) how to solve this issue?

Thanks

g4ztfa
 

https://forums.techguy.org/threads/outlook-2007-task-request-to-outlook-2003-issues.946042/
Relevancy 67.08%

We are using Exchange Server Some staff in our executive branch have brand Sharing 2007 Outlook with calendar users 2003 Outlook new laptops lucky guys with Office Of They are creating calendars which need to be shared with other employees most of which are running only Outlook OL Calendar s are Sharing Outlook 2007 calendar with Outlook 2003 users made and invites sent for specific calendars to specific groups of users IE Regional Sales Mgr creates several supplemental quot events quot calenders he wants to share with his different teams Calendars ---Default Corporate Dist Dist Dist Region Group ---DistGrp DistGrp DistGrp Permissions ---Dist calender -- gt DistGrp ---Dist calendar -- gt DistGrp ---Dist calendar -- gt DistGrp ---Region -- gt DistGrp DistGrp DistGrp All OL users get an email with a link to Microsoft explaining how to open shared calendars Off users get the icon to click and open specified calendar OL user then follows MS instructions and pulls up the Off user s default calendar with no option to open or even locate any other calender Is there something lacking here Anyone have any work-a-rounds for OL users to open a shared calendar other than the default or main calendar of an OFF user Thank you nbsp

https://forums.techguy.org/threads/sharing-outlook-2007-calendar-with-outlook-2003-users.766056/
Relevancy 67.08%

We've purchased a new laptop and are using Office 07 now, Windows XP, instead of the old office 03. Regarding Outlook, when I tried to save the old .pst file(Outlook 03) and then import old emails and contacts, the emails imported very easily into Outlook 07. However, none of the contacts were imported. Is there a simple way to export or save Outlook 2003 contacts to a file that can then be imported into Outlook 2007 on a separate computer??

Thanks

Gene
 

A:Trouble transferring Outlook 2003 contacts to Outlook 2007

Export the old contact as a .CSV file and then re-import into the new installation.

Regards,
Rollin
 

https://forums.techguy.org/threads/trouble-transferring-outlook-2003-contacts-to-outlook-2007.633428/
Relevancy 67.08%

I'll bet you have not heard this one before. I was attempting to send an email to a potential client. Everything seemed to work well except that it was returned. The problem was that the address was changed somewhere. His name is spelled with a j but somewhere along the line, it was changed to a k and so there was no such person and therefore was returned to me.

#550 5.1.1 RESOLVER.ADR.RecipNotFound; not found ##rfc822;

What could have happened? This is a new one on me.

A:outlook 2007 changed email address so email was returned

Hi.

Did you get a message similar with these?
----------------------------------------------
Hotmail:

This is an automatically generated Delivery Status Notification.

Delivery to the following recipients failed.

-----------------
Windows Live mail:

I'm sorry to have to inform you that your message could not
be delivered to one or more recipients. It's attached below.

For further assistance, please send mail to postmaster.

If you do so, please include this problem report. You can
delete your own text from the attached returned message.

http://www.sevenforums.com/microsoft-office/207707-outlook-2007-changed-email-address-so-email-returned.html
Relevancy 67.08%

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.
 

Relevancy 66.22%

Hi I m supposed to be calculating the sum of Excel 2003 compatibility sum / 2007 colour - cells based on their font colour i m working in excel and i ve got the Vba module code for the process - Code Function ColorFunction rColor As Range rRange As Range Optional SUM As Boolean Dim rCell As Range Dim lCol As Long Dim vResult lCol rColor Font ColorIndex If SUM True Then For Each rCell In rRange If rCell Font ColorIndex lCol Then vResult WorksheetFunction SUM rCell vResult End If Next rCell Else For Each rCell In rRange If rCell Font ColorIndex lCol Then vResult vResult End Excel 2003 / 2007 compatibility - colour sum If Next Excel 2003 / 2007 compatibility - colour sum rCell End If ColorFunction vResult End Function i ve got it to work and add up all of the sums of the colours - no problem I then saved it and went to my colleagues computer running office excel tried to open the file - it opens but Excel 2003 / 2007 compatibility - colour sum where i ve wrote the cell formula sample ColorFunction G CU CU TRUE all i get is NAME in every cell i ve tried rewriting the formula rewriting the vb code copy paste but i still cant get it to show the formula results just to confirm - it works in but not what am i doing wrong Thanks nbsp

A:Excel 2003 / 2007 compatibility - colour sum

Welcome to board.

I'm guessing "check macro security settings" at the other board didn't help.

There are various flavours of UDF for this; tried this one?

Function SumByColor(InputRange As Range, ColorRange As Range) As Double
' returns the sum of each cell in the range InputRange that has the same
' background color as the cell in ColorRange
' example: =SumByColor($A$1:$A$20,B1)
' range A1:A20 is the range you want to sum
' range B1 is a cell with the background color you want to sum
Dim cl As Range, TempSum As Double, ColorIndex As Integer
' Application.Volatile ' this is optional
ColorIndex = ColorRange.Cells(1, 1).Interior.ColorIndex
TempSum = 0
On Error Resume Next ' ignore cells without values
For Each cl In InputRange.Cells
If cl.Interior.ColorIndex = ColorIndex Then
TempSum = TempSum + cl.Value
End If
Next cl
On Error GoTo 0
Set cl = Nothing
SumByColor = TempSum
End Function
 

https://forums.techguy.org/threads/excel-2003-2007-compatibility-colour-sum.752553/
Relevancy 66.22%

we have microsoft office excel 2007 installed on our computer, however we like the older version 2003 better. are we able to load both on the same system? or do we have remove the 2007 to install 2003?

A:office excel 2007 & 2003 on same computer?

Originally Posted by jnielsen11


we have microsoft office excel 2007 installed on our computer, however we like the older version 2003 better. are we able to load both on the same system? or do we have remove the 2007 to install 2003?



For earlier versions of Office products, MSFT published a number of KB articles that describe the issue of having more than 1 version of Office in OS, andthey did list some significant potential problems.

Some of the articles were KB 292491, 218081, 828956 and 290576.

In any case, you would really have to uninstall 2007 before installing 2003.

http://www.vistax64.com/software/231064-office-excel-2007-2003-same-computer.html
Relevancy 66.22%

I am seeing an issue with the compatibility pack for 2007. If an Excel 2003 spreadsheet is opened then try to open a second file that needs to be converted, the second file never gets converted. All files in Excel 2003 must be closed in order for a 2007 file to be converted. Is there a way around this?

Thanks,
Karen
 

A:Excel 2003 and compatibility pack for 2007

First time I heard of it and I cannot reproduce it here with our Excel 2003 and openeing 2007 files. It just works.
 

https://forums.techguy.org/threads/excel-2003-and-compatibility-pack-for-2007.959082/
Relevancy 66.22%

I have done this twice now and still haven't figured out the resolution I have office installed on windows pro machines The users then try to open excel spreadsheets and they wont open because they are not compatible But there is an office patch I know I use it on all the desktops that have office but I forgot to in these two cases So once 2007 to Excel debacle 2010~2003 I have the problem corrected I have the fix and I wont do it again The problem The office xls file wouldn't open I decided the file association was missing so on the xls excel spreadsheet I highlighted it then right click gt Properites gt change Then i go to Browse C gt local disk gt Program files X gt microsoft office gt office gt excel The association is wrong I have tried to uninstall office and re install but that did not help at all I realized after i did this that the office compatibility pack wasnt installed so i installed the patch Excel 2010~2003 to 2007 debacle but that didn't help either The problem is that the xls is trying to associate with the xlxs i think Excel 2010~2003 to 2007 debacle I am basically trying to dis-associate the xls with any program and start over I thought that Excel 2010~2003 to 2007 debacle it might be a registry setting I have no idea anymore Any ideas I can't be the only one who has ever done this Thank you in advance for any help you might be able to provide

A:Excel 2010~2003 to 2007 debacle

First of all, welcome to BC !
 
Try coming at your problem from a different direction. Go into Windows Explorer and pick on one of your Excel 2003 files - any one will do. In Windows Explorer RIGHT click on the name of this poor innocent file. In the menu that will open, click on 'Open with...', this will bring up the 'Open with' dialogue box.
 
In the centre of the box you will see an Excel icon. Do NOT click on this, instead click on 'Browse' at the bottom right hand side, and browse to excel.exe (Office 2003). The path is :- C:\Program files (or Program files(x86) if 64 bit systems)\MS Office\Office 11.
 
Office 2003 is listed as OFFICE 11. Here you will find an excel.exe file with the familiar icon beside it. Click on this to select it, then put a tick in the box on the other side of the 'Open with' dialogue box, the one that says 'Always use this to open files of this type'. You have just changed the attribute of all the Excel files in your system, and they should now all open in Excel 2003.
 
You are correct, you need the 2007 compatibility pack to open 2007 and later files in 2003, and there will be a pause of a few seconds while the software translates from .xlsx to .xls, but it always works for me.
 
Chris Cosgrove

http://www.bleepingcomputer.com/forums/t/525585/excel-20102003-to-2007-debacle/
Relevancy 66.22%

Hi folks!
Weird issue here. WHen I have an Excel spreadsheet open at the same time as Outlook, I try to copy and paste a portion of the spreadsheet to a new Outlook message. But as soon as I click on "New Mail Message"....Outlook stays open, but Excel closes immediately and what I copied to the clipboard isn't there any more.
I tried this on a second computer and it seems to work fine.
Any ideas on why this is happening on this one computer?

You people provide a wealth of information!!!
 

A:Outlook 2003 / Excel 2003 issue

Have you tried to perform a Detect and Repair to see if that resolves the issue?
 

https://forums.techguy.org/threads/outlook-2003-excel-2003-issue.743917/
Relevancy 66.22%

Hi Experts,
I have got a problem regarding to my inability to find .pst file in Outlook 2003/2007.
I downloaded repair tool to repair .pst file and tried to find it but no .pst file was available.
I used normal path to find the pst file (Documents and Settings/username/application data/microsoft/outlook), then went through Outlook2003- Tools-Options-Mail Setup tab- Data File, done search, selected ''Show hidden files and folders'' in Windows Explore and no .pst file is coming up.
Any clue where else to look for it so I can try to repair it.
Environment: Outlook 2003/2007 and Exchange 2007

Thank you in advanced!
 

A:Cannot find Outlook .pst file in Outlook 2003/2007

Right location - - but think you need the OST
 

http://www.techspot.com/community/topics/cannot-find-outlook-pst-file-in-outlook-2003-2007.217499/
Relevancy 66.22%

Hi,

Is an Outlook 2003 data file compatible with Outlook 2007? I hope to be able to copy the details of my Outlook 2003 email accounts, emails, contacts etc into an Outlook 2007 installation on another machine. Can I simply copy the data file over to the Outlook 2007 installation and select it as the data file to use in Outlook 2007?

Will this process copy the passwords and settings stored in my Outlook 2003 installation? Or, will I have to reconfigure the email accounts and passwords again in Outlook 2007?

Any advice most appreciated.

http://www.sevenforums.com/microsoft-office/402514-outlook-2003-data-file-into-outlook-2007-a.html
Relevancy 66.22%

I had a trial verson of Outlook 2007. After the trial, I uninstalled it. Now I cannot see send/receieve, cannot make rules plus other things.
Any ideas?
 

A:Outlook 2003 errors after Removing Outlook 2007

Found the answer.
had the answer, all you need to do is so a search for 'mapisvc.inf' on your C: drive. It will find 2 files, one in C:\Windows\System32, one in C:\Program Files\Common Files\System\MSMAPI\1033

I renamed both of them to mapiscv_old.inf - call it what you like, delete it if you are feeling game. Then run Outlook 2003, it will configure and put the file back there for you, and allow you to setup your account.
Posted by Rod at 10:32 AM

Thanks,
 

https://forums.techguy.org/threads/outlook-2003-errors-after-removing-outlook-2007.778437/
Relevancy 66.22%

I tried Outlook 2007 Trial and didn't like it. After removing and reinstalling Outlook 2003, the send/receive button is missing in the tool bar, I can no longer edit "rules", among other things.
Thanks,
Boss
 

https://forums.techguy.org/threads/outlook-2003-errors-after-removing-outlook-2007.720550/
Relevancy 66.22%

Intermittently, Outlook 2007 will crash while sending an email and, needless to say, the email is not sent. However I wanted to know if there is a temp or backup copy of that mail anywhere. I've looked in drafts and it's not there.

I've sometimes typed a very long email and then lost the whole email when Outlook crashes so I just wanted to know if, like Word, there is a temp file that may be created.

Thanks.
 

A:Outlook 2007- crash while sending email - where does the email go?

Hi cp, welcome to TSG. Do you have Autosave enabled for Outlook? If not, perhaps this link will help.
 

https://forums.techguy.org/threads/outlook-2007-crash-while-sending-email-where-does-the-email-go.886349/
Relevancy 66.22%

From earlier posts a solution was offered to this problem see below After executing these instructions I received an error also below The quot debug quot option highlighted the code line objRecipients Add Range directly into new 2007... Importing a Using Outlook Excel Outlook List Dist quot C quot amp 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 Press ALT F to open the VBA editor and then click TOOLS -- gt REFERENCES and set reference to Microsoft Outlook and then click OK Next in the VBA editor click INSERT -- gt 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 Importing Excel directly into a new Outlook Dist List Using Outlook 2007... TOOLS -- gt MACROS and then selecting the macro quot DistributionList Importing Excel directly into a new Outlook Dist List Using Outlook 2007... quot When the distribution list comes up you can manually save it Importing Excel directly into a new Outlook Dist List Using Outlook 2007... Error message There must be at least one name or distribution list in the TO CC or BCC box nbsp

A: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 . . .
 

https://forums.techguy.org/threads/importing-excel-directly-into-a-new-outlook-dist-list-using-outlook-2007.881105/
Relevancy 65.79%

Hey guys,
First time posting here.

I have Microsoft Office 2003 & 2007 installed on my laptop and using windows 10. Laptop came with 2007 but 99% of my excel use is for work and they use 2003. So rather than downgrade (seemed silly) I installed 2003 also. Everytime I open an excel file either .xls or .xlsx it opens in 2007. Does anyone know if it is possible to set 2003 as the default program for all these files. I have done the basics like settings, default programs, but when I go to file type and find .xls & .xlsx the only programs I can set for these are Microsoft Office Excel. It does not let me choose between versions.

At the moment I have to open 2003 and then the file. Not a huge problem but if possible would like to make 2003 the default.

A:Default Excel 2003 to open all files over 2007

I don't have an answer for you.
Just to remind you that Excel 2003 can NOT open xlsx files, unless you install the compatibility pack.
Only 2007 and high versions are able to open xlsx by default.

Why don't you just use the 2007.
When you are ready to save the work > Office button > Save As > at Save as type, click the pointer and select Excel 97-2003 Workbook (.xls) > Save.
That way all your office excel 2003 computers will be able to open and edit it.

http://www.tenforums.com/software-apps/53125-default-excel-2003-open-all-files-over-2007-a.html
Relevancy 65.79%

I have some code I have been using and Rotate 2007 Excel Insert Image vs. 2003 in Excel with much success I have recently pruchased a new computer with Excel in which the code no longer works I have been having some Insert and Rotate Image 2007 vs. 2003 Excel trouble finding a solution Here is the code This code selects the image Code Sub InsertPicture Dim myPicture As String If ActiveSheet Name quot Posture quot Then ChDir quot c Reports to Go Posture Pictures quot Else ChDir quot c Reports to Go X-Ray Pictures quot End If myPicture Application GetOpenFilename quot Pictures gif jpg bmp tif gif jpg bmp tif quot quot Select Picture to Import quot If myPicture quot False quot Insert and Rotate Image 2007 vs. 2003 Excel Then ActiveSheet Protect Exit Sub Else Set p ActiveSheet Pictures Insert myPicture ActiveSheet Shapes ActiveSheet Shapes Count Select End If End Sub This code crops a percentage if the image is Insert and Rotate Image 2007 vs. 2003 Excel in a vertical position Code Sub VertCrop Dim CropPoints As Byte Dim ShapeToCrop As Object Set ShapeToCrop ActiveWindow Selection ShapeRange With ShapeToCrop Duplicate ScaleHeight True origHeight Height Delete End With CropPoints origHeight ShapeToCrop PictureFormat CropLeft CropPoints ShapeToCrop PictureFormat CropRight CropPoints End Sub This code crops a percentage if the image is in a horizontal position Code Sub HorCrop Dim CropPoints As Byte Dim ShapeToCrop As Object Set ShapeToCrop ActiveWindow Selection ShapeRange With ShapeToCrop Duplicate ScaleHeight True origHeight Height Delete End With CropPoints origHeight ShapeToCrop PictureFormat CropTop CropPoints ShapeToCrop PictureFormat CropBottom CropPoints End Sub Finally this code places the image where I want it Code Sub LatPos Application ScreenUpdating False On Error GoTo errorhandler ActiveSheet Unprotect InsertPicture With Selection ShapeRange LockAspectRatio msoTrue If Selection ShapeRange Width gt Selection ShapeRange Height Then HorCrop ShapeRange Rotation Else VertCrop End If Top Range quot o quot Top Left Range quot o quot Left Height Range quot u quot Top - Range quot u quot Top Width Range quot u quot Left - Range quot o quot Left End With ActiveSheet Protect Application ScreenUpdating True Exit Sub errorhandler Exit Sub End Sub I am having problems with this in For some reason the Application ScreenUpdating code causes the image to insert first in an unselected cell and then where I specify This is not really an issue it just bothers me as it didn t do it in If I eliminate that code then it works but I see the screen updating Second and the bigger issue is that when the image is horizontal the code does not place the image in the specified cells but off to the side I am guessing this has something to do with the fact that I changed the reference point of the image when I rotated it In any case I don t know how to fix the code A couple things I am new to VBA and open to any suggestions that will not only solve my problems but improve my code as well No offense taken And most of this code I did not write but rather found and adapted to my needs Much thanks nbsp

https://forums.techguy.org/threads/insert-and-rotate-image-2007-vs-2003-excel.950648/
Relevancy 65.79%

Hello. I'm having an issue with formulas not working in Excel 2003. I've created a spreadsheet with about 1200 rows in Excel 2007. There are two tabs, one contains all the data, and the other has my working formulas. When I save, I make sure that I save with compatibility to 1997-2003. This works fine when I initially open the spreadsheet in Excel 2003, but if I filter any one column once, my formulas on a separate tab all change to #NAME?

Is there something I can do to keep this from happening?

Mario
 

Relevancy 65.79%

Let's say I have data contained in Excel with each piece of data in an adjacent cell...

Name: Rank: SSN#:
Smith, John R SSG 123-456-7890

How would I take that information and merge it into a memorandum in Office, all in separate documents?

So say the memorandum looks like this:
Whomever it may concern,

Smith, John R., SSG, United States Army, 123-456-7890 has been certified blah blah blah blah

Sincerely,
Me

So if I had 50 names it would produce 50 documents or something?

Is that even possible?

A:Merging Data From Excel Into Word (2003 Or 2007)

I think you can use Mail Merge to do this kind of thing.

I'm guessing your spreadsheet is in the .CSV format?

If you are using 2003, I'm not sure what the headings are at the top, but with 2007 you need to choose the mailings tab and then select start Mail Merge.

Select the Wizard and you should then have an option somewhere down the line to import a data source.

After doing this you should be able to insert the merge fields which should look like <<Surname>> or something like that.

From this you should then be able to create a template letter and print all the records out.

Hope this helps,
Cornzey

http://www.bleepingcomputer.com/forums/t/153904/merging-data-from-excel-into-word-2003-or-2007/
Relevancy 65.79%

Hi People!

I need help fast! I have a table as shown;

Date TC1 TC2 TC3 TC4 TC5 Min LOC Max LOC
4/12/12 9.3 9.5 9.1 8.3 9.0
4/13/12 9.5 9.9 9.3 7.3 8.0
4/14/12 9.3 8.3 7.1 9.3 9.0
4/15/12 7.3 9.0 9.7 8.3 8.0

What I need:
I need to find the location (LOC) for the occurrence of the Max & Min value in each row.

Question:
Is there a way in Excel 2003 or 2007 where I can obtain the top header title for each occurrence?
If there are multiple occurrences at the same row; can I get them too?
 

Relevancy 65.36%

Hey all! I need alittle help. I am trying to move all of my emaill addresses and saved emails from Outlook Express on one computer. To Microsoft Office Outlook 2007 on a second computer. I've never had to do this before, but I have to now. Because it's not for me. If you guys and girls can help me out with this it would be awesome. I need to get this don tomorrow. Thank you in advance.

Regards

A:Move email addresses from Outlook Express to Outlook 2007

I have Window live mail, but all these MS products work about the same.
Under file go to import export from there it should be self explanatory.
Let me know if you cant find it, Ill help.

http://www.sevenforums.com/microsoft-office/113324-move-email-addresses-outlook-express-outlook-2007-a.html
Relevancy 65.36%

Windows 7/Office 2007. I just installed Office 2007 on a brand new HP Laptop running W7 64bit. When click on a URL in an email, I get the following error message, "MICROSOFT OFFICE OUTLOOK. This operation has been canceled due to restrictions in effect on this computer. Please contact your system administrator". This also happened when clicking on an "Unsubscribe" link in a different email. Can someone please tell me how to resolve this issue? Thanks in advance.
 

A:Solved: Outlook/Office 2007 - cannot launch url in an email in Outlook

Here's the solution: http://support.microsoft.com/kb/310049#fixit4me
 

https://forums.techguy.org/threads/solved-outlook-office-2007-cannot-launch-url-in-an-email-in-outlook.969516/
Relevancy 64.93%

Hi I Sage Problem database opening 2007 (9.0) ACT have a probem opening my ACT database I used to use ACT and when I did a back-up I simply copied a numbr of files from one machine to another With this newer Sage ACT 2007 (9.0) Problem opening database database I m not sure I have done this back-up properly So I m concerned that I can t simply uninstall and re-install I m worried that my backup data isn t complete The problem is that when I try to Sage ACT 2007 (9.0) Problem opening database open the database the opening routine gets as far as reporting quot contacts loaded quot then stops someties showing any overdue alarms but not showing the main screen s The ACT logo appears in the taskbar at the bottom of the screen and on right clicking this it shows a number of databases but none of these will open I have two suspicions My virus checker reported a Trojan that it could not clean I managed to get rid of this by contacting you guys on another thread I had recently tried to set up blue tooth with my phone and had tried to get to use ACT with that phone but it never worked Nor did blue tooth with that phone for that matter Any help would be gratefully received Using Windows Professional Regards john nbsp

Relevancy 64.93%

I uninstalled Outlook 2007 (after not liking the program) and reinstalled Outlook 2003. When I start up 2003, I get an error: "Microsoft Office Outlook has encountered a problem and needs to close. We are sorry for the inconvenience."
The program will re-open in Safe Mode and functions without error.
I do not use any odd add-ins.

I have done the following to troubleshoot:
downloaded all upgrades, patches, etc.
renamed the MSMAPI32.DLL TO .old and reopend 2003.

Any ideas? Thank you.
 

https://forums.techguy.org/threads/downgrading-outlook-2007-to-outlook-2003.545746/
Relevancy 64.93%

Hello I m looking for some help 2007 2003 outlook outlook to transfer with an NK file and a very demanding boss Guess you can t help with the boss I m moving email contents Office from an XP Pro machine to Office on a bit W- I went to user Local Settings Application Data Microsoft Outlook and copied the all content of the file to a new location and saved it I used Microsoft s instructions to transfer the profile from Office to Office too I have plenty of files to choose from http support microsoft com kb Everything seemed to transfer except the auto complete no longer works I searched and found that I need to export the NK file from to I looked in the exported folder I saved on the network and could not find any file that ended in nk I looked back on the computer itself and could not find it there either Is there a different name it could be called Show hidden file and folders is enabled and I tried to use Search Nothing Also when I find it how do I import this to the new Outlook account I read something about changing the name I should mention incase this maters that the 2003 outlook transfer to outlook 2007 ISP provides Exchange to users and the rest are using POP I still have the old machine if I need to grab something off of it Please be as detailed as possible I m tired of being hollered at nbsp

https://forums.techguy.org/threads/2003-outlook-transfer-to-outlook-2007.950624/
Relevancy 64.93%

I am using Outlook 2007 in Vista Home Premium. When I got a new computer with Vista and Outlook 2007, I migrated all the Calendar appointments from the old computer with Outlook 2003 and Windows XP. The recurring appointments I migrated from Outlook 2003 are seemingly stand alone appointments in Outlook 2007, that is, they don't show that they are recurring, which means I can only delete them one by one, endlessly. Is there anything I can do to correct this?

Thanks.

Capn Zip
 

https://forums.techguy.org/threads/outlook-2007-appts-from-outlook-2003.571217/
Relevancy 64.93%

I uninstalled Outlook 2007 (after not liking the program) and reinstalled Outlook 2003 in Windows XP. When I start up 2003, I get an error: "Microsoft Office Outlook has encountered a problem and needs to close. We are sorry for the inconvenience."
The program will re-open in Safe Mode and functions without error.
I do not use any odd add-ins.

I have done the following to troubleshoot:
downloaded all upgrades, patches, etc.
renamed the MSMAPI32.DLL TO .old and reopend 2003.

Any ideas? Thank you.
 

A:Downgrading Outlook 2007 to Outlook 2003

I have recreated a new mail profile, too. Still get the same error.
 

https://forums.techguy.org/threads/downgrading-outlook-2007-to-outlook-2003.545751/