Windows Support Forum

View Outlook 2007 Appointments in Access 2007

Q: View Outlook 2007 Appointments in Access 2007

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.

Relevancy 100%
Preferred Solution: View Outlook 2007 Appointments in Access 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.)

A: View Outlook 2007 Appointments in Access 2007

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

I'm using Microsoft Outlook 2007.
When I make a "new appointment", I usually "INSERT" business cards to it (from Contacts, of course).
But when I happen to update contacts information later on (in Contacts), the change made by me in the particular contact (for example phone number) does not get reflected in the business cards in appointments. The change is only made in Contacts, but not in scheduled appointments. Which makes the whole process much more time consuming, as I prepare a lot of reccurenced appointments, so I hoped that once I've set them up I wouldn't need to check them again...

Anyone could help...??

A:Appointments in Outlook 2007

You can change the recurring appointment as a series with the new business card.

Or I suspect that you could use VBA to "refresh" all of your appointments on the click of a menu button, or maybe based after you update a contact information.
Relevancy 107.5%

Something bizarre happened on a user machine I'm looking at. They have a lot of appointments including some series and for some reason, when you go back into them, they are asking for acceptance, even though that user created them.

Tested with a couple of new appointments, and that's fine, so it's just all historical data.

Anyone got any ideas please?


A:Outlook 2007 appointments

It looks as though the meetingn organiser has changed. All existing items show the user as email address, whereas new ones show as user name. Email address is still the same, but something has obviously thrown it out.
Relevancy 104.92%

We recently made a switch from Office 2002 to Office 2007.

One of our administrative assistants made a booking in Outlook within a room calendar rather than using her personal calendar and adding the room as a resource. She now needs to change it to a different venue.

We can book it in the new venue. However, we cannot find a way to delete this event. (Compounding problem: This is also a recurring event for several weeks in a very busy room. So even though it's free, no one can book it, leading to several people thinking they have the room at the same time.)

In 2002, I would log on as the resource and delete it manually, but since the resource is set up as a room, I no longer have access.

Any thoughts from anyone?

Other relevant details: Running Office 2007 on XP with Exchange Server 2007
Relevancy 104.92%

I've got one staffer who is experiencing the following issue with Outlook 2007 calendaring.

She has a recurring appointment on Wednesday of every week. 15 minutes before the scheduled meeting, the reminder pops up. OK... this is good.

It's an hour long meeting, and 15 minutes after the end of the meeting, a reminder pops up that she is now past due to the meeting.

Then, it keeps reminding every 15 minutes and will continue to do so until the notices are ignored. It does this everyday, until the next meeting rolls around, when it starts reminding 15 minutes ahead again. Not so good.

Any thoughts as to where to start looking for the source of this oddity?


A:Outlook 2007 Keeps Reminding of Past Appointments

Have a look at this website as it could help you.

Delete reminders that keep returning
Relevancy 90.3%

Hello all:

First time poster.

In the folder/tree view on the left in Outlook 2007 (Windows XP Pro) the Contacts folder is not showing up.

In Outlook 2003, it was right there underneath Calendar, which, by the way, is also missing from the Folder/Tree view.

I can access my Contacts via the big tab at the bottom but I want the tree/folder view as it broke up the hierarachy very nicely.

Any ideas?

Thanx in advance,


A:Outlook Contacts not showing up in Tree/Folder view (Outlook 2007)

Use "Folder List" view to see all of your folders in a single list. Either click the little folder icon in the Navigation Pane on the left-hand side or click Go | Folder List in the Menu Bar.
Relevancy 90.3%

Hello all; in Outlook 2007 Calendar monthly view, it used to show the appt details on each day, but it went away and just shows the small triangles, and I cannot find how or where to restore it. The details DO show up on day and week view, but not on whole month view like before, and it was very convenient. Anyone know how to restore this feature on the monthly view? Thank you! Steve in Sac

Relevancy 90.3%

Does anyone know how to change Outlook 2007's montly view from 6 weeks to 4 weeks? I have a new netbook, and the 6 week view truncates everthing so that I cannot see all of the appointments.

Relevancy 90.3%

I like to have my VIEW for emails set to "Flag Start Date" and for some reason OL keeps changing it to "Date Conversation" Did not see anything in options for that, it will keep it for several days then change Tx

A:Outlook 2007 keeps changing the view

Perhaps something in these websites might help.

How to Reset the View on Outlook folders - Outlook Tips
Relevancy 90.3%

Hi All
I want to change the view of my Calender so that when i look at the Calender it just shows the Subject.

At the moment and i presume by default it shows Subject and Location when you go into your Calender and are in the Monthly view.

Its not impirtant just bugging me how to change
Relevancy 90.3%

Hi Everyone, I have messed up big time.

Both on My main Vista Desktop AND now my backup XP machine I have caused a booboo

For some reason I have changed the view of my outlook. Have a look at

I want it to look like

Any ideas? I have tried the usual view resets and the /cleanviews but no joy.

Any help appreciated



A:Problem with Outlook 2007 View

Click on view, reading pane. This will turn it back on.
Relevancy 89.87%

I saved the database in 2003 format to zip and send to someone and when they made changes now layout is not available any longer?? Is this due to older ver. of Access. Because even when I saved it back to 2007 format still no layout view?? any Ideas??

Relevancy 89.01%

Hey all, I have an interesting one for you. We've migrated to Office 2007 and I have a user who, in Outlook 2003, would open a shared calendar and do a search for something and it would show only those calendar items that contained the search term and it would show them on a regular calendar view with the days of the week. In Outlook 2007 it's displaying these search results in a list view format. I can't figure out how to get it to view only what was searched for in a regular week or month type of view. If I do the search and then go to View | Current View and select Day/Week/Month then I lose the search and I'm taken to the view that shows everything in the calendar. Any ideas?

Relevancy 89.01%

I have a user that accidentally drug a contact into his Inbox. The contact now does not appear in his Contacts folder, but it also does not appear in his Inbox. I'm certain the contact is indeed in his Inbox, but I cannot get Outlook to show me non-message items in the Inbox. Is this possible in Outlook 2007? Can I dive into the mailboxes via exchange (2003) and get it out?

A:Outlook 2007 Inbox 'view all items'?

When I drag a contact to the inbox it doesn't move there, instead it starts a new message with that contact in the (To) field, smae thing happens when I drag a contact to any folder (Calendar = Meeting request, Tasks = Task request... etc)

The only place where the conact went is the deleted items so maybe this is where it was dragged.

I am using outlook 07 on exchange server 07.
Relevancy 89.01%

FYI...Using Outlook 2007 with Windows XP and Windows 7 (2 computers)

When I read emails, the fonts stay (or appear) in my preferred size, about 12 pt.

When I hit REPLY, the text increases to literally 1/2 inch high or more. You can read my reply from across the room the text is so big.

I'm sure there's a simple fix, but I've yet to find it. Any suggestions on keeping the text view the same (reasonably small) when replying to an email?

Thx in advance!!


A:Outlook 2007 Changes in view of outgoing mail

With the reply window open, hold down the Ctrl key and spin the scroll wheel on your mouse. Try both directions until the text is the size you want.

Some how your rely windows has gotten zoomed up.
Relevancy 89.01%

Hi, first time user, this site's great! I have two issues:

1. My default calendar view is on the weekly setting. I'd like to see just "today's" appointments by default.

2. Each calendar line is only 5 minutes in length by default. I'd like to change the default length of each line on the calendar to 30 minutes.

A thousand times, thanks!

A:Outlook 2007 - default calendar view

When you open the calendar there are three tabs at the top (Day, Week and Month). Choose Day.

Right click someplace on the calendar then click customize current view, and then click other settings. There you can set the time scale to 30 minutes.
Relevancy 89.01%

I'm working on an Access 2007 database and any changes I make to a form or control will not save. I click the save button, and try keyboard shortcuts but when I close the form I get a prompt "Do you want to save changes to <whatever>":

If I click "Yes" the changes still do not save and I when I close the form it starts the cycle over.
If I click "No" the form closes and the changes are not saved (obviously).
Does anyone have any ideas about what's going on and how to resolve it?

A:Access 2007 Not Saving Changes in Design View

Have you checked if the file is read-only?
Relevancy 89.01%

I m working on an Access database and any changes I make to a form or control Saving Access in Changes 2007 Design View Not will not save I click the save button and try keyboard shortcuts but when I close the form I get a prompt quot Do you want to save changes to Access 2007 Not Saving Changes in Design View lt whatever gt quot If I click quot Yes quot the changes still do not save and I when I close the form it starts the cycle over If I click quot No quot the form closes and the changes are not saved obviously There is no VBA in the project but I ve still tried a decompile as suggested for older versions of Access but no luck There are quite a few embedded macros but I m not sure how they could be causing this Does anyone have an idea about what s going on and how to resolve it This issue really has this project held up and no one else seems to have encountered the issue nbsp
Relevancy 88.15%

Outlook 2007 in the computer of one of the users in my company cannot view or edit a shared calendar. When I try to open the calendar it pops-up an alert that says "You do not have permission to view this calendar"

It doesn't seem to be a rights or permission issue, because when she access using her account information in another computer, she is able to view and edit the calendars. Some of the other computers have Outlook 2007 as well, so I'm wondering if there is a setting or an extra step that I need to configure in Outlook 2007 in order to access those calendars?

A:Outlook 2007 cannot view nor edit a shared calendar.

let me explain:

there r 2 users in ur company : A and B

If A wants share his calender with B then :

1: A needs to grant access to B from his outlook calender. right click on calender- share- calender permissions. Assign the desired permissions

2. Then B needs to ' open' A's calendar in his computer by : right click on 'my calendar' - add calendar - from address book.

Good Luck.
Relevancy 88.15%

I was not looking and typing away a question in calendar search and I ended up somehow switiching the view to Day from Week. It has always been on week where I want it.

I changed the View setting to week and it seemed fine, but everytime I leave calendar and navigate to mail or contacts and work there and then come back to calendar it is back in the Day View setting............almost like it defaults to there. I have looked around and can't figure out how to lock the Calendar Week View setting like I had before. Ideas?

A:Outlook Calendar 2007 keeps going back to Day view from Week

Well, after still trying many things, I found when I changed the view from day/week/month to day/week/month with auto preview that it stayed locked on week view. Not sure why, but seems to have worked. I will monitor it a while and if it seems ok then I will mark the thread solved.
Relevancy 88.15%

I have upgraded to Office 2007 and am having a problem with the
work week view on my calendar. In Outlook 2003, my work week view displayed the days horizontally, so that I could see all of my appointments for the week/weekend at once. In 2007, the display goes across the screen vertically and my appointments are condensed so I have to roll my mouse over the appointment to see what it is. Also, my screen only shows 8am to about 2pm before I have to use my scroll bar to scroll down to see appointments after that. Basically, I'm unable to view all of my appointments on one screen like I could in 2003. Any ideas how to change the format to display closer to that in Office 2003? Thank you.
Relevancy 88.15%

I have 3 emails in my Outlook folder stack. When I open the program they are all collapsed. I thought there was a check box somewhere so they start up expanded. Did I loose that going to 2007?

Relevancy 88.15%

I have currently upgraded to Office 2007 and am having a problem with the
work week view on my calendar. In Outlook 2003, my work week view displayed
the days vertically, so that I could see all of my appointments for the
week/weekend at once. In 2007, the display goes across the screen vertically
and my appointments are condensed so I have to roll my mouse over the
appointment to see what it is. Also, my screen only shows 8am to about 2pm
before I have to use my scroll bar to scroll down to see appointments after
that. Basically, I'm unable to view all of my appointments on one screen
like I could in 2003. Any ideas how to change the format to display closer
to that in Office 2003? Thank you.
Relevancy 88.15%

Is there anyway to change what view comes up when I open a report? My reports always comes up in Report View, and I'd like them to come up in Print Preview. Access 2000 did that, as I recall.

Relevancy 87.29%

Hi all,

this is a follow up on my last thread on removing the info from showing on the print view of my report. I was able to do that using an if/else statement as OBP suggested (Thanks! ), but is it normal for the information to still show on my report view.

The code I used to remove it from the print view is as follow:

If IsNull (Me.[Employee_Email]) Then
Me.Label1.Visible = False
Me.Label1.Visible = True
End If

Do I need to add anything else to the code to remove it from the report view as well. The information needs to show only when there is something to show and stay balnk otherwise.

Thanks for the help.

Relevancy 86.43%

Have just about completed my test database in Access 2007 and am in the process of (1) securing DB tables etc to prevent corruption by users and (2) tidying up the display of data for users.

At present a form is displayed on Access startup for user input.
A Search button on the form calls a macro that executes a Search Query.
The Search Query results are output in datasheet view.
A Report is then generated based on the Search Query results.

I have a couple of questions:
(1) As a minimum, I would like to hide the datasheet view of the Search Query results from users how can this be achieved?
(2) Is there a more elegant way of getting from the input Form to the output Report or Form? I suspect the answer might be the use of the switchboard but I have only just started learning about the switchboard. Any pointers would be appreciated.


A:Access 2007 - Hiding datasheet view of Search Query results

Aussibob, it is a bit unusual for the query to display when you open a Report, so that suggests your macro is opening it first, which is unnecessary when opening a Report.
I have moved away from switchboards and use "Tabbed Mainforms" instead as there is a lot less opening and closing of Forms etc. A Switchboard only does what "Buttons" do anyway and even when I used to use them I would construct my own "Menus" using a form and buttons as it gives you much more control using VBA.
Depending on what your "Input" form does, ie if it is a Sign on form that you use the data for in the Query/Report you do not need a button to run the Report, you could use the After Update of the last entry field on the form to run the VBA instead of a button.
Relevancy 84.71%

On computer I have successfully created a customized in showing merge user-defined 2007 2007 Word not fields Outlook form with user-define fields in Outlook and a merge document in Word that works starting the merge from Outlook I want to copy the custom form with the user-define fields and the merge document to a second computer computer I saved the custom form with fields from computer to a fdm file using the Tools Options Other Advanced Options Custom Forms Manage forms On computer I used the same process to install the custom form file fdm into Outlook 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 computer Computer and computer both have Office All the problems occur on computer First when I attempted to merge starting in Outlook Word gave messages that all my user-defined fields did NOT exist in the database although I could see Outlook 2007 user-defined fields not showing in Word 2007 merge them in the Contact records Outlook 2007 user-defined fields not showing in Word 2007 merge I attempted to create a new document and the user-define fields do Outlook 2007 user-defined fields not showing in Word 2007 merge NOT show up in the Word merge field list either On computer I created from scratch a new contacts folder with a new custom form and user-define fields which works when merging Therefore the problem seems to be that Word can not see the fields I created from the fdm file I installed Can anyone please help me with this Thank you in advance Don nbsp
Relevancy 84.71%

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.
Relevancy 84.71%

I have an Excel workbook in which I keep racing records The data goes back about 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 Excel 2007 Help Workbook convert to Large Access 2007 to required sucessfully it was takin Help required to sucessfully convert Large Excel 2007 Workbook to Access 2007 g a long time to perform calcs when all the data up to rows was all on the sheet I wanted to know Help required to sucessfully convert Large Excel 2007 Workbook to Access 2007 if it was possible Help required to sucessfully convert Large Excel 2007 Workbook to Access 2007 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 quot maths quot 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 nbsp

A:Help required to sucessfully convert Large Excel 2007 Workbook to Access 2007
Relevancy 84.71%

I m trying to run an Excel macro active to Access sheet code Excel 2007 2007 VB run macro in from Access 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 object variable or with block variable not set It won t run the macro Access 2007 VB code to run Excel 2007 macro in active sheet 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 is where I get the error Code Option Compare Database Sub GetJournal Entry Data transfer to Excel 'Step 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 quot Excel Application quot Dim xlwkbk As Excel Workbook 'Dim xlworkbk As Excel Workbook Dim xlsheet As Excel Worksheet Dim i As Integer 'Step Declare your connection string MyConnect quot Provider Microsoft ACE OLEDB Persist Security Info False Data Source P FINANCE Balance Sheet Inventory Project TAN Project TAN accdb User ID Admin quot 'Step Build Your SQL Statement MySQL quot Select From mtb-TantasticJE's Where mtb-TantasticJE's Dscrptn Text 'Culls Stat 'and mtb-TantasticJE's Co Code ' ' quot 'Step Instantiate and specify your recordset Set MyRecordset New ADODB Recordset MyRecordset Open MySQL CurrentProject Connection 'Step Instantiate Excel If Excel isn't Loaded Error occurs Set xl GetObject quot Excel Application quot 'Step Open TAN JE Export xlsx Set xlwkbk xl Workbooks Open quot P FINANCE Balance Sheet Inventory Project TAN TAN JE Export xlsm quot Set xlsheet xlwkbk Worksheets quot Culls Stat quot xl Visible True xlwkbk Windows Visible True xlsheet Cells ClearContents 'Step Find First empty cell and use that to build a dynamic range With xlsheet xl Range quot A quot CopyFromRecordset MyRecordset Columns quot B B quot Select Selection Insert Shift xlToRight Range quot C quot Select Range quot C quot Select 'Cols To Insert 'Worksheets quot Culls Stat quot Range quot B quot amp Chr Asc quot B quot Cols To Insert amp quot quot EntireColumn Insert Cols To Insert Worksheets quot Culls Stat quot Range quot F quot amp Chr Asc quot F quot Cols To Insert amp quot quot EntireColumn Insert Cols To Insert Worksheets quot Culls Stat quot Range quot J quot amp Chr Asc quot J quot Cols To Insert amp quot quot EntireColumn Insert Cols To Insert Worksheets quot Culls Stat quot Range quot M quot amp Chr Asc quot M quot Cols To Insert amp quot quot EntireColumn Insert Cols To Insert Worksheets quot Culls Stat quot Range quot Q quot amp Chr Asc quot Q quot Cols To Insert amp quot quot EntireColumn Insert Cols To Insert Worksheets quot Culls Stat quot Range quot T quot amp Chr Asc quot T quot Cols To Insert amp quot quot EntireColumn Insert End With 'Step Add column heading names to the spreadsheet 'For i To MyRecordset Fields Count 'xl ActiveSheet Cells i Value MyRecordset Fields i - Name 'Next i 'Step save as text file amp Close active recorset xl Visible True xl Run quot Export Stat culls TXT File quot xlwkbk Close True COLOR red ActiveWorkbook Close ------ This is where I get the run-time error COLOR ActiveWindow WindowState xlMinimized MsgBox quot JE Has Been Exported to Excel amp Text File quot 'Step Memory Clean up Set xlsheet Nothing Set xlwkbk Nothing Set xlApp Nothing Set Db Nothing MyRecordset Close End Sub 'Step Close Excel Private Sub Workbook BeforeClose Cancel As Boolean Dim wBook As Workbook Dim LCount As Long If Cancel False Then For Each wBook In Workbooks If wBook Name lt gt Me Name And UCase wBook Name lt gt quot PERSONAL XLS quot Then LCount LCount End If Next wBook If LCount Then Excel Application Quit End If End Sub nbsp

Relevancy 84.28%

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!

A:Starting Outlook 2007 causes Microsoft Office 2007 to reconfigure itself
Relevancy 84.28%


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.

Relevancy 84.28%

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.
Relevancy 84.28%

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.
Relevancy 84.28%

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


A: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)?
Relevancy 84.28%

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 84.28%

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 ?


A: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.
Relevancy 83.42%

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 83.42%

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 at work and I recently migrated from Exchange to Exchange I like to secure my email communication as much as possible and thus like to make use of the free Digital Signature obtainable Exchange Winmail.dat Outlook 2007, and S/MIME 2007, from Comodo Now my problem is when I send an email Outlook 2007, Exchange 2007, S/MIME and Winmail.dat 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 Outlook 2007, Exchange 2007, S/MIME and Winmail.dat 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 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 James

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

Relevancy 83.42%

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.
Relevancy 83.42%

Tech Support Guy System Info Utility version OS Version Microsoft Windows Ultimate bit Processor Intel R Core TM Duo CPU T GHz x Family Model Stepping Processor Count RAM Mb Graphics Card ATI Mobility Radeon HD Series Mb Hard Drives C Total - MB Free - MB D Total - MB Free - MB Motherboard Acer Inc Chapala Not Applicable LXAQB X F 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 2007(Microsoft Outlook Enterprise 2007)) Office receive the following quot Cannot open your default email folders The file C Outlook 2007(Microsoft Office Enterprise 2007)) User Maurice AppData Local Microsoft Outlook Outlook pst is not a personal folders file quot I have tried uninstalling and re-installing Office from Outlook 2007(Microsoft Office Enterprise 2007)) the original disks a number of times I have successfully installed this on another Win 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 Outlook 2007(Microsoft Office Enterprise 2007)) or maybe it is me that isn t working Most frustrating Any word by word suggestions greatly appreciated nbsp
Relevancy 83.42%

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?

A: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.
Relevancy 83.42%

I have a access database thAT exports data to an excell file. A macro in access then opens this file and another in excell. The second excell file reads data from the first then uses a macro to format it properly and print the info. Right now I can only run this macro from the excell file. Can I run this macro (called Button2_Click in Module 3) from access? I have been using the OutputTo and RunApp action to run this macro so far.

Relevancy 82.13%

When I press Send Receive a pop up box asks me to quot Enter Network Password quot I Can't 3 2007 POP Access Outlook Account enter my BT Yahoo User Name and Password and I get the error message cannot log on to server Incorrect user name or password It is not incorrect but what Outlook is sending must be incorrect I have tried changing password deleting the account and adding it again but nothing works I have tried repairing Outlook - no good I have tried Outlook 2007 Can't Access POP 3 Account starting Outlook in Safe Mode - no good I have tried to set Outlook 2007 Can't Access POP 3 Account up a new profile pst but I am prevented because the user name and password entered as part of the process is rejected I have tried to remove as Microsoft suggest the Protected Storage System Provider entry in the Registry but it won t allow me to I have checked for malware and viruses After two days I am at my wits end Help Please Windows BT Yahoo Mail Avast Anti Virus nbsp

Relevancy 82.13%

After uninstalling google chrome i am unable to access hyperlinks in outlook 2007 in my imail.

A:cant' access links in outlook 2007

Run Windows System Restore - choose a restore point prior to removing Chrome -
START | type rstrui

Regards. . .


Relevancy 82.13%

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?


Relevancy 82.13%

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?

A: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.
Relevancy 82.13%

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!

Relevancy 82.13%

The problem is copies of each email coming into my inbox Problem started after I checked quot Leave a copy of messages on the server quot 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 - Outlook 2007 2007 Small Business worked through all the sources tech support people and the conclusion from all now is that it is an quot Outlook quot issue Outlook 2007 - Small Business 2007 The mitigating issue that visually ties it back to Outlook is that my Task view also shows copies of each task - and if I delete one all are deleted When Outlook 2007 - Small Business 2007 I view the quot Personal Folders - Outlook Today quot 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 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 Outlook 2007 - Small Business 2007 them all Is there an Outlook wizard abel to provide a fix for this nbsp

A: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.
Relevancy 81.27%

New Office 2007 installed on new Vista Ultimate 64 based system and decided to transfer settings from XP system. Unfortunately, can not get Cisco VPN running on Vista 64 system and when I try and run, Outlook, I get a:

Cannot open the Outlook window. The set of folders cannot be opend. Attemp to log on to Microsoft Exchange has failed.

Is there anyway to reset Outlook to a fresh clean start? I have re-loaded Office 2007 twice trying to clean off the old data so that I can manually set Outlook up with out it looking for Microsoft Exchange.

Any help would be appreciated.


A:Outlook 2007 will not load, cannot access folders

Couple of problems addressed:

1) once I realized that the Mail folder is in the 32 bit program folder in the Control Panel. It was easy to fix some of the links and push the Exchange email to come-up in Off-line mode. This is due to a lack of Cisco VPN service for Vista based systems.

2) Retested and investigated with IT department for either updated Cisco VPN software or ability to use Cisco's SSL VPN which we have implemented world wide. Neither work with Vista and Cisco's only response if for their customers to upgrade their systems to AnyConnect. As a global company, we will not be doing that soon so will need to use HTML version to access corporate email.

Considering the importance and size of the business community that uses Cisco VPN products and the perceived desire by MS to get Vista into that market, one would think that they would bend over to ensure their customers were serviced well by one of them not requiring a major over-haul of their VPN service!

If anyone finds a ways to work around the VPN issue, would be greatly appreciative.


Relevancy 81.27%

Hi A while ago I updated my PC from XP where I was using outlook express to windows and office To migrate the personal folders I had to move them from outlook express to outlook XP Then using windows transfer installed the folders on office outlook I now need to do a clean install of windows and outlook so I wanted to make sure the files were copied before going further In outlook I went to file-open-outlook data file double clicked outlook pst and up poped the outlook today calender So I tried selecting file-datafile manager - select personal folder outlook pst - click open folder Outlook pst is displayed as per screen shot Unable access to files. 2007.pst outlook the file is there but I am unable to open it The file is not read only and I am signed on as administrator I do not want to use windows tranfer as I have also noticed I have two sets of all folders as per screen shot Hope this makes sense Can Anyone help John Attachment Attachment

A:Unable to access outlook 2007.pst files.

Would this help?
Download: Outlook 2007/2003/2002 Add-in: Personal Folders Backup - Microsoft Download Center - Download Details
Relevancy 81.27%

My son is joining the Navy in a couple of months.

He has Outlook 2007 installed on his laptop which is his primary means of email access. When he travels, he will not be able to take his laptop with him but will need to access his emails from various overseas locations.

His current service provider offers a very poor interface (low functionality) to Webmail and so we are looking at other options but wanting to keep his existing email address.

The solution I am looking at is for him to join a web based email service eg. and set a rule in Outlook on his laptop to forward copy of all emails to the address.

Am I overlooking anything or is there anything else We need to consider? Keen to hear what others have done in such cases.

Thanks for your input.

A:Have Outlook 2007 but will need Webmail access - advice please

For that approach to work you (or someone) would need to login with his Outlook account on his laptop so the emails get forwarded.
Is that what you are planning to do?

Can you setup forwarding on the ISP Webmail page?
That way the emails would be forwarded as soon as they are delivered to the ISP server.
Relevancy 81.27%

After an upgrade of Windows Exporer 8 for Windows Vista typing in the textbody of Outlook 2007 (via web access) is extremely slow and strokes may take 10-15 seconds to be dispayed at the screen. I think its an explorer problem as it is not happening when I access Outlook in FireFox or Google Chrome. I could of course use the two others but they are missing some functionalities for working with Outlook that I like to work with (like sorting).

Is there a fix for this problem?

Thanks in advance

Relevancy 79.55%


Here's the deal: I have this nifty contacts database in Access that is significantly more useful for my current situation at work than the address books in Outlook.

It's fine if I want to look up one person and send them an e-mail through Outlook, I just click on their e-mail address and I'm all set to go with a new message.

But what about entire groups of people? I have queries that are basically acting as mailing lists and I'd like to be able to choose one of those queries and send an e-mail to that entire group.

Is there a way to do this, without exporting the contacts and importing them into Outlook? I want to only have to update the database, not constantly update Outlook as well.


A:Solved: Use E-mails from Query in Access 2007 to New Outlook Message?

look, if you take a look at Computerman's Thread here

You will see that I have posted exactly the VBA Code that you want.
Relevancy 79.55%

I often receive emails from my Pet Lover community that have images embedded in the body. I have a special email folder on my desktop into which I used to be able to download the pictures by selecting "view in browser" from my Outlook 2007 menu bar. Google Chrome would display all the images and I would download from there.

All of a sudden, when I select that command, all I get is text. It's almost as if I am looking at the source. I've uploaded a .doc file with the screen shot of what I get from that command.

Any help would be greatly appreciated. I know I could copy each and paste into Paint, then crop, save, etc., etc.. I simply don't have the time for all the extra steps.

Relevancy 79.12%

Hi everyone first post so I apologise if this topic is cover in depth somewhere else I into 2007 2007 Outlook Excel use stacks Outlook 2007 into Excel 2007 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 amp 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 nbsp

Relevancy 78.69%

I have the following code on my database This sends only record to outlook at a time I have about appointments in a form in access Is there a way to send all to outlook with one click of a button instead of going to every single record and clicking the button Any ideas Thank youuuu Private Sub cmdAddAppt Click On Error GoTo Add Err Save record first to be sure required fields are filled DoCmd RunCommand acCmdSaveRecord Exit the procedure if appointment has been added to Outlook If Me AddedToOutlook True Then MsgBox quot This appointment is already added to Microsoft Outlook quot Exit Sub Add a new appointment Else Dim objOutlook As Outlook Application Dim objAppt As Outlook AppointmentItem Dim objRecurPattern As Outlook RecurrencePattern Set objOutlook CreateObject quot Outlook Application quot to outlook access appointments. Set objAppt objOutlook CreateItem olAppointmentItem With objAppt Start Me ApptStartDate amp quot quot amp Me ApptTime Duration Me ApptLength Subject Me Appt If Not IsNull Me ApptNotes Then Body Me ApptNotes If Not IsNull Me ApptLocation access to outlook appointments. Then Location Me ApptLocation access to outlook appointments. If Me ApptReminder Then ReminderMinutesBeforeStart Me ReminderMinutes ReminderSet True End If Set objRecurPattern GetRecurrencePattern With objRecurPattern RecurrenceType olRecursWeekly Interval Once per week PatternStartDate PatternStartDate Me ApptStartDate You could get these values from new text boxes on the form PatternEndDate PatternEndDate Me ApptEndDate End With Save Close olSave End With Release the AppointmentItem object variable Set objAppt Nothing End If Release the Outlook object variable Set objOutlook Nothing Set the AddedToOutlook flag save the record display a message Me AddedToOutlook True DoCmd RunCommand acCmdSaveRecord MsgBox quot Appointment Added quot Exit Sub Add Err MsgBox quot Error quot amp Err Number amp vbCrLf amp Err Description Exit Sub End Sub nbsp

Relevancy 78.69%

I have a Gmail IMAP MS Outlook issue here that I have been trying to figure out for months Be IMAP: Denied - Item Deleted Cannot This GMail Access 2007 Outlook now Here s the issue Ever Other message I delete from Outlook that is using Gmail IMAP service show the following error message attached below quot The item cannot be deleted It was either GMail IMAP: This Item Cannot Be Deleted Access Denied - Outlook 2007 moved or already deleted or access was denied quot After doing some tweaking and research on my own I have seem to GMail IMAP: This Item Cannot Be Deleted Access Denied - Outlook 2007 locate one odd walk around with this error Whenever I disable email protection within NOD AV the error messages stop So that told me that it may be a issue within Eset NOD AV However after disabling every single scanner the email protection I am unable to figure out a solution other then using a different AV product Which I do not want to do as I prefer using NOD Has anyone else had a issue like this one and figure out a fix yet FYI I have also tweaked with GMail IMAP settings within Gmail Settings TIA nbsp

A:GMail IMAP: This Item Cannot Be Deleted Access Denied - Outlook 2007

I may have have found a solution to this problem. Testing it right now for other possible issues this may cause.
Relevancy 77.83%

My problem really lies in the fact that I d like to set up Outlook to receive my school Access Outlook Outlook & Web 2007 emails on my home laptop so that I don t have to go through the Web Access all the time because it s not quite as user friendly in Firefox as in IE I ve tried many times to try and set it up but to no avail and I m not really sure if I m doing it Outlook 2007 & Outlook Web Access wrong or if it s even possible To get to the Web Access I have to go to http server lc leics sch uk exchange and in IE I used to have to put lgscc before my username but in Firefox I don t have to I m not sure if this would make a difference at all Anyway I m pretty sure that s all you d need to know to help me but if you do need any more information I d be happy to give it Thanks in advance goodwin nbsp

A:Outlook 2007 & Outlook Web Access

you need to check with your school administrator what are the exchange settings for outlook.
if they have them then you should be able to configure it or else its not possible.
Relevancy 73.53%

When I am building a query in Access 2007, the "Sort:" and "Criteria:" selctions don't work when I switch from 'Design View' to 'Datasheet View'.
If I change the query type from 'Select' to 'Make Table' and run the query, the data in the new table mathces the "Sort:" and "Criteria:" selctions correctly.
What is wrong with my Select Query - Datasheet View? This is very annoying.

A:Access 2007 "Sort:" and "Criteria:" not working in Datasheet View
Relevancy 73.1%

I have created a phone book using Excel 2007 and would like to know how to be able to view a specific spot.All I want to be able to do is open the spreadsheet and scroll up and down. For some reason it does not by default go to my last position and I have to scroll left to see the list of names and the numbers next to the freeze frame of the list of contacts.Is there a way to have it open so that I can view my last entry or to no have to scroll left?message edited by sluytman
Relevancy 72.24%

I have created a phone book using Excel 2007 and would like to know how to be able to view a specific spot.All I want to be able to do is open the spreadsheet and scroll up and down. For some reason it does not by default go to my last position and I have to scroll left to see the list of names and the numbers next to the freeze frame of the list of contacts.Is there a way to have it open so that I can view my last entry or to no have to scroll left?message edited by sluytman
Relevancy 71.81%

I'm hearing complaints from a couple of people that their MS Word 2007 tool bars are so different they are disliking the program very much. I have tried to find a way to make those tool bars look more like the ones in Office 2003 or 2000 but no luck.

Is there a fix for this?

Relevancy 71.38%

The layout and interface in office has been consistent since practically the first version. That is until 2007 when they suddenly decided to change everything.

Is there anyway to get a more conventional interface in 2007? Because I'll just stop using it entirely and go back to 2003 if it isn't fixable. I looked through the options but I couldn't find anything.

A:Changing the view in Office 2007 to something less obnoxious
Relevancy 71.38%

I'm running Windows Vista with Office 2007.
I've encountered a problem with Powerpoint 2007. When I view files in Normal view (ie the view with minature versions of the slides down the left of the screen), the minature slides display as blank (the background colour shows, but not the content); so I end up with a list of blank slides even though the main slide view is normal and data on those slides is retained..

Any suggestions / help much appreciated
Relevancy 71.38%

In XP, and previous IE's we'd click on a link to an excel file and it would pop up within IE, so we could quickly view it. I would like this in IE9, does anyone know how to make this happen? I have not had luck searching for a solution to this in Windows 7/IE9 Thanks!

A:Can I view linked excel 2007 files in IE9?

which version of Office do you have..?
can you provide an example where this is happening..??

does this help?
Relevancy 70.52%

whenever I open a new folder, its contents is shown as Icons. I go to View, click List, and it changes to List. But next time I open the same folder, it's back to the Icon View. How can I default View to List? Or at least save List to open back with List?

Relevancy 70.52%

My nana computer do not have Microsoft Office and my mum send my nana a email containing .laccdb file ext and we need to view it without Microsoft Access. I've tried Microsoft Snapshot viewer for Microsoft Access but it dont work.

Any Recommend?


Relevancy 70.52%

I've recently upgraded to Word 2007, and am finding the new viewing options frustraing.
I often use multiple applications at once, and prefer to view files in Normal (now Draft) view as this forces the text to the left-hand side of the screen, which enabled me to view my other applications on the right.
However using Word 2007, every time the file is reopened the view reverts back to Print Layout.
Is there a setting to change which will keep the view options the same even when the file is closed and reopened?
Relevancy 69.66%

I'm using Word as a part of Office on an Acer tablet running Windows under view document 2007 Crashes Windows saving Layout Web when a with all the latest updates I mostly use Windows 2007 Crashes when saving a document under Web Layout view the tablet in portrait mode using the Hot Virtual Keyboard OSK I'm pretty happy with Windows 2007 Crashes when saving a document under Web Layout view the standard quot Print Layout quot view from a functional standpoint but I wanted to try the quot Web Layout quot view to see if this would circumvent a bug with the OSK that causes the word prediction list to disappear I'm about certain the Word problem itself is completely unrelated to the OSK Here's the issue Everything works fine when I'm using the quot Print Layout quot mode But when I switch to quot Web Layout quot and then try to save my document at any point after this including immediately after Word will crash with the following error quot Microsoft Office Word has stopped working Windows is checking for a solution to the problem quot Of course it does not find a solution I've run the Office Diagnostics and no problem has been found If I restart Word and let it do quot repairs quot to the document then I fall down a rabbit hole into further stranger problems If however I delete any quot repairs quot and just reopen the original document right back in quot Print Layout quot view everything is back to normal again I would very much like to be able to use the quot Web Layout quot view but of course right now I can't I don't even know where to begin in terms of trouble-shooting this issue so any help would really be appreciated

A:Windows 2007 Crashes when saving a document under Web Layout view

Unless you plan on publishing on-line, I never found much use for the Web Layout view. Just a guess, but maybe the prediction was never made to work with the combo of the on screen keyboard and the Web view. Hopefully someone who does this can either verify yes or no for the function.
Relevancy 68.8%

Hello I have Ultimate Word on Visio new PC Crashes 2007 Win7 and reinstalls 2007 x64 been running Word 2007 Crashes and Visio 2007 reinstalls on Win7 Ultimate x64 new PC a new PC ASUS Z -WS for about four months Over of my application crashes are related to Microsoft products I am running WIN Ultimate x using Office Word crashes daily reporting software exception xe I have run hardware tests including Word diagnostics without finding errors I also run Viso Professional which attempts to reinstall itself every time I start the program I can cancel the install or lets it proceed Once started Viso works correctly Word is my biggest headache as it tends to fail just when you are saving a file for the first time If it recovers it normally looses the data entered it sometimes shows repairs related to image objects but is vague on details I have all the latest Microsoft updates BIOS updates print drivers and have disabled all Word add-ons and have replaced normal doc What would you recommend I try to resolve these concerns Thanks PS The programs worked better when I installed them on a previous PC about years ago nbsp

A:Word 2007 Crashes and Visio 2007 reinstalls on Win7 Ultimate x64 new PC

Was Windows installed fresh on the new PC?
Relevancy 68.8%

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.
Relevancy 68.37%


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.


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


Relevancy 67.94%

I ran the newest Vundo Fix Combo Fix and SuperAntiSpyware on this system and things seem fine I need a second opinion on this HijackThis 2007. WinAntiSpyware Vundo, Solved: WinAntiVirus 2007, log please ComboFix Log in next post HJT Logfile of Trend Micro HijackThis v BETA Scan saved at PM on Platform Windows XP SP WinNT Boot mode Normal Running processes C WINDOWS System smss exe C WINDOWS system winlogon exe C WINDOWS system services exe C WINDOWS system lsass exe C WINDOWS system svchost exe C WINDOWS System svchost exe C WINDOWS system spoolsv exe C WINDOWS Explorer EXE C PROGRA COMMON AOL ACS AOLacsd exe C Program Files Yahoo Antivirus ISafe exe C Program Files Common Files Microsoft Shared VS Debug mdm exe C Solved: Vundo, WinAntiSpyware 2007, WinAntiVirus 2007. WINDOWS system svchost exe C WINDOWS stsystra exe C Program Files Yahoo Antivirus CAVTray exe C Program Files Yahoo Antivirus CAVRID exe C Program Files DIGStream digstream exe C Program Files ESPNRunTime DIGServices exe C Program Files iTunes iTunesHelper exe C Program Files Yahoo Antivirus VetMsg exe C WINDOWS system ctfmon exe C Program Files Microsoft ActiveSync WCESCOMM EXE C Garmin gStart exe C Program Files The Weather Channel FW Desktop Weather DesktopWeather exe C Program Files DellSupport DSAgnt exe C Program Files SUPERAntiSpyware SUPERAntiSpyware exe C Program Files Canon CAL CALMAIN exe C Program Files Google GoogleToolbarNotifier GoogleToolbarNotifier exe C Program Files MotionBased Agent MBAgent exe C Program Files iPod bin iPodService exe C Program Files Microsoft ActiveSync WCESMgr exe C WINDOWS System svchost exe C Program Files HP Digital Imaging bin hpqimzone exe C Program Files Microsoft Office Office OUTLOOK EXE C WINDOWS system wuauclt exe C Program Files LogMeIn x LogMeIn exe C Program Files LogMeIn x RaMaint exe C Program Files LogMeIn x LogMeInSystray exe C Program Files Yahoo YOP yop exe C PROGRA Yahoo browser ycommon exe C Program Files LogMeIn x LogMeIn exe C Documents and Settings Beth Desktop Ken HiJackThis v July exe C WINDOWS system NOTEPAD EXE R - HKCU Software Microsoft Internet Explorer Main Start Page https login yahoo com config login verify partner sbc amp done http sbc yahoo com R - HKLM Software Microsoft Internet Explorer Main Default Page URL http go microsoft com fwlink LinkId R - HKLM Software Microsoft Internet Explorer Main Default Search URL http go microsoft com fwlink LinkId R - HKLM Software Microsoft Internet Explorer Main Search Page http go microsoft com fwlink LinkId R - HKLM Software Microsoft Internet Explorer Main Start Page http go microsoft com fwlink LinkId R - URLSearchHook Yahoo Toolbar - EF BD -C FB- D - F- D F - C Program Files Yahoo Companion Installs cpn yt dll O - BHO Yahoo Toolbar Helper - D -C F - EFB- B - ECA - C Program Files Yahoo Companion Installs cpn yt dll O - BHO AcroIEHlprObj Class - E F-C D - D -B D- B D BE B - C Program Files Adobe Acrobat Reader ActiveX AcroIEHelper dll O - BHO no name - - F - D - - D F - C PROGRA SPYBOT SDHelper dll O - BHO DriveLetterAccess - CA D E- - CF- E - - C WINDOWS system dla tfswshx dll O - BHO no name - F - - CF- F - BEC A D C - O - BHO Google Toolbar Helper - AA ED - DD- d - -CF F - c program files google googletoolbar dll O - BHO Google Toolbar Notifier BHO - AF DE - D - -B FA-CE B AD D - C Program Files Google GoogleToolbarNotifier swg dll O - Toolbar amp ESPN - AE F -AF - C C-B E- DFC FF C C - C Program Files ESPN Toolbar DIGToolBar dll O - Toolbar Yahoo Toolbar - EF BD -C FB- D - F- D F - C Program Files Yahoo Companion Installs cpn yt dll O - Toolbar amp Google - C B - - d - B - A CD F - c program files google googletoolbar dll O - HKLM Run SigmatelSysTrayApp stsystra exe O - HKLM Run CaAvTray quot C Program Files Yahoo Antivirus CAVTray exe quot O - HKLM Run CAVRID quot C Program Files Yahoo Antivirus CAVRID exe quot O - HKLM Run DIGStream C Program Files DIGStream digstream exe O - HKLM Run DIGServices C Program Files ESPNRunTime DIGServices exe b... Read more

Relevancy 67.94%

Hello everyone,

I am printing letters on scrapbook paper which i will then cut out to make a banner. In order to do that correctly, the text needs to be a mirror image.

I cannot figure out how to do a mirror image of my text (within a text box) in Word or Publisher.

The flip horizontally button is available, but when i click it, nothing happens. Only the flip vertically button works, which is of no use to me.

I used the snipping tool which turned the text into an image. It worked but the sizes are off.

Please help.

I have a HP F4435 printer. The manual says there is a mirror image on button...which i dont have.

Please help!

Thank you!

A:Mirror Image in Word 2007 or Publisher 2007

Have tried using the Word Art I think that you can rotate and flip.
P. Glynn
Relevancy 67.51%

Hello,I have been serarching all day for some help! I have a new laptop with Vista. I downloaded a trial version on Office 2007 Standard. I ended up buying Professional. I uninstalled the Standard version, but Professional will still not allow me to install Outlook. I went through the registry and deleted everything I could find with outlooks name on it.... and I still can not get Outlook to download. Can anyone help??THANK YOU SO MUCH!MelissaMod Edit: Topic moved to more appropriate forum~ TMacK

A:Office 2007 Professional Won't Install Outlook- No Current Outlook Installed this quote"You will also need to uninstall Business Contact Manager from the Office suite as well, then rerun setup and make Outlook available."
Relevancy 67.51%

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 . . .
Relevancy 67.51%

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.
Relevancy 67.51%

I have been serarching all day for some help! I have a new laptop with Vista. I downloaded a trial version on Office 2007 Standard. I ended up buying Professional. I uninstalled the Standard version, but Professional will still not allow me to install Outlook. I went through the registry and deleted everything I could find with outlooks name on it.... and I still can not get Outlook to download. Can anyone help??


A:Office 2007 Professional Won't Install Outlook- No Current Outlook Installed

I did not think that they still had outlook i thought they replaced it with Windows Mail
Relevancy 67.51%

Hi I ve developed a database in Access and am using the Navigation Form for users to access the different forms and it s working very well The problem is we still have some workers who are on Windows & Switchboard 2010 Solved: 2007 Navigation Access Access Form XP boxes with Office and the Navigation Form won t work for them I ve Solved: Access 2007 Switchboard & Access 2010 Navigation Form been asked to develop an Access Switchboard which will mimic the Navigation form so there is some continuity between them and so that once all the systems have been upgraded the users willbe familiar with the interface I easily designed a form with the look or the Navigation Form but haven t been able to figure out how to handle opening the different subforms on the one main form Is it Solved: Access 2007 Switchboard & Access 2010 Navigation Form possible to place an Unbound Frame on the form and with a click of a button open a subform in the Frame or have a button just open a subform How would that be coded Thanks for your assistance nbsp

A:Solved: Access 2007 Switchboard & Access 2010 Navigation Form

I am a bit confused because Subforms normally open when a mainform opens.
I am not familiar with the Access 2010 navigation form so I am not sure what you are trying to do.
Relevancy 67.51%

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??



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.

Relevancy 67.51%

So far my searching has turned up confusing and non definitive info. In a nutshell... is it possible to seamlessly transfer ALL data? I've been able to import messages and account info into Outlook 2007/Win7 but can find no way of kluging either rules (rwz) or address (wab) info.

Also, if I understand correctly Outlook 2007 doesn't internally store addresses and Windows 7 no longer retains an address book core app for Outlook to draw from? I'm hoping this doesn't mean Windows Live Mail requires activation?

Any info appreciated!

A:Transfer data from Outlook 2000/XP to Outlook 2007/Win7

Outlook 2007 can still import your address book that you exported from your office 2k install.
Relevancy 67.51%

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?


Relevancy 67.51%

I am trying to Copy Outlook Express data from a XP computer to Outlook 2007 on windows 7
contacts and emails years of them in folders

the microsoft help says run outlook express on the outlook computer

its windows 7 and not available as far as i can see

help appreciated please

A:Help! Copy Outlook Express data to Outlook 2007 on windows 7

Hello rogerk, welcome to Seven forums.

Sorry no one has replied before, but I hope this might help:
How to upgrade from Outlook Express to Outlook

more information and guidance here:
How to import addresses from Outlook Express to Outlook
Relevancy 67.51%

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
Relevancy 67.51%

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.51%

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:
Relevancy 67.51%

Yesterday I purchaed Microsoft for small business, the main reason I bought it was for Outlook 2007 with business contact manager. I have vista with 64bit and was told it would install with no problem.The first cd which included Outlook 2007 downloaded without a problem. Then I tried installing the 2nd cd and it will not work no matter what I try. It says failed to install Business Contact Manager for Outlook 2007. I then installed both cd's on my desktop which is also vista 64bit and there wasn't any problem. I am so frustrated! Any ideas?
Relevancy 67.51%


See attachment for exact error. Just started this evening although have been using outlook earlier in the day.

I have run through everything here that is applicable for pop mail.

Additionally I haveRun a repair of office 2007
Tried the noextensions switch
Tried running Outlook in compatability mode
Using a back up of my pst file
Recreating bak file

But still no joy. I have looked a half dozen other links most of which suggest some of the fixes on the link above.

Still getting this error. Only updates that have installed today is windows defender signatures. ESET smart security licence also renewed.

Can anyone help please?

A:Outlook 2007 - Cannot start, open outlook window, set of folders...

Have you tried it with the /resetnavpane switch?

More information on command line options for outlook:
Relevancy 67.51%

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


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?
Relevancy 67.51%

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?