Computer Support Forum

how to import csv from excel 2007 to outlook 2007

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

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

Relevance 100%
Preferred Solution: how to import csv from excel 2007 to outlook 2007

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

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

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

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

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

3 more replies
Relevance 78.3%

Hello Helpful Folks,

I have searched with no luck for a solution to my problem. Here's the rundown:
Running Windows XP
Using Outlook 2007, Excel 2007

I want to take a database in Excel and import it into Outlook. Not sure if my screenshot is attached, but I do not have an option to "Import/Export" under File. Any other way around this?? Thanks for the help.

Answer:Solved: Cannot Import Addresses from Excel to Outlook 2007

6 more replies
Relevance 100.45%

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

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

Hi hbsurfer

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

Let us know if that works for you or not.

1 more replies
Relevance 100.04%


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.


More replies
Relevance 99.22%

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

I'm Using Excel 2007 and Outlook 2007.

Answer:Opening 2007 Excel documents in Outlook 2007

12 more replies
Relevance 97.17%

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

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


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

11 more replies
Relevance 97.17%

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


Answer:Solved: Excel 2007 to Outlook 2007

16 more replies
Relevance 93.89%

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

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

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

For example...

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

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

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

Thanks in advance!

Answer:Outlook 2007 into Excel 2007

8 more replies
Relevance 93.48%

In search of solution that can help me import the mails to Ms Outlook 2007 from the Ms Entourage 2008 Mac.
As the number of mails is huge so I resisted the use of Imap account.

I need a solution that can transfer around 5500 mails at once from entourage to outlook.

Please help.

Thank you

Answer:Ms Outlook 2007 Import

I moved your thread from Windows 8, as I think you are more likely to get advice on this in the Web & Email forum.

3 more replies
Relevance 93.48%

When I try to import an Excel 2007 file into Outlook 2007, my only import options are for Excel 97-2003.

Why doesn't Outlook 2007 support Excel 2007 file extensions? The workaround (saving a 2007 spreadsheet as a 2003 file) seems like a step backwards somehow.

Answer:Outlook 2007 Import.....won't

Any thoughts?

2 more replies
Relevance 92.66%

Just installed Windows 7 And I'm looking around for an answer on how to import my emails and address book.I was on XP and Made the Backup of my Address Contact File and also the Outlook Express Folder.Can you help?ThanksRob

Answer:Import Emails to Outlook 2007

click here

10 more replies
Relevance 92.66%

I had trouble with Outlook 2007. Exported the folders and subfolders to a mass storage device.Formatted my PC because I wanted to clean it up. Reloaded all the software and inported the .pst file that was exported. Outlook is displaying some of the folders, but none of the content. Can anybody assist please?

Answer:Outlook 2007 import trouble

Sounds like not all the data copied. Did you open the pst file from the external device before you formatted the PC?

3 more replies
Relevance 92.66%

Can I copy a .pst from outlook 2000 into outlook2007?

Answer:Can you import .pst from outlook 2000 to 2007

You don't need to copy or import it. Just open it. File, Open, Outlook Data File, and browse to the location of the file.

2 more replies
Relevance 92.66%

Everytime I try to import this file in to outlook, it does not prompt me for the file, its as if it looks for it on its own, needless to say, it cannot . I never had Outlook Express on this computer so what directory do I create to throw this dbx file in to so outlook may find it and import?

"No internet accounts could be found"
"Would you like to import email messages and addresses from Microsoft Outlook Express or Windows Mail?" *yes*

It finds one email, welcome to windows mail. with todays date on it.

Answer:Cannot import .dbx file to Outlook 2007

Go to this link and click "When Outlook and Outlook Express are installed on different computers"

(you will need to copy All the dbx files from the OE store folder.)


3 more replies
Relevance 92.25%


I have a ton of messages under my XP Outlook Express account.

Bought a new PC with Windows Vista Home Premium and NEED TO import my messages from the XP machine to the new Machine.

I pulled the XP drive out and make it an external HD and have it plugged to the Vista PC.

Have tried the easy transfer wizard but I don't see an option to read from my USB drive or to just import the email settings / messages

I also tried copying the DBX files from the XP account and to import them using the Vista Windows Mail, but when I click browse, I cannot see any DBX files or anything for that matter.

Can someone help me please!


Answer:Outlook express6 to Windows Mail or Outlook 2007 How do I import my messages? Please

Hopefully this will help:

1 more replies
Relevance 91.84%

Dear All,
Is there any way that i can import Outlook Express Emails (.dbx) in MS Outlook 2007 directly, rather than through Windows Mail.

Answer:Solved: Import Outlook Ex[ress Emails in MS Outlook 2007


3 more replies
Relevance 91.84%

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!

Answer:Cannot import Outlook Beta 2007 pst files to Outlook 2003

7 more replies
Relevance 91.43%

How is this exactly done???I've followed this link: click hereBut it doesn't work, I have saved the Outlook Express Folder from XP which has the .dbx files any help would be grateful.Thanks AgainRob

Answer:Import Out Look Express messages into Outlook 2007

See Here:click here

9 more replies
Relevance 91.43%


I have just created a new Profile in Outlook as the previous one developed a corrupt folder.

How do I import/export my files without losing the attachments. I initially did it as export to windows.csv but the import couldn't read it. I then did it as dos.csv and the same thing. I then did it as excel.xls and it imported, but had lost the attachments and in some cases the body of the email.

Is there something I am doing wrong?


Answer:Solved: Outlook 2007 import\export

Outlook stores everything in a file with .pst as the extension. Search on your PC for this pst file and try to open it while logged in with the new profile.


2 more replies
Relevance 91.43%

I want to import emails including time, date, email address to access, but the problem is that access can't recognise my outlook folder. I'm currently using outlook 2007 and access 2010. Is it because I'm using different version of outlook and access? Please help......

Answer:how to import outlook 2007 to access 2010?

What steps are you following to import the external data?

2 more replies
Relevance 91.43%


I have Windows 7... I imported my .pst file from another computer to my new computer and it was OK.

Now, Outlook 2007 does not see it.... i have the file backup.... would I open the file to find it or import it again.

If so how?

Thanks for this service


Answer:Outlook 2007 PST file how to open or import?

12 more replies
Relevance 91.43%

^ as the titles says

Answer:how to import outlook 2007 emails to Gmail?

I've not tried but I would of thought it would just be as easy as set your gmail up as imap in your outlook client and then just move the emails over between the folders.

3 more replies
Relevance 91.43%

I have imported E'mails into Outlook 2007 from Outlook Express. Most have been imported ok but some are missing. Could be date sensitive.

More replies
Relevance 91.02%

I am so confused about where outlook 2013 keeps things.

I have installed Outlook 2013 and would like to import my contacts from my outlook 2007 in another computer. I have already prepared the contacts.pst file from outlook 2007 and made it available in my public folders. I then imported the .pst file into Outlook 2013 via network. However the contacts shows up as a separate contact list rather than integrated into the outlook 2013 address book . How to correct it?

I must have got the process wrong.


Answer:outlook 2013 import contacts from outlook 2007

OK. I found the imported contacts in a separate list inside the address book. There are 2 lists one is "In This computer" the other is just "contacts" . How do I make the "contacts "list as the default so I get an address book when I click on 'To" ?

1 more replies
Relevance 90.61%

I had Outlook 2003 for years and my computer died. The refurbished computer I bought has Outlook 2007 pre-installed. I have all my old data including Outlook pst backed up on Carbonite and just did a restore. I want to import all my old emails and contacts. From what I have gathered, I can import the info (pst file?) into Outlook. Is is possible that I could mess up outlook if I don't do it exactly right?

Answer:outlook 2007 import data from 2003 version?

You can use Import/Export Function in Outlook to import all your old emails and contacts. Yes importing function can mess up the already existed data if an orphan PST file possesses some of duplicate items. To deal with it, deploy the filter available in the Outlook import function like Remove duplicate entries, etc. Its just about how and what data you are going to move.
For more information click here:
Thanks & Regards
Clark Kent

1 more replies
Relevance 90.61%

Somewhere in the update/install process of Windows 10 (and re-installing Outlook 2007), I lost my contacts in my Outlook account. The contacts remain in my iCloud account and on my iPhone. Can some please instruct me on how to import all the contacts back in to my desktop Outlook 2007 application?

More replies
Relevance 90.61%

Hi, everyone!

I'm importing my Outlook files to a new laptop and have my .pst files transferred. My question is, did this also transfer my Rules that I created on the old laptop, and did that transfer the email addresses that I had added to my Junk / Block list?

If not, can you tell me in laymen's terms how to accomplish that? In my job as an internet researcher and marketer, I get a TON of junk and would hate for these to start pouring into my inbox after spending countless accumulated hours clicking "Actions - Junk Mail - Add Sender to Blocked List"!!

Thanks so much!

More replies
Relevance 90.61%

I need to move my email address book from my outlook 2007 email on my old windows 7 computer to my Outlook 2007 email in my new computer with Windows 10.  I have exported the files that I want to a usb thumb drive.  What now?  I need these addresses installed as soon as I can.  Thanks in advance for any help you can give me.  Please bear in mind that I am not the most computer literate person.   

Answer:Export & Import Outlook 2007 Address book


1 more replies
Relevance 90.61%


My hard drive has been wiped out. Before I try a recovery of all my files, I had a new hard drive installed, and installed by backup through Norton. However I didn't have a backup of all my emails. I can access all 4 accounts through ( that's about 60 000 emails), but is there anyway I can import them into outlook 2007? I am using a pop/smtp type account.


Answer:Solved: Import old email from google to Outlook 2007

On Google mail under settings forearding POP/imap

Enable POP for all mail (even mail that's already been downloaded)

se if that then downloads all the email again

2 more replies
Relevance 90.61%

Somewhere in the update/install process of Windows 10 (and re-installing Outlook 2007), I lost my contacts in my Outlook account. The contacts remain in my iCloud account and on my iPhone. Can someone please instruct me on how to import all the contacts back in to my desktop Outlook 2007 application?

More replies
Relevance 90.61%

Hi, I have exported a list of empty folders from Lotus Notes and saved them in Excel. It's a simple list with the names of the folders (e.g., USCS\2. Cross-Sector Services\CMR\j2G). I want to use the same folders in Outlook 2007. I am VBA-illiterate but it seems a VBA macro would be the best way to import the folders and tell Outlook 2007 to put them under the Inbox = Inbox\USCS\2. Cross-Sector Services\CMR\j2G. I have attached a file with 10 sample folders. Any help would be appreciated! Best, M

More replies
Relevance 90.61%

First of all, I don't have Business Contact Manager installed in either computer. I am moving my Outlook 2007 Contacts from XP to Vista in the new computer. I used to know how to move my address book in Outlook Express, but I'm strictly a novice with Outlook. Please, can anyone help me?

Answer:Solved: Import/Export Outlook 2007 Contacts

7 more replies
Relevance 90.61%

Anyone have any ideas on this?

Googleing this didn't get me too many results. What with all of everyone saying how much integration there is between Onenote and other MS Apps., I haven't found a solution to this one.

Any help would be appreciated.


Ron V.

More replies
Relevance 90.61%

Can anyone tell me the steps to import an office data file, which contains the various email addresses my coworker frequently emails, into Outlook 2007?


Answer:Import Office Data File into Outlook 2007

6 more replies
Relevance 89.79%

Hi all.My question is, can I import all my email folders from Live Mail to Outlook 2007?I have been toying with this move for some time now, but to do this I need to move some 20 od folders.Is this possible "Thinking hurts my head that's why I live in West Australia"

Answer:Can I import email folders from Live Mail into Outlook 2007

import windows live mail into outlook 2007 windows live mail into outlook 2007

15 more replies
Relevance 89.79%

I moving from Windows Mail to Outlook 2007 and need to find out how to Import all the Folders (old Windows Mail Emails).

I'm not certain what format Windows Mail is in....

Can someone point me in the right direction ?


Answer:Solved: How to Import Windows Mail Folders to Outlook 2007 ??

See if this is of any help:

3 more replies
Relevance 88.56%


I am having trouble trying to find the best way to do this.

On one laptop I am using Outlook 2007 on Windows XP Professional and need to get the emails and contacts from here to my new laptop which is Windows 7 Home Premium 64 bit, which uses Windows Live Mail.

What would be the best way to do this?

Thanks very much


Answer:How do I import/export emails from Outlook 2007 to Windows Live Mail?

Hi sophi, welcome to 7F!

Have you already tried, what did you run into?

Found this link that offers two solutions:

9 more replies
Relevance 85.69%

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

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

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

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

More replies
Relevance 85.28%

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

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

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

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

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

13 more replies
Relevance 85.28%

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

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

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

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

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

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

7 more replies
Relevance 85.28%

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

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

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

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

More replies
Relevance 84.87%


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

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

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

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


Answer:Paste link from Excel 2007 to Word 2007 table

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



2 more replies
Relevance 84.87%

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

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

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

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

What could be going wrong?

Thanks in advance.

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

16 more replies
Relevance 84.87%

I have Office 2007 on Windows 7.

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

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

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

Any ideas?

Thanks for your time on this


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

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

1 more replies
Relevance 84.05%


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

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

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

"Opening this document will run the following SQL command"

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

"Error has occured: Catastrophic failure:"

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

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

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

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

"Error has occured: Catastrophic failure:"

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

More replies
Relevance 83.64%

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

Answer:Outlook 2007 to Excel

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

4 more replies
Relevance 83.64%

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

Answer:Excel & Outlook 2007

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

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

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

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

3 more replies
Relevance 83.64%

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

Your suggestions for a fix would be greatly appreciated.


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


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


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

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

1 more replies
Relevance 82.82%

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

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

If you choose the option to preview that works.

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

Please help!!!!

More replies
Relevance 82.82%

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

Answer:Outlook 2007 without Word and Excel

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

4 more replies
Relevance 82.82%

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

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

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

More replies
Relevance 82.41%

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

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

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

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

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


More replies
Relevance 82.41%

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

Answer:Word 2007/Excel 2007 integration

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

1 more replies
Relevance 82.41%

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

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

Answer:Excel 2007 (MS Office 2007 enterprise)

Hi there.

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

7 more replies
Relevance 82%

Outlook 2007 mail search is incomplete when Visio 2007 Pro is installed.

Already uninstalled and reinstalled Office 2007 Pro SP2, Project 2007 Standard and Visio 2007 Pro.
Rebuild indexing and again uninstalled Visio 2007 Pro. Mail Search working as long as Visio not installed.

Windows XP SP3
Windows Search 4.0
Internet Explorer 8

Any suggestions as to why.

More replies
Relevance 82%

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

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

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

3 more replies
Relevance 82%

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

More replies
Relevance 82%

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

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

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

8 more replies
Relevance 82%

I have created a spreadsheet which is automatically updated from Access Databases.
I issue it as a report on a dailiy basis.

I have added conditional formatting to the spreadsheet. I have used the traffic light system and green is good, red is bad etc.

Everything works perfectly until I email the spreadsheet as the message body using Microsoft Outlook 2007. All the traffic light symbols disappear from the email. I have tried cut and paste and that still does not work. Everything else appears as normal.

Can anybody give me a pointer on how I can resolve this. I dont want to using any snapshot software.

Thanks in advance

Answer:Excel 2007 Conditional Formating and Outlook

sorry I realise I posted in incorrect forum - I have tried to delete or move with no success!

Sorry again

6 more replies
Relevance 82%

I have a user, and it happens to me too, when we preview an attachment that is an Excel file, it launches a separate Excel window, then places the spreadsheet back into the email preview area, but still leaves up a blank Excel window.

What I have noticed is that in processes, it is launching a separate instance of excel.exe. However, if we preview other Office attachments, I do not see their processes at all. i.e. Winword.exe, PPT.exe, etc.

I cannot find anything on the net to explain why this is happening only with Excel. Help!

Answer:Outlook 2007 preview problems with Excel.


I Have the same happen to me as I get alot of Excel attachemnts in work, I've put it down to when you open the attachment from within Outlook your opening the viewer but also the main app opens too, to be able to show the file, when the viewer file is closed the main app is not, I tend these days to right click save as any attachment, saves the extra few clicks of the mouse.

Have no idea why but when closed Excel stays open, actually happens to me in Word too as while the viewer file is closed the same file is open in main Word app.

This user on a corporate network using Exchange Server at all? but also happens to me at home and I'm not on Exchange Server.

3 more replies
Relevance 82%

Can anyone please tell me where I can get a simple set of instructions on how to export several colums of contacts in Excel 2007 into outlook 2007. Thanks Tim

Answer:Solved: Exporting from Excel 2007 to Outlook

16 more replies
Relevance 82%

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.


Answer:Help! I can't mailmerge from Excel 2003 to Outlook 2007

11 more replies
Relevance 82%

Hi there,

I just installed a new PC for one of our users, including Office 2007. She works in HR, and the format that they use for subject lines contains a lot of information, at times. She reported that since upgrading, she sometimes cannot open Excel documents from attachments in her email. We were able to get around this by saving them to a folder on her desktop...where she could then open them. However, to simply OPEN the documents does not work. By going to the temporary folder where Outlook opens these documents, I could not open them from there either--UNTIL i shortened the name to "test.xls" At that point, I figured out that MS must have included some restriction on long file names, but what didn't stand to reason was why they could be opened in other locations...just not directly through the temp folder.

Anyway, I know that the solution seems obvious, "have her save the files, then open them," but with the amount of approvals she has to process and the way they're forwarded on, it creates a good deal more overhead for her, and she's grumpy about it.

Is there any way around this?

Thanks in advance

Answer:Opening Excel docs from Outlook 2007

Try going to Excel Options, Advanced tab, and under the general heading:
Uncheck the box that says: Ignore other Applications that use Dynamic Data Exchange (DDE)
Also check the security options in Outlook - it may not want to allow opening files received from outside sources.

3 more replies
Relevance 82%

I have been tasked to keep track of follow ups for Implementation dead lines.

This is my first post here. I need your help in developing a mechanism to send an automated outlook mail, when the due date is 14 days away from being implemented/addressed. The script should preferably run automatically every time the PC is running. without the excel file necessarily open.

In the attached excel file, An email should go of to -email address (Col. J), with subject "Audit Follow Up_Audited Function (Col. A) is due on Due date(Col. I)", and body "Dear Name(Col. K), Reminder - Audit Follow up on Implementation Date"
Also, the script should put a check mark on Reminder sent column (Col. L) after the mail is sent, the script should also check if the value of the cell is blank before sending email.

I have scoured the forum for similar problems, and although I found a number of of threads,I am not proficient enough in VBA to modify them to my needs.

I'd really appreciate any help. I've attached my sample spreadsheet.


Answer:Automated Reminders excel 2007 thru Outlook

10 more replies
Relevance 82%

I recently deleted my colleague's distribution list. Fortunately I have another colleague who has the same distribution list on her PC . It is the same outlook 2007 on both PC . I followed the usual way of exporting and importing the csv file in both window and csv format . But I am still not able to get the distribution list on the deleted desktop ? What is the possible issue here ?


Answer:Importing Distribution list from Outlook 2007 to outlook 2007

The only advise I have is to give you incite into the cvs file.

It is the equivalent of a XML markup, but a file a programmer likes to deal with better. It's laid out in what is known as comma delimited formatting. That means, when the file is being read by a program, it stops at the comma's. Everything before the comma is the current entry. Everything after the comma is the next entry, and before etc. The read stops when no more commas are found, and the last entry is taken.

Comma delimited format should allow for the cross platform exchange. If it doesn't try using the XML format instead.

Hope I helped.

2 more replies
Relevance 82%

I have MS Outlook 2007 (part of Office 2007 Enterprise Edition), need Outlook 2007 with Business Contact Manager. Anyone know how to get it? I don't see an add-on upgrade option.

Answer:Have Outlook 2007, Need Outlook 2007 with Business Contact Manager

it's part of 2007 Professional, Small Business, and Ultimate. It's not licensed for use with Enterprise.

1 more replies
Relevance 81.18%

Ok so this probs isn't the ideal forum for Outlook and Exchange queries, but I know theres many skilled technical people on here, so posting on the off chance.

Anyway I run Outlook 2007 at work and I recently migrated from Exchange 2003 to Exchange 2007.
I like to secure my email communication as much as possible and thus like to make use of the free Digital Signature obtainable from Comodo.

Now my problem is when I send an email signed with my digital signature, a winmail.dat file is attached to the message. I have a few recipients that have their mail servers configured to block *.dat file attachments.

Reading resources on the web it seems the winmail.dat file is attached to RTF encoded messages.
However the winmail.dat file is attached even when sending the message in plain text when also signing the message with my digital signature.
I know I can just decide not to sign the message to problem recipients, but I never had this issue with Exchange 2003 so don't see why I should have to use this workaround.

Wake up Microsoft, not everyone in the world is running Exchange server and Outlook clients!!!

Hopefully some email expert will come across this, if not thanks for looking.


Answer:Outlook 2007, Exchange 2007, S/MIME and Winmail.dat

I have exactly same problem with Outlook 2007 without any Exchange server. Is there any solution for this?


3 more replies
Relevance 81.18%

Can anyone please help. I'm trying to look at Outlook 2007 Calendar Appointments in Access 2007.

I've seen many postings discussing adding appointments from from Access into Outlook, but I want to look the other way.

The code I've started with is

Dim olapp As Object
Dim olappt As Object
Set olapp = CreateObject("Outlook.Application")

...but that's as far I can get. I'm lost after that.

My game plan is to link our Exchange Calendars used on ipad2's to our Access database, to store Sales Rep visits against customers visited, straight from the ipad into the database.

Anyone know how? I'd be very grateful.

Answer:View Outlook 2007 Appointments in Access 2007

Exchange server is a database that can be queried by other databases. Look up Exchange OLE DB

1 more replies
Relevance 81.18%

Hi all. I have being going round in circles rying to make a mass mailing ( via email). I have a excell data sheet with company names, person names and email adresses
and I want to send out with personally adressed to emails to approx 500 people. I have been tetsing it all week and so far i can not get 1 single adressee on an email

The opnly thing which helps is copying and pasting the adresses in the BCC field which i dom not like. Any suggestions?

Answer:Making a mailing with Outlook 2007 from Excell 2007

Hello Fozzie,

I have some code which will do this with a little bit of tweaking. Can you give an idea on the layout of the information you have so I can write some code for you? Assuming you still have the issue of course.

Also there is one thing I can think of which could be an issue, when you use code to send email via Outlook there's security features which flag up the fact that Excel is trying to use Outlook to send an email and you have to click "Yes" before it sends it. This might flag up for each email the VBA tries to send when it's looping through the 500 names which may defeat the object for you.

4 more replies
Relevance 81.18%

I am running windows 7 on a new computer. Outlook 2007 is freezing many times after it is opened. I click on an e mail and it just freezes.
Word has done it also but not as bad.

More replies
Relevance 81.18%

Outlook 2007 is intermittent when viewing an individual email (I'm running Windows 7) .... Seems like the body of the email is always viewable in the preview screen... BUT when I click to open the email, sometimes the body is there but most of the time it's completely blank (ie not even any red "x")... If I close Outlook completely, then re-open; it works for a few emails then completely blank (except for to "from", "to", "subject")...

With the "blank" email open, if I then click on "other actions" then "view in browser", I can see the body in the Internet (defaulting to "Opera") Browser....
I have gone into the "Trust Center", "Automatic Download" and "clicked "off" the "Don't download pictures automatically in HTML e-mail messages")...

Any ideas???

Answer:Solved: Outlook 2007 (professional plus 2007 with Windows 7)

I kept working Outlook... got a few more descriptive errors.... found this link which solved my problem...

1 more replies
Relevance 81.18%

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

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

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

More replies
Relevance 81.18%

Tech Support Guy System Info Utility version
OS Version: Microsoft Windows 10 Home, 64 bit
Processor: AMD A6-7310 APU with AMD Radeon R4 Graphics, AMD64 Family 22 Model 48 Stepping 1
Processor Count: 4
RAM: 7113 Mb
Graphics Card: AMD Radeon(TM) R4 Graphics, 1024 Mb
Hard Drives: C: 814 GB (753 GB Free); D: 17 GB (2 GB Free); E: 97 GB (73 GB Free);
Motherboard: HP, 81F5
Antivirus: Windows Defender, Disabled

I have a form that gathers the required information from within the database

I then use this code to send the email

Private Sub Command20_Click()
'sending email
Dim mess_body As String
Dim appOutLook As Outlook.Application
Dim MailOutLook As Outlook.MailItem
Set appOutLook = CreateObject("Outlook.Application")
Set MailOutLook = appOutLook.CreateItem(olMailItem)

Set appOutLook = CreateObject("Outlook.Application")
Set MailOutLook = appOutLook.CreateItem(olMailItem)
With MailOutLook
.BodyFormat = olFormatHTML
.To = Me.Email_Address
.Subject = Me.Mess_Subject
.HTMLBody = Me.messtxt
If Left(Me.Mail_Attachment_Path, 1) <> "<" Then
.Attachments.Add (Me.Mail_Attachment_Path)
End If
'.DeleteAfterSubmit = True 'This would let Outlook send th note without storing it in your sent bin
End With
'MsgBox MailOutLook.Body
Exit Sub
MsgBox "An error was encountered." & vbCrLf & "The error message is: " & Err.Description
Resume Error_out
End Sub

Everything wor... Read more

More replies
Relevance 81.18%

Hello all,

I have a challenging job that is:

In outlook 2007;

1. I want to check every email that comes to my Inbox where there are special characters in the subject and move them to CC Folder. (and this is don by creating a rule to move the message to CC folder).
2. The email that is now in CC folder contains lets say arguments in the subject, where I would like to write those arguments in an Excel 2007 file. How can I do this? So each time when I receive a similar email it should go and open the excel file to update the fields and then close it? (I know this can be done with Micros but I don't know how) ANY IDEA GUYS!!!!!!!!!!!!
I have created a rule in outlook to check every new email where my name is in the CC filed, it should directly move the message to the CC folder. Now I need to check the subject of the email, if it contains the following string format e.x "TE, p1, ss23", it has to open TE.xls file and update a2 with p1 from the subject and ss23 in b2 filed. and next time it has to update the third row and so on.
your help guys is highly appreciated.

More replies
Relevance 80.36%

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.

More replies
Relevance 79.95%

I have a Dell Laptop running Windows XP, Office 2007, and the Email Server is Exchange 2007. When setting up Outlook for the first time Originally it would pull the incorrect email address and settings (uninstalling Bonjour fixed that) now the correct email address is being pulled but it never seems to sync. When I hit Send/Receive the Sending finishes almost instantly but receiving never finishes. Logging in as anyone on this laptop produces the same result so it's not just my login.

Side Note*(Maybe important or not) Randomly a popup will say it's trying to sync with a different server that Exchange is not on. But I haven't seen that since I deleted the Archive.pst.

This is the only computer out of 72 with this problem on our network.

Answer:Outlook 2007 & Exchange 2007 Problem!

Try deleting the mail profile and instead of Outlook finding your settings automatically configure them manually.

1 more replies
Relevance 79.95%

I used to add some of my important emails from Outlook 2007 to OneNote 2007.

Is there a way in Outlook to see which of the messages are added [exported] to OneNote 2007?

Answer:Outlook 2007 emails to OneNote 2007

If you use the Journal you should be able to see which ones are and aren't. Aside from that, unless you either flag it or mark it to a certain category, I don't believe so.

1 more replies
Relevance 79.95%

Out of the blue I can no longer see the preview of my INBOX email messages.

When I click on each message, the TO/FROM/SUBJECT headers change in the preview box but the message body still refers to the very first message I received.

I have turned the reading pane off, changed it to bottom, right and back to bottom but nothing works.

I ran the Office 2007 install CD and used the REPAIR option but still no joy.

Have Googled the earth for an answer but seems to only be me who has the issue.

Forgot to mention that even when there is a message body showing, there appears to be a lot of flickering on what contents are shown that makes me think the compatibility view has an issue maybe as I mentioned above!

Also checked my security settings and they appear (?) OK, any help appreciated!


More replies
Relevance 79.95%

I have had a few users complain about this, so maybe some one has some info.

If we have a press release in a Word document format, and we copy & paste the text into an Outlook e-mail, the formatting, in terms of size and font changes to Outlook's default. We've tried setting Outlook to RTF format, and then back to HTML format, to no avail. Is there a step or a trick I am missing, so we can copy from Word into Outlook, and maintain font and text size settings?

Answer:Word 2007 to Outlook 2007 Formatting

The default settings should maintain source formatting.

When I tried copying from Word 2007 to outlook 2007 the formatting stayed the same, but outlook doesn't have page breaks some of the text is layed out differently.

1 more replies
Relevance 79.95%

The problem is 3 copies of each email coming into my inbox.

Problem started after I checked "Leave a copy of messages on the server" when I enabled a Blackberry for email using my email home account. If I uncheck it, one email arrives but then I don't get the email on the Blackberry.

I have worked through all the sources tech support people and the conclusion from all now is that it is an "Outlook" issue.

The mitigating issue that visually ties it back to Outlook is that my Task view also shows 3 copies of each task - and if I delete one, all 3 are deleted. When I view the "Personal Folders - Outlook Today" screen when it opens on startup, there is only one copy of each task. I click onto my inbox and the screen comes up with 3 copies of each task in the sidebar.

The mutiple emails are creating big issues as many are parts of a thread and senders do not change the Header so I have to check them all .............

Is there an Outlook wizard abel to provide a fix for this?

Answer:Outlook 2007 - Small Business 2007

Unless I'm missing the point here, th eanswer seems to be to revert tthat settings change you made to leave copies on the server. You only fail to see mail on the Blackberry because you've already received them on a PC or other device so why would you wish to see it again anyway?

Any mail you haven't received will show up on the first device that connects so when you're on the hoof with your Blackberry, make sure Outlook isn't open on your home PC and you will receive your mail on the mobile device.

Anoither method might be to set up another e-mail account, put it on the Blackberry only and have all your e-mails forwarded to that account. Then you have duplicates on both devices.


3 more replies
Relevance 78.72%

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?

More replies
Relevance 78.72%

We're running the Office 2007 suite on XP Pro SP3 machines here at work. Recently I bumped up several people from 2003 to 2007 Office. One of them in particular came to me with a question.

We used centralized locked network printing, which means a teacher can print whenever they please and the printer holds it in a que until the teacher goes to the printer and punches in a 4 digit code for their account - then it gives them all of their printouts.

This is called the "locked print" feature and it's the only way we have things set up to print.

The one teacher that came to me noticed something. In Outlook 2007, if they go to File - Print, nothing shows up. The default option in the drop down box is empty. But they can select the network printer from the drop down box. However, it doesn't print. Upon further troubleshooting, if you select the printer from the drop down list and hit "properties", the printer has reverted its settings back to "normal print", which is unacceptable since our setup requires "locked print" for confidentiality reasons.

The settings on the local machine itself are locked under printers and faxes. However it's JUST in Outlook 2007 that this happens in. Word and Excel are fine.

For the time being I'm having teachers copy/paste to Word to print emails, but this really isn't a solution. Any idea on what can be done?

Answer:Outlook 2007 - Print Option Resets Printer Settings - Word/Excel Do Not.

Are you still having issues with this? We use this feature here as well, mainly for HR and works great on XPSP3, Windows 7 with Office 2007

2 more replies
Relevance 77.08%

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

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

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

2 more replies
Relevance 77.08%

is there an easy way to replicate my outlook calendar to a sharepoint calendar. I know you can drag and drop but i want to know if there is an easier way.

More replies
Relevance 77.08%

I have 10 users on Terminal server 2008 sp1 with Outlook 2010 installed.
All MS updates are installed. The Antivirus is AVG.
Only 1 user has the problem when she right clicks a message and selects "Find Related Messages"
no messages are found. All the other users work just fine and do not exhibit this problem.

More replies
Relevance 75.03%

A co-worker created a CSV file that would populate our Outlook 2007 calendar with upcoming events,days, times, reminders, all that stuff. Most of us have imported it successfully but some can't get past the point where you browse to the CSV file. Once they select the correct file on their desktop the 'Next' button is still grayed out. We have all watched each other and we are all using the same process and file to import. Any ideas?

Answer:Can't import CSV calendar into Office 2007

I would have created the calendar and exported it to a pst file. THEN use the import function.id10t

3 more replies
Relevance 75.03%

Hi all,

I am having troubles importing a fixed length ASCII text file into access 2007. Here is an example of a file I'm trying to import into a new table
Bunny Buggs 19300215
Doe John 19791205
Rubble Barney 19500914

Last name and first name fields are both 15 characters long and import fine. The date filed is 8 characters long in the CCYYMMDD format with no date delimiter. In the advanced portion of the text import I have specified Date Order of "YMD", I have four digit year checked and I have the Date Delimiter field empty. This used to work perfectly in Access 2003 and will not work in 2007.

Any assistance anybody could lend would be most appreciated!


Answer:Access 2007 Text Import

10 more replies
Relevance 74.21%

hi !

how do i import Onenote 2007 notebooks into Onenote 2010 ?

i have several notebooks, so i want to import all of them, and of course i do NOT want to open & save each of them, one at a time...

Answer:Import Onenote 2007 notebooks into 2010 ?

Are these on the same machine as Office 2010?

I'm asking because I upgraded one of my machine to Office 2010, with all the "old" OneNote 2007 notebooks there, and I didn't have to "import" anything.

I was just able to open them the same way I did with Office 2007.

However, since I don't use the default paths for files, I did have to go into the setttings panel and change the default path for backups, but other than that, I didn't need to do anything special to access my OneNote 2007 notebooks.

2 more replies
Relevance 74.21%

i have a csv file with my contacts from old outlook. how can i import all the contacts in one go into outlook 2007? i know how to do individually but have a lot of contacts
thanks for any help

Answer:import multiple contacts into outook 2007 from csv

Read this. Although for Excel it should work for any csv file. Map custom fields is fairly important.
It would have been easier to have created a pst file of your old contacts (export as pst) and then imported that.

1 more replies
Relevance 74.21%

My office recently upgraded to Office 2007. I now am having problems in importing text files. I am getting an error message, "The specification XML failed to validate against the schema. There is an error in the following line of the XL document: |." I am trying to use my saved import specifications that I created in an earlier version of Access. I regularly used these import specs and they used to work; they no longer do. I am hoping I will not have to recreate and save each of the specs. Any ideas?

More replies
Relevance 74.21%

I am unable to import some tables from one database into another. Some work, others don't. I can't see anything unusual about the ones I can't import. The same thing happens when I try a copy and paste method. I get the generic error message "Operation is not supported for this type of object".

More replies