Tech Problem Aggregator

Outlook 2010 & Excel 2010 Populate fields

Q: Outlook 2010 & Excel 2010 Populate fields

Every day I send out excel documents that I then convert to pdf's. I use the same excel template on each document. The only thing that changes in each document per recipient is the "name" "company" & "email" fields in the excel document.

Question: Is there a way I can get these documents to interface with outlook so that when I select more than one person to receive the document (as many as 30 people will receive the same document), and auto populate the contact info "name" "company" "email."

This way would save me a few steps so that I don't have to pick a contact... type all their info in the fields... send. Select my next contact... enter appropriate info in the fields... and repeat and repeat.

I'm emailing job specific information to everyone working on the same job. I'm sending it to multiple people, but need it to look like they were the only one who received the document. Just like when you get an email about the "deal of the week" that says, "Dear Mr. Johnson, How's your summer going?.... " while someone in NYC gets the same letter that says "Dear Mr. Thompson, How's your summer going.... " from the same sender. Of course the deal of the week changes each week.

How can I make this happen? If there is a better way outside using excel to create pdfs, or a totally different method entirely. I'm all ears. I just need to send the information, and it not be able to be easily modified by the recipient.

I know there has to be a more efficient way to do this.

Thank you for your help.

More replies
Answer Match 104.58%

I'm running Windows 7 Professional and just upgraded IE from 9 to 11. Afterwards, I observed that Outlook 2010 was not downloading pictures (instead showing red x's) and Excel 2010 embedded internet queries stopped working. 
I think I've cornered the problem, but can't seem to fix. I have also observed that IE's temporary internet files (TIF) folder may be missing (Internet Options>Browsing History>Settings>Temporary Internet Files shows nothing under Current Location)
and the allotted disk space is set to zero and cannot be changed. If I input another number (no matter the number), I receive the following error message:
"Please select a value between 8 and 8 for how much disk space Temporary Internet Files may use."
I have tried renaming the following RegEdit keys, but to no avail: Cache and LowCache (both under HKEY_CURRENT_USER>Software>Microsoft>Windows>Internet Settings>5.0). They get replaced when IE11 is re-opened.
The actual values within the registry keys are as follows:
Cache>Content>CacheLimit = 8192 (Decimal)
LowCache>Content>CacheLimit = 256000 (Decimal)
This is driving me crazy. Any help would be greatly appreciated. 
-David

More replies
Answer Match 104.58%

I'm running Windows 7 Professional and just upgraded IE from 9 to 11. Afterwards, I observed that Outlook 2010 was not downloading pictures (instead showing red x's) and Excel 2010 embedded internet queries stopped working. 
I think I've cornered the problem, but can't seem to fix. I have also observed that IE's temporary internet files (TIF) folder may be missing (Internet Options>Browsing History>Settings>Temporary Internet Files shows nothing under Current Location)
and the allotted disk space is set to zero and cannot be changed. If I input another number (no matter the number), I receive the following error message:
"Please select a value between 8 and 8 for how much disk space Temporary Internet Files may use."
I have tried renaming the following RegEdit keys, but to no avail: Cache and LowCache (both under HKEY_CURRENT_USER>Software>Microsoft>Windows>Internet Settings>5.0). They get replaced when IE11 is re-opened.
The actual values within the registry keys are as follows:
Cache>Content>CacheLimit = 8192 (Decimal)
LowCache>Content>CacheLimit = 256000 (Decimal)
This is driving me crazy. Any help would be greatly appreciated. 
-David

More replies
Answer Match 98.28%

Is it possible to create user defined fields in outlook and then make them sortable?
We would like to Categorize clients by
By type and office
Be able to sort by office
By Client Level
By Portfolio type
Thanks,
Jerry
 

A:User Defined Fields Outlook 2010

6 more replies
Answer Match 98.28%

Hi,
I've been searching all kinds of fora for this problem and although I find information on how to do this with (legacy) Form Fields, my problem involves Content Control fields and I can't seem to fix this.
Basically I have Sales Reports that are being filled out on a weekly basis by all Sales Reps. These contains all kinds of different Content Control fields (Drop down, rich text, dates etc...), and the data in there should be copied to an excel sheet. Meaning: copying the contents of the fields from all the different reports into 1 excel report.
Below is a Macro I found which works for legacy forms (FieldForm) (pre-2007) but I cannot seem to make it work for 2010. I pinned down the problem to being just a wording problem in MS, but then again, it might be a little more complicated

Many thanks for your help,
Code:

Dim vField As FormFields
Dim fso As Scripting.FileSystemObject
Dim fsDir As Scripting.Folder
Dim fsFile As Scripting.File
Dim wdApp As Word.Application
Dim myDoc As Word.Document
Dim vColumn As Integer
Dim vLastRow As Integer
Dim x As Integer
Sub AddFormFields()
vLastRow = ActiveSheet.UsedRange.Rows.Count + 1
vColumn = 1
Set fso = New Scripting.FileSystemObject
Set fsDir = fso.GetFolder _
("Q:\Sales Reports\Unprocessed")
Set wdApp = New Word.Application
wdApp.Visible = True
For Each fsFile In fsDir.Files
wdApp.Documents.Open (fsFile)
Set myDoc = wdApp.ActiveDocument
For Each vField In wdApp.Documents(myDoc).FormFields
vField.Select
vV... Read more

A:Exporting data from Content Control Fields in Word to Excel 2010

6 more replies
Answer Match 92.82%

Hi all,

I?m really in need of some help from some Access experts! I?m a newbie to Access, but I got myself busy with quite a big project... I?m trying to map out the product supply to shops in the whole country. I?ve come quite far for a starter, but I keep having 3 questions, it would be great if you could help me with this!

I have, amongst other tables, two tables called Stock_counted and Reported_quantity.

The table Stock_counted has the following fields:
- Shop_number
- Product_code
- Quantity_counted

The table Reported_quantity has the following fields:
- Shop_number
- Product_code
- Quantity_in
- Quantity_lost_or_returned
- Quantity_out

1. What I would like to do is to make it one table based on Shop_number AND Product_code. So in one record I would like to have Shop_number, Product_code, Quantity_in, Quantity_lost_or_returned, Quantity_out and Quantity_counted. How do I do this, making sure that the quantities end up behind the right product and shop? It is possible that some shops don?t have all items, while other shops might not have all products reported, or both. On top of that, I have another table with a price for each product, which needs to be related to it as well.

2. It happens that some products are found more than once in one specific shop and therefore appear more than once in the table, with the same shop number and product code. How do I automatically SUM these quantities, so that this product only shows up once per shop?

3.... Read more

A:How to combine fields in Access 2010 based on 2 equal fields?

  
Quote: Originally Posted by Josephine87



2. It happens that some products are found more than once in one specific shop and therefore appear more than once in the table, with the same shop number and product code. How do I automatically SUM these quantities, so that this product only shows up once per shop?



select shop, product, sum(quantityfield1), sum(quantityfield2)
from sometable
group by shop, product

1 more replies
Answer Match 90.3%

Hello VBA experts. Need your help. I have a workbook with 14 worksheets. Each worksheet has several fields all named the same. I need to sort 3 fields in each worksheet. Those are ascending in this order; Patient ID (in column A), DOS (in column E) and Code (column B).
Does anyone know of a code that can easily sort all 14 tabs at once? The range of data in each worksheet are different. Some worksheets have very little data to sort while other worksheets have maybe a 2,000 rows of data.
Any help is greatly appreciated.
 

A:Solved: Excel 2010 - Sort multiple fields in multiple sheets

Hi

Here is a macro that will sort all spreadsheets each with 3 levels of sort, all ascending assuming that the number of rows in all columns is the same.

Give this a try on a copy of your file (can't stress this enough) and let us know what it didn't do right
Code:
[SIZE=1]Sub SortSheets()[/SIZE]
[SIZE=1][/SIZE][SIZE=1]'[/SIZE]
[SIZE=1][/SIZE][SIZE=1]' Macro1 Macro[/SIZE]
[SIZE=1][/SIZE][SIZE=1]'[/SIZE]
[SIZE=1][/SIZE][SIZE=1]For i = 1 To Sheets.Count[/SIZE]
[SIZE=1][/SIZE][SIZE=1] ActiveWorkbook.Worksheets(i).Sort.SortFields.Clear[/SIZE]
[SIZE=1][/SIZE][SIZE=1] ActiveWorkbook.Worksheets(i).Sort.SortFields.Add Key:=Range("A2:A" & Range("A" & Rows.Count).End(xlUp).Row) _[/SIZE]
[SIZE=1][/SIZE][SIZE=1] , SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal[/SIZE]
[SIZE=1][/SIZE][SIZE=1] ActiveWorkbook.Worksheets(i).Sort.SortFields.Add Key:=Range("E2:E" & Range("A" & Rows.Count).End(xlUp).Row) _[/SIZE]
[SIZE=1][/SIZE][SIZE=1] , SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal[/SIZE]
[SIZE=1][/SIZE][SIZE=1] ActiveWorkbook.Worksheets(i).Sort.SortFields.Add Key:=Range("B2:B" & Range("A" & Rows.Count).End(xlUp).Row) _[/SIZE]
[SIZE=1][/SIZE][SIZE=1] , SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal[/SIZE]
[SIZE=1][/SIZE][SIZE=1] With ActiveWorkbook.Worksheets(i).Sort[/SIZE]
[SIZE=1][/SIZE][SIZE=... Read more

2 more replies
Answer Match 86.52%

Hello SF users! Okay so I am making a program that involves listboxes and ini files. What I am trying to do is populate the listbox from an ini file(make the listbox show strings from a section). I don't have any code yet so... How do I do this?

A:VB 2010 how to populate a listbox from an ini file

I've never read an entire section, but this solution looks ok:
vb.net - Read sections of INI file in VB .NET 2012 - Stack Overflow

Then where this line is, you add the info to the listbox:
' do something with the information here

6 more replies
Answer Match 86.52%

Good morning everyone,
 
So the other day something incredibly weird had occurred. I was receiving email normally on my phone, came into work, logged in, and began working on my trouble tickets. I noted that when I went back to Outlook to view an email, the email in particular was gone... and then all were gone. My folders, and emails within them, still remained the same. I attempted to research what on Earth happened but I haven't been able to find anything specific to my issue.
 
I'm using Outlook 2010 connected to an Exchange 2010 server for work. Outlook was setup as cached exchange mode but that has since been changed. The emails also disappeared from my phone's inbox too... it's as if everything was deleted and Exchange figured that's what it should be and synced everything that way. Deleting my OST didn't resolve or resync anything. I ran the scanpst tool on the ost file which reports 93 errors, but as I read the scanpst tool can't repair an OST and thus doesn't do anything.
 
Does Outlook have some sort of log that may explain what on Earth happened? I can't find any error messages or any other reasons for what may have happened. My view settings weren't changed, nothing has changed on my end. There is no spyware / malware installed on the PC as far as I can tell. No real issues in the Sync issues folder other than a Forms syncing issue which seems to be related to Exchange needing a patch (but can otherwise be ignored).
 
I will give you... Read more

A:Outlook 2010 / Exchange 2010 randomly deleted inbox email?

Are you the only person using that Exchange server who has this issue? Check with the IT department to see if they can recover the emails in your mailbox from the server. It's possible they recently did some maintenance on the mail server that caused this issue. That fact that both Outlook and your phone are having this issue points to this being an Exchange server problem, as Outlook uses autodiscover and MAPI while your phone uses ActiveSync to connect to the server.
 
Do you have access to your email using Outlook Web Access? If so, log in and see if the emails are there. If not, it's definitely a server issue.
 
If your mail is still on the server, one thing you could try is re-enabling the cached Exchange mode, saving the change, and then restarting Outlook. The last thing to try is to delete the email account profile and recreate it. Make sure to get the proper settings from IT if you don't already have them -- although since you are using Exchange and autodiscover, that's usually just a case of entering your username and password when you recreate it.

14 more replies
Answer Match 86.52%

When the meeting is opened as “this occurrence” or“Open this series”, the “Cancel” button is completely missing from the
ribbon. It shows me as the "Organizer", but only "Delete" is available.
 

More replies
Answer Match 86.1%

I had a problem with Outlook emails hanging up in the outbox and then sending as many as 14 copies of the same message. I was unable to fix this Using the "Repair" function of the upgrade installation disk (created from the downloaded file). I removed Office completely and tried to reload; however, my disk got corrupted and Outlook is no longer available. Is there a way to recover Outlook without having to purchase it separately? I am using Office Professional Plus 2010 Home Use Program. The email that came with the original download from Digital River states to go to the "Account Management Console" to reload; however, this is on a hard copy and the original email with the link is no longer available. Any help will be greatly appreciated.
 

A:Solved: Outlook 2010 missing from Office Professional Plus 2010

If you downloaded this from Digital River, then you may be able to download it again, contact them and ask.

If you can download the install file again and it works, burn yourself a CD of the downloaded install file.

Also write the keycode on the CD.
 

2 more replies
Answer Match 86.1%

Hello All

Win 7 Prof 32 bit
Office 2010

I've been trying to create a Task in Outlook from a Word Document that I have created on this computer. The idea is that a shortcut to the document is created as an Outlook Task. Click on the shortcut, and voila - there is the document.

The "Create Microsoft Office Task" icon DOES send the document to Outlook as a Shortcut in a Task, however, when I open the task, Outlook says:"Outlook blocked access to the following potentially unsafe attachments: Shortcut to 'document name'."

It's NOT an unsafe attachment; Outlook WILL OPEN this document if I send it as an email attachment. Outlook will open .docx files types.

This is a one person computer...no network, no sharing. And this problem has been driving me crazy. This would be a wonderful feature, if I can get it to work.

Anyone have any ideas what I (or Outlook) are doing wrong?

Thanks for your help
Barb

A:Creating a Task in Outlook 2010 from a Word 2010 Document

I think this will do the job for you:
Add & Create Outlook 2010 Tasks From Word 2010

.





Quote:
You can create a task from Word 2010 document and save it under Outlook 2010 tasks. This feature is by default concealed but you can make it apparent on Quick Access toolbar and use it directly.

In order to use this feature, you need to make this feature apparent on Word 2010 Quick Access Toolbar, head over to Quick Access Toolbar and from small drop down button click More Commands.

You will reach Word Options dialog. Hit drop-down button present beneath the Choose commands and select All Commands. Now scroll-down the list and find Create Microsoft Outlook Task command. Select it and click Add (>>) to show it on Quick Access toolbar pane. Once added, hit OK.

First save the document and then select any portion of the text in the document from which you want to create the task, from Quick Access toolbar, click Outlook task button.

Upon click, it will create Outlook task for the Word document and you will reach Outlook Task dialog where you can set Start and Due date for the task and add more information about it. Save & close the task to view it under Outlook tasks.

When opening task in Outlook 2010, you can also view the document from which it was created from, just double-click the document to open it.

4 more replies
Answer Match 86.1%

Hi there
This might be more related to IE8 rather than EXCEL but I find using EXCEL 2010 X-64 bit version with macros to dynamically create WEB QUERIES (retrieve external data from web sites), download into spread sheet and "Auto" update doesn't work properly.

This means some things like Stock exchange graphs on moving stocks or Horse racing statistics etc etc don't work properly.

I like trading options and need this type of functionality -- I'm NOT a professional "Day Trader" so I use my own data.

Since the web data is retrieved via some IE8 functionality I suspect it's probably becuase of the incompatability of EXCEL 2010 X-64 with IE8 (32 bit version).

No probs with Office / EXCEL 2010 32 bit version even on W7 X-64 ---I can test all these options with Virtual Machines -- you get a bit of grace before you have to "Activate" office 2010 although you have to enter the key when installing. Delaying activation allows testing both versions until extra keys are available on technet.

I NEED the Web query function to work ("Get EXTERNAL DATA") -- that is a HUGE showstopper.

I'm quite happy howeve to continue to use Office 2010 32 Bit -- the size of spreadsheets etc I use don't need the 64 bit version - but it would be nice to have 64 bit applications installed on W7 X-64.

Cheers
jimbo

A:Outlook 2010 EXCEL (64 bit) problem

I haven't tried to do this myself but I did find something in Office help you might find informative. I suspect that it may have something to do with Office Security and website trust settings.

The main benefit of connecting to external data from Microsoft Excel is that you can periodically analyze this data in Excel without repeatedly copying the data, which is an operation that can be time-consuming and error-prone. After connecting to external data, you can also automatically refresh (or update) your Excel workbooks from the original data source whenever the data source is updated with new information.
Important Connections to external data might be disabled on your computer. To connect to data when you open a workbook, you must enable data connections by using the Trust Center bar, or by putting the workbook in a trusted location.

For more information, see the articles Create, remove, or change a trusted location for your files, Add, remove, or view a trusted publisher, and View my options and settings in the Trust Center.On the Data tab, in the Get External Data group, click Existing Connections.


The Existing Connections dialog box appears.In the Show drop-down list, do one of the following:To display all connections, click All Connections. This is selected by default.
To display only the recently used list of connections, click Connections in this Workbook.

This list is created from connections that you have already defined, that you have created by using the Se... Read more

3 more replies
Answer Match 86.1%

I have been getting the following errors in Excel 2010 for about 3 months and they are getting more frequent (I have Win 7 Pro):

(1) Errors were detected while saving 'C:\Users\username\Documents\filename.xlsx'.
Microsoft Excel may be able to save the file by removing or repairing some
features. To make the repairs in a new file, click Continue. To cancel saving the
file, click Cancel.
(2) Cannot open the Clipboard.
(3) An unexpected error has occurred. AutoRecover has been disabled for this session of Excel.
(4) Excel has stopped working.
(5) Freezes on print preview.

I have done the following:
- Tried Excel in safe mode.
- Uninstalled and Reinstalled Office 2010.
- Disabled all add-ins.
- Done an exhaustive search on the internet only to find that other people have one or more of these errors, but no solutions.
- Other Office 2010 apps work ok.

Nothing has worked. I’m barely able to get anything done! Please help, I’m dying here!
 

A:Excel 2010 ProblemsI have been getting the following errors in Excel 2010 for about 3

16 more replies
Answer Match 85.26%

Hi all,

this maybe a tricky one, im not that techi so please bare with me

I am using MS office 2010

when I try to link an access database to an outlook folder using the:

home ribbon > External Data > import & Link > more > outlook Folder.

after I click on the "outlook folder" option, nothing happens.

absolutely nothing. no warning, no error, no not responding.. nothing at all.

I spent hours and hours looking for solutions, messed other parts of my computer and still no success

I need to link to my outlook contact. please help

http://www.youtube.com/watch?v=TF1RYvwpeeE this may sound silly I uploaded a video on you tube asking for help.
 

A:Access 2010 Linking to outlook folder 2010

Works like a charm on mine.
 

3 more replies
Answer Match 85.26%

Hi all
Having totally WIPED office 2010 from my system and re-installed again the problem I had with the "Purge" folder not appearing now is SOLVED.

However you still don't get a line through the deleted items -- but they are in Trash folder now.

This is BETTER but still NOT WHAT IS NEEDED -- as another computer with Outlook 2007 doesn't get the "Non purged" items in the inbox which it should do.

IMAP should effectively leave items in the Inbox until purged -- otherwise I might as well go back to POP3 - more fiddly to manage whern you leave stuff on the server but it works.

What I'm resigned to doing now is to use the REST of the office 2010 suite (EXCEL etc) which is really good but stick with Outlook 2007 for email.

Cheers
jimbo

A:Outlook 2010 Saga with IMAP, Can I use Office 2010 and

I do like the way 2010 deletes the emails without purge, but I have found that rules randomly fail and some mail goes awol for a while when switching between folders (it reappears after a while)

IMO outlook 2003 is still the best (I hated 2007) but I will reserve full judgement until 2010 is out of beta.

1 more replies
Answer Match 85.26%

Hi all,

this maybe a tricky one, im not that techi so please bare with me

I am using MS office 2010

when I try to link an access database to an outlook folder using the:

home ribbon > External Data > import & Link > more > outlook Folder.

after I click on the "outlook folder" option, nothing happens.

absolutely nothing. no warning, no error, no not responding.. nothing at all.

I spent hours and hours looking for solutions, messed other parts of my computer and still no success

I need to link to my outlook contact. please help

http://www.youtube.com/watch?v=TF1RYvwpeeE this may sound silly I uploaded a video on you tube asking for help.
 

A:Access 2010 Linking to outlook folder 2010

As a work around...Export your contacts from Outlook to csv then import (text) to Access. File > Options > Advanced...Export is midway down the page
 

1 more replies
Answer Match 85.26%

When I open excel, and go to the file tab, it hangs, and says it is trying to contact server1......which likely is my head office server, and I can't access that server...It also tries to access the server when I want to insert a picture...how do I stop these programs from trying to access the server. I am in another country and will be for quite a while this is a large Pain....
I have changed the library folders to be resident on my computer and I have also changed the default save location to be resident...
Can anyone help?

I am on Windows 7, on a Dell laptop....

A:Microsoft office 2010 excel and outlook

  
Quote: Originally Posted by moshezhang


When I open excel, and go to the file tab, it hangs, and says it is trying to contact server1......which likely is my head office server, and I can't access that server...It also tries to access the server when I want to insert a picture...how do I stop these programs from trying to access the server. I am in another country and will be for quite a while this is a large Pain....
I have changed the library folders to be resident on my computer and I have also changed the default save location to be resident...
Can anyone help?

I am on Windows 7, on a Dell laptop....


Are these files you are working on local to your machine or are they over some sort of network? If they are network files, it may be timing out trying to create temp/caches of the file you are working on as undo procedures. If it's a network file save a copy of it to somewhere local on your computer and try editing it.

3 more replies
Answer Match 85.26%

I want to export all my contacts in Outlook 2010 to Excel. Suggestions?

Why: I am fairly sure my outlook file is corrupt. I cannot see my contacts in category view as I did when I had the same program in WinXP (I upgraded to Win7.) After 8 months, the first category appeared in the Current View box, but no others. I can see the categories in list view. I thought I would find some errors when I export them to a file I can edit.

Alternatively, is there any way to view the main Outlook file, (.pst?) in an external editor?

A:How to export Outlook 2010 contacts to Excel?

Sorry folks, found the export under "open."

2 more replies
Answer Match 85.26%

My Outlook 2010 on a Windows 8.1 machine will not launch an excel attachment correctly. It just loads excel, no document at all.

I can save the document and view it, and I can see the mini-preview in outlook itself. But if I double click on the attachment, it just loads excel with no document.

I'v checked the trust center settings and they all appear to be in-line.

Please advise and thanks for your time in advance,

A:Outlook 2010 - Excel attachment issue

anyone?

1 more replies
Answer Match 84.42%

odd but very annoying problem that is affecting some Windows7 computers with the same internal configurations, all running the most current updates/servicepacks-- Word/Excel/Outlook 2010 randomly hangs up throughout the day and the only way to get the application to unhang it to go into the Task Manager and kill the spoolsv.exe Once the spoolsv.exe has been killed, Word/Excel/Outlook 2010 springs back to life??

I have tried uninstalling Office and reinstalling, uninstalling and reinstalling the OS but the issue still persists. It does not seem to matter if the computer is attached to a local or network printer, as I have tried uninstalling and reinstalling printers and print drivers.

Any suggestions??

A:Word/Excel/Outlook 2010 hangs Window7

You need to try Download New Office 2010 setup from Microsoft site....Just for trial base...try it's working fine or not....download trial version only ....

Download Microsoft Office Professional Plus 2010

11 more replies
Answer Match 84.42%

Hi all,

I recently bought a Win 8 box and all seemed to be going well for the first few days. Since then, several of my apps have started acting weird - eg, crashing upon launch, hanging, not responding for a minute or two and then coming back t life.

Unfortunately, Windows Update is also unresponsive no matter how I try to launch it, so I can't tell what problems are due to a lack of updates.

I'm starting to pull my hair out as less and less works on the new box.

Any suggestions (aside from a wig)?

Thanks!
CarCar

More replies
Answer Match 83.58%

I have had a terrible time trying to trace down "not responding" in various programs. About 90% of the time however, it occurs in Outlook 2010 and sometimes in Word 2010. I took down the information from the event viewer after the last time it happened so badly that I had to restart the program because waiting didn't bring it back.
Win 7 Prof, SP1. i7, 930 with 24 gig of 1333 Kingston HyperX ram. Several drives: C SSD Plextor and Office is actually installed on a WD Caviar. Neither drive show errors. Only thing I see is that the Caviar is using Microsoft 2006 driver and I haven't been able to find a newer driver. Happens when SATA is set to AHCI and when it is set to IDE.


Thanks for any help or suggestions you can offer.
BTW, I have run scannow and also have gone through my pst files and archived.

Louise

A:Outlook 2010 and sometimes other Office 2010 not responding

Your post is evidently messed up as your graphics are not readable.
You might want to look at your post and see what you can do to clarify
your pictures.

Rich

1 more replies
Answer Match 83.16%

Hello,
I'm without any success hardly trying to modify (as begginer I'm still unable to create) some macro's I found in this forum in order to send data from Excel sheet into a specific public (or not if it's too heavy) calendar in Office 2010.
Import would take place with a push of a button and duplicates should not be allowed...

Even a simple line like: Dim olApp As Outlook.Application gives an error ...Maybe I'm getting tired...

And how should I modify those lines in order to select a specific Calendar (using Folder(Calendar name) in place of GetDefaultFolder in the lines mentioned here under?
Set olNS = OL.GetNamespace("MAPI")
Set olFolder = olNS.GetDefaultFolder(olFolderCalendar)

If someone would be kind enought to give me a help, here are some details about my Excel sheet:
Column A "Company", Column D "Date soon", Column G "Date Late"
Column A is fully completed, but columns D and G have some lines without any date...
 

More replies
Answer Match 83.16%

Dear All,

I am new to this forum and not sure if this had already been answered. But here it goes anyway.

I would like to create a vacation form that users can use to fill their vacation requests. This form will have approve or reject buttons. If approved, the data would be auto populated onto an excel spreadhseet. If rejected, the rejection email will be sent back to the user.

Can someone show me how to do this.

Many Thanks for all your help in advance.

Regards,

Rashid
 

More replies
Answer Match 83.16%

Hello

I have an issue with a user. OS is windows xp and office 2010. When she gets an excel attchement, it can only open in preview mode.

I have done:
1> deleted the the contents of Temporary internet file.
2>Deselected the proetected view (all 3 oxes have been deselected.)
3> "ignore other application that use DDE" is deselcted.

Still no change.

Any help is appreciated.

Thanks
 

A:Outlook 2010 will only open excel attachement in preview mode

Try saving the attachment to a folder or to the desktop, then open from there.
To save, right-click the attachment and choose Save on the context-menu.
 

3 more replies
Answer Match 83.16%

Help! I would like to convert to computerized recordkeeping. The only software available to me is Office 2010 suite. I have created an Access 2010 budget database that includes purchases, vendors and users. I also have created an Excel 2010 spreadsheet with beginning budget amounts and purchases that works very much like a checkbook. However, I don't want to have to enter information in both. Early next week, I have to produce a report that shows what percentage of our available budget we are spending on a vendor. This report will be used as a visual to ask for more money. Any suggestions on the best way to do that for a someone who is not familiar with VBS or SQL or any other real techno language?
 

A:Access 2010? Excel 2010? or both?

If all of the information is in Access already just create a report based on the vendors and money spent with each. You can easily do this if the data is set up correctly in the database.
 

3 more replies
Answer Match 82.32%

Hi,

If I upgrade only the Outlook part of my Office 2003 installation to Outlook 2010 will the "Ribbon" style menu of Outlook 2010 be installed in my remaining Office 2003 menus?

I accept that at some point I will probably have to get to grips with the "Ribbon" style menus introduced initially in Office 2007. However, for the time being I would prefer to keep the classic menu layouts in Access 2003 and Excel 2003.


Rgds

A:Will Installation Of Outlook 2010 Install Ribbon In Access/Excel 2003

Aud Bint, No Installing outlook 2010 will not add anything to the office 2003 products that you have installed.
One problem that I noticed with office 2003 and outlook 2010 is that Sometimes after a microsoft update where they update some of the office products and outlook. You have to go to installed programs and repair the outlook 2010. It happened almost any time that microsoft updates were run and the office products were also updated.

Rich

2 more replies
Answer Match 81.9%

I cannot change entry in ID field of Facilities Table due to 1-1 relationship to Test Data Current Table. I just want to modify it from "70100" to "AI-70100".
 

A:Modifying Fields in Access 2010

Is there just the one record that you want to change?
 

3 more replies
Answer Match 81.9%

Hello,
I am fairly new to database and I don't know much about VBA coding.
I am creating a database and I have created a form for end-users to submit create a new record. but I want all the fields except one to be required.
I tried to make them required in the table but it gives me error when I enter data through the form. Can anyone please help me with this.

I have the following fields to be required

First name
Last name
Date of birth
Department
Employee level
employee status
Employee ID
GID
Hire date
E-mail
Phone number
Model ID

Thank you in advance
 

A:Access 2010 Require Fields

6 more replies
Answer Match 81.9%

Hi,
Here is my problem. I have a table with details of enrolled students. Many of the students have the same name with only an initial or middle name to differentiate them.
I have a field each for forename, initial/middle name and surname in the table.
I need each field to be able to accept duplicate entries but where both forename and surname are identical, the initial/middle name must be a required field.
Problem is, not everybody has a middle name, so I cannot set the field property to required. I need it to be required ONLY in the case that the forename and surname are identical.
Anybody got any ideas?
I tried using ID, forename, initial/middle name, surname as PKs but that doesn't work.
Please explain in simple words, I am not a technical expert, just an admin.
Regards
Nick
 

A:Access 2010 unique fields

8 more replies
Answer Match 81.06%

I have a Table in Access 2010 which has several true/false fields. Is there a way for me to pull a report that lists which fields are true for each record while not listing the other fields?
 

A:Access 2010, List True Fields

8 more replies
Answer Match 81.06%

Experts,
Usually iin MS ACCESS 2010 when you create a field in a table for attachement, the sub fields are there in the " Add Fields" top a form but this time after entering the field of Attachment in a table , i dont see any of the subfields. Did I miss something here.
Your help is appreciated.
 

A:Solved: MS Access 2010 sub fields attachment

Sorry, I have never used Access 2010 or it's Attachments field.
 

2 more replies
Answer Match 80.22%

I have an important program that uses a DLL that only works with Excel 2010 32 bit. I'm running Excel 2010 64 bit now -- how do I install the 32 bit version? I have the CD which has both versions on it. But when I run Setup, it gives me options that I don't understand for this limited purpose. In other words, I want to keep all my other Office applications (Outlook, Word, etc running as 64 bit versions but in the future run Excel in only the 32 bit version.

I'll appreciate your help with this very much!
/ Gary E.

A:How to go back from Excel 2010 64 bit to Excel 2010 32 bit

What exactly are the options shown when you run setup? Do you have an option for completely uninstalling Excel?

As I recall, MS recommends the 32 bit install and I think it is the default. Did you have some specific reason to choose 64-bit?

Have you seen this:

How to Downgrade Office 2010 from 64-bit to 32-bit ? My Digital Life

6 more replies
Answer Match 80.22%

Now in the form, only Names is updated in table tblOrders. I want to update BizUnit in tblOrders too, what should I do?
 

A:[ACCESS 2010]2 tables with same 2 fields but only one field updated.

Why do you want to add the BizUnit to the Orders table?
I notice that you also have emails in there as well, they also should not be in there.
Only data relating to the Order should be in the orders table.
The data is then brought together using a Query for Output purposes like Reports & Invoices etc.
 

1 more replies
Answer Match 80.22%

I am using Access 2010, I have certain fields on the form that need to be entered in Arabic and certain in English. I have set the keyboard language for the text box to be "Arabic" (for text in Arabic) and "English" for text in English. When I do this, it takes a little more time to move between fields. How can I overcome this problem. In Office Xp, I never had this problem.
 

A:Access 2010 - Moving between fields takes time

how did you set the thext boxes to use different languages? I have never done this so I need to configure the same to test, also have you gone through all the settings and advanced settings of language Bar, Regional settings etc..

how much more time are you talking?
 

3 more replies
Answer Match 80.22%

You guys have been a huge help in the past with issues I've had with Software Licensing database I created in Access, so I'm hoping you can lend a hand with a new issue I'm running into:

i copied some data from a table to do some comparison and clean up in Excel. I realized a little late that I should have pulled more fields than I did... I have done the clean up and now I'd like to get the additional fields to finish the job. I've imported the cleaned up data as a new table (Table A) and want to run a query against the original table (Table B) to pull those additional fields. Not all of the records in Table A are present in Table B, and vice versa.

In the query design, I show Tables A and B and join the First Name, Last Name and Application fields. The Join Properties are to include all records from Table A and only those from Table B where the joined fields are equal. Table A has 1606 records, so my hope is to have the query return 1606 records with the missing fields added. I'm bringing in all of the fields from Table A and adding the missing fields from Table B.

The query returns 1899 records. I ofound one user who only has four records in Table A, three records in Table B, and the query is returning 12 records for them.

What am I doing wrong?
 

A:Access 2010 - Adding fields to a table using a query

16 more replies
Answer Match 78.54%

It seems that there may be a problem in Office 2010. I just installed it to the standard MS default/recommended settings .........all looked good...used Word great..until I use Excel and each time I try to use excel it sets off an 'Office Configuration' screen which I can not stop..it take a few minutes and then loads OK. I tried to launch it from the installed prgrams icon but there is no files on 'start in' etc..I tied to create a shortcut to the desktop from the excel.exe file and get the same reconfigure issue..it seem that somehow I don't have either permissions or I have a corrupt install..all Office suite works eventually Anyone know how to fix it..please?

A:Office 2010 Pro Plus Win7 x 64 Excel reconfigures Office 2010

Have you ever had a previous version of Office on this copy of win7?
or

Do you have any component of a previous office suite installed still

I have seen this in the past with Viso that was due to remnents of an earlier trial remaining on disk and in the registry.

I also found that if I cancelled the configuration screen the Viso would load without problems without the need to wait for completion.

There are some rather involved solution stems on Microsoft website - cannot find them at the present but will try to look for them.

The problem was that I could never get the removal steps to actually cure the issue and I put up with the error until my next re-install of Win7, which was not to long in the case of that system

6 more replies
Answer Match 78.54%

I am also new to Access 2010 so am slowly learning my way around. I need an iif statement that will allow me to create a new column telling me whether one date field (Course Date) is within or outside the range of two other date fields (Previous Effective Date) and (Previous Expiration). I hope that someone can help me solve this issue quickly. I've tried various ways to write the statement and none of them worked. One statement only returned the information as all being outside of the range, which I could clearly see was not true. Here are some examples of what I tried. None of these worked at all. Thanks. Joyce

=IIf(([course date]>=[Previous Effective Date] and <=[Previous Expiration Date]),"between dates",IIf([course date]<=[Previous Effective Date] and >[Previous Expiration Date]),"outside date range")

In/Out Range: IIf(([course date]>=[Previous Effective Date]),"between dates", And IIf([course date]>=[Previous Expiration Date],"outside date range "))

In/Out of Range: IIf(([course date]>=[Previous Effective Date] And <=[Previous Expiration Date], "between dates") And IIf([course date]<=[Previous Expiration Date] And >=[Previous Expiration Date], "outside date range"))
 

More replies
Answer Match 74.76%

Well, gee whiz! I thought that I had all a soul could need fulfilled with my other two posts, but here I come again. I've only been a member for about 4 days and already I have asked 3 questions Please forgive me because I am slow

Okay...I have created a combo box that changes the data in the text boxes below. Very slick! Now, I've hit a snag. Let's say the combo box has the site - Denco - and the information that needs to be filled is address, phone, site #. This is done. Ok, so now, I need to look at Denco's ten employees individually, filling the second group of text boxes with their name, address, and phone. So, once Denco is selected, the address stuff drops in. Then, some sort of box (help me!) will show all Denco employees individually, then fill the other set of boxes with the info about the employees one by one (i.e. Beth, Pat, Ralph, Mike, Darrin). Does this make sense? If not, please ask, 'cause as I said, I need help.

Dreamboat has been here for the last two dilemmas, and if her plate is not too full, I hope she can help me again If not, I KNOW there are a wealth of people in this forum who can help and I thank you in advance.

Sincerely

Zoe
 

A:Access: combo box to populate another combo box to populate other fields

12 more replies
Answer Match 73.5%

Win 7 Pro 64.

Ms Fax does not permit updating of fields in cover pages. Info like senders name, recipient name, etc. cannot be entered. The controls/fields can be selected, but, entering or updating info does not work.

I managed to copy a cover page created under Ms Fax under Xp and CAN update fields.

Here is a thread with identical issue and without a solution.

How do I populate the fields on the fax cover page&#63; - Microsoft Answers

A:Ms Fax Cannot Populate Fields in cover pages (.cov)

The first thing I would try is go to "Programs and Features" in control panel. Click on turn Windows features on and off. Find the Fax program and untick it and close and Windows will remove it. Reboot, Retrace the same path and put Fax back. Another reboot.

1 more replies
Answer Match 73.08%

I am running Microsoft Office Professional Plus 2010 on Windows 7.

When I open Excel my personal.xlsb opens fine and my macros are available and I can create new macros. No problems.

BUT when I open any existing Excel file the pesronal.xlsb is not opened and therefore no macros and I cannot create new macros as I get the error "Personal Macro Workbook in the startup folder must stay open for recording." I have been trying things all night with no luck. Any suggestions would be greatly appreciated. I will list the things I have tried or checked with no success below:
In Options>Advanced Tab>General Section....the box for "Ignore other applications that use DDE" is NOT checked.
In Options>Trust Center>Trust Center Settings>Trusted Locations... I have C:\Users\Nick\AppData\Roaming\Microsoft\Excel\XLSTART listed which is where my personal.xlsb is located
In Options>Trust Center>Trust Center Settings>Macro Settings ...Disable all macros with notification...selected and not selected neither way solves the issue.
In Options>Add-Ins>Manage: Disabled Items ...There are no disabled items.
I have deleted HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel in the registry editor
I have deleted C:\Users\Nick\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB and then run excel to create a new personal file.
I have renamed C:\Users\Nick\AppData\Roaming\Microsoft\Excel\XLSTART\PERSONAL.XLSB to PERSONAL.XLSA

Thank you in advance fo... Read more

A:PERSONAL.XLSB does not open when existing excel files are opened in Excel 2010

6 more replies
Answer Match 73.08%

We recently migrated from Office 2003 to Office 2010.

Just to give some background, (and I dont' know if this is relevant to this error), the Office 2003 excel did not accurately show the correct file paths where files were linked. It would show something in the C drive.

The issue I am concerned about today is this: when some users close files in 2010 (files were created in they sometimes get the error below:

'"The name ABE2, either conflicts with a valid range reference or is invalid for Excel. This name has been replaced with _ABE2"

Can someone assist me with this? I need to stop it from appearing and I am not sure how.
 

A:Solved: Excel 2010 v Excel 2003 Error Valid Range

14 more replies
Answer Match 73.08%

Problem in Excel 2010 [but revives a Closed TSG thread for Excel 2007]

The "Personal Macro Workbook" is a file called Personal.XLSB
The Personal.XLSB file is in the correct location /XLSTART/
The file properties option "Opens with Excel" is selected.
The file contains a (freshly re-made) macro.
(It also contained the same steps macro before it was deleted
and re-recorded during troubleshooting for this problem.)

When Excel is opened, the Personal.XLSB DOES NOT OPEN WITH it.

Because the Personal Macro Workbook does not open,
- existing macros do not function,
- nor can new macros be recorded

Same not-opening result, whether opened by clicking on
- Excel, in the Programs list or
- a desktop shortcut to a specific Excel file

However, the Personal.XLSB file can be opened and the macro made functional
by manually opening that file where it is stored in /XLSTART/

An unexplained workaround was identified in the closed thread.

*rename the Personal.XLSB to Personal.XLSA

I find this workaround effective.
The Personal.XLSA file opens with Excel and the macros are available.
But the file seems to be grayed out when viewed with Explorer in /XLSTART/

However, I do not like using workarounds, as they can cause trouble later.
I find that the "open with" setting was changed when the extension was changed
The setting is now "Opens with: Windows Shell Common"

I would appreciate an explanation how to make Personal.XLSB open as it should.
... Read more

A:Solved: Personal.XLSB in Excel 2010 does not open on starting Excel

16 more replies
Answer Match 73.08%

I've searched for issues regarding non-working VBA code written for Excel 2010 and compatibility wit Excel 2011 for MAC.
I am currently using Addin (*.xlam) files that hold all the necessary code to process multiple files without needing to use the PERSONAL.XLSB and as eliminating the need to copy VBA code to every file that requires.
This works perfectly with all the Windows Office versions.
Today a colleague want's to run this same file on a MAC book with Office 2011.
The moment he opens the Addin het gets an error that a library cannot be found, understandable, but the Tools Reference in the VBA project is also greyed out so I cannot even try setting any reference.
Does anyone have any experience with this or is this something that needs a complete new approach when it regards Office on the MAC?

I hope somebody can help
 

A:Solved: Excel 2010 xlam file not working with Excel 2011 for MAC

6 more replies
Answer Match 72.66%

Most of my Excel files open fine with a doubleclick from Windows Explorer. I have two XLSX files however, that "try" to open when I single click. They open to a blank, grey screen - essentially they open Excel, but the file does not open. (I do see a quick flash of tabs at the bottom indicating the file is starting to open or opens and then terminates immediately).

The problem is clearly not a "tiled window" or "window offscreen" problem - there is no file open. All the Excel functions are greyed out. If I go to File-->Options, i just get a blank grey screen. If I go to file --> open, I can then open any file.

It seems that these two files have some kind of trigger property that starts Excel with one-click, but I can't find how to change that property. None of my other XLSX files act this way.

UPDATE: Further experimentation reveals that this problem is somehow linked to password protection. I copied all the tabs to a new sheet and saved as XLSX. This sheet works normally, i.e. I can click on it once to highlight it and it does not open Excel. I double click and it opens. But once I password protect it, the behaviour changes to that described above.

A:Excel 2010 - Excel Opens Blank on One Click of File

Do you have the "preview pane" on? if so, turn it off and you should be able to view the password protected documents properly.

1 more replies
Answer Match 72.66%

Hi guys,

Since a day or two I?m having the following issue when I close an excel file (extension xlam).

I write my own addin files and have been using them for many, many years.

I?ve read that this seems to be a bug with Excel 2010 but the strange thing is why now and not before?

The addin is not installed, I run it when I need it, it contains the necessary xlm code with custom ribbons and all the necessary buttons, you name it, it just works as it should.

I have one button that either close the addin or quits Excel altogether

The VBA project?s properties are set to non-visible and password protected.

Now I get the dialog prompt to enter the VBE password. If I enter the password or press cancel, all I get is that Excel has encountered a problem and will shutdown.

OS: Windows 10 64-bit, Office 2010 and everything has been running fine with Windows 01 and before that with Windows 7

VBA Editor window is not maximized (as I read on several posts), and when I remove the password and save it and then reopen the vbe editor does not show up anymore when closing.

If I run the same macro directly, not using the menu button, the same thing happens. It seems like it?s trying to access the VBA properties, but I have not added any code to do that.

Very strange and especially I do not like thing I do not understand, no changes made and I do not address the VBE components in any way.

Any ideas?
P.S. I cannot upload the file but the thing is that it just started, all at on... Read more

More replies
Answer Match 72.66%

Hi folks. I work in the IT field but am not too good with MS ACCESS 2003. I have been given a task by my boss to get familiar with MS ACCESS. I was wondering if anyone here knows how to populate data from another table in MS ACCESS 2003? I'll give you a description. The client has a form called Referal form, Primary Referal Source and Secondary Referal source fields that need to have data populated from a referal persons table. Can anyone tell me how I can go about doing this.Thanks in advance.
 

More replies
Answer Match 71.82%

Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows 7 Home Premium, Service Pack 1, 64 bit
Processor: AMD A6-4400M APU with Radeon(tm) HD Graphics, AMD64 Family 21 Model 16 Stepping 1
Processor Count: 2
RAM: 7650 Mb
Graphics Card: AMD Radeon HD 7670M, -2048 Mb
Hard Drives: C: Total - 931724 MB, Free - 865841 MB; D: Total - 21840 MB, Free - 2343 MB;
Motherboard: Hewlett-Packard, 18A7
Antivirus: Norton Internet Security, Updated and Enabled

I am unable to open a password protected Excel 2010 file in Excel 2007.

When attempting to open this file nothing happens but on clicking the office button the New and Open options are available but all the other options are greyed out.

Using the open option has no effect on this file whatsoever.

I would be grateful for any suggestions.

Regards

Flynne
 

A:Excel 2010 file will not open in excel 2007

Does is need to be saved in a different format. Wasn't there a change in the default around that time??
 

1 more replies
Answer Match 71.82%

As part of updatting our computer equipment I was reassigned from a Dualcore Windows XP Sp2 with Office 2007 to a new Quadcore Windows XP Sp3 with Office 2010. Both with IE8.

The problem at hand is this particular Macro that is run monthly and creates 167 web querys, one at a time. This is why I made a macro. The webpage that I get my imformation from is http://www.systematics-int.co.uk/, which has a login page.

What I used to do in Excel was to first manually create a web query in such page in order to enter my login credentials, confirm that I entered the page, close the query wizard, and then proceed to run my macro. It worked, and still works, flawlessly in my previous PC but not so much in my new one, as all I get from the macro are a bunch of worksheets saying that I'm not logged in so I can't retrieve any information.

I hope I've been explicit enough as how it doesn't work. I really need this to work because my old PC is going to be formatted and my only option would be to do this manually.

If you need more info please ask, I don't think I've been clear enough as English is my second language.
 

A:Excel 2010 web query is not working as it did in Excel 2007

Could ik be that the symantec site has attached your login to a specic Ip address or machine name which now is changed because of your new system?
I don't really think it;s Office 2010.
Your system is new, another mac address, probably a new IP address, new computername.

All these seeminly irrelevant factors may be the reason it's now working, have you tried executing your macro step by step? Trubleshooting takes a lot of patience and time.

I hope this gives you some ideas to look at
 

2 more replies
Answer Match 71.82%

Hi

Does anyone know how to change the password for a Excel 2010 spreadsheet?

We have one, we know the password, but need to change it as many people that shouldn't know it, does. But can't figure out how

We can't use Save As, as the spreadsheet is linked to other tables on the network. Just want to change the password that we already know, to a new one.

Looked here already, they just mention Save As:

https://support.office.com/en-US/ar...ions-EF163677-3195-40BA-885A-D50FA2BB6B68#bm4

https://askdrexel.drexel.edu/app/an...:-change-password-of-a-workbook-in-excel-2007

We're used to Office 2003, so this is a big jump at work for us

Thanks

eddie
 

A:How to change Excel 2010 password (when in the excel sheet)

We can't use Save As, as the spreadsheet is linked to other tables on the network.Click to expand...

Why not? You can save it with the exact-same filename, even with the Save As command. It's only from here you can choose the Tools drop-down, General Options, and then change the password from there.
 

1 more replies
Answer Match 71.82%

Hi,

I am trying to pull a dashboard view from a "Tracker". Given below is the formula that I used:

=COUNTIFS('KT Tracker'!$T$2:$T$138,$C$2,'Tracker'!$U$2:$U$138,"<="&TODAY()+7,'Tracker'!$L$2:$L$138,'Monthly Dashboard'!$B17,'Tracker'!$AF$2:$AF$138,'Monthly Dashboard'!$A$13,'Tracker'!$AD$2:$AD$138,"<>Cancelled")

This perfectly works fine in my laptop that has excel 2013 but when I email this to my team who have Excel 2010, they only see zeros. We have checked all options like enabling Automatic Calulcation of Formula, removing all named ranges in the sheet etc., but it is just not working.

Can you please help ? This is a bit urgent and I need to present this for a meeting tomorrow.
Appreciate your help and thanks in advance !!!
 

A:COUNTIFS working in Excel 2013 but not in Excel 2010

It might be something to do with "<>cancelled"
 

1 more replies
Answer Match 71.4%

I recently purchased a new computer that has Office 2010 installed. I would like to move the contents of my .pts file from my old computer which has Outlook 2007 to my new computer which has Outlook 2010. Before, when I wanted to transfer my .pts file from one computer to another I would just copy the file to a portable hard drive and then transfer the file to the other computer. However, Outlook 2010 is completely different animal. When I go to C:, Users, App Data, etc., new computer, it is completely different from my other computer that had Vista. My question is, how can I transfer my .pts file and/or my address book, calendar, contacts, etc. for my older Windows Vista computer that had Outlook 2007, to my new computer that has Windows 7 and Outlook 2010 installed? Thanks in advance for any and all suggestions.
 

A:Solved: Moving Outlook Messages and Address Book From Outlook 2007 to Outlook 2010

Hello referee07;

Copy your .pst file from your old computer to the new one or your portable hard drive.

To launch the Outlook 2010 Export/Import wizard, first go to File menu, navigate to Open, and click Import.

In the Import And Export wizard, select Import from another program or file option and hit Next

Under File Type, select Outlook Data File(.pst) and hit Next

Now choose the file to import, select the options, and hit Next

Once done, finally select the folder to import from(if you want to import complete data don&#8217;t change any settings) and make sure Include subfolders is checked. You can either import the file to the current folder or choose the folder.

Hope this helps!

Dave
 

3 more replies
Answer Match 70.98%

After upgrading to WLM 2012, I find that entering any of my contact categories into an email address field will no longer populate the field with discrete email addresses.

What should I do?

Mike K.

A:WLM 2012 Contact Categories Won't Populate Email Address Fields

Hello and welcome Mike mate my addresses carried over when I did a fresh install. I take it you are using the same email address and that you mean when you type say an "S" it used to drop down a list of addresses associated with that letter?

The other thing I could suggest if you have another machine with WLM 2011 running on it is to send yourself a list from the machine of the addresses.

9 more replies
Answer Match 70.98%

Hi, I have set up a new Access 2010 database (saved as .accdb) (copying tables, forms and queries from my current one then deleting the old data and modifying a lot of fields). I have a query in with some simple calculations. All the calculations work perfectly in Access. When I merge this into Word 2010 (set up as a letter document) it doesn?t use/show the correct data.

The calculated fields in the query are ?number of people * price tea & coffee = cost tea & coffee? and ?number of people * price buffet = cost buffet". I then use these costs in the same query to work out ?VAT? (another calculated field adding up the calculated "cost tea & coffee" and calculated "cost buffet" as well as a number of other non-calculated fields and multiplying the total by 0.2) and ?Total Cost? (a calculated field adding up various non-calculated fields, the calculated "cost tea & coffee", calculated "cost buffet" and the calculated VAT field).

There are two errors in the data that ends up in the merged Word document:
The "VAT" doesn?t add in the two calculated fields, it only uses the data from non-calculated fields in the query.
Also the "Total Cost" doesn?t add in any of the calculated fields (teas & coffees, buffet and VAT), it only uses non-calculated fields from the query.

It doesn?t ping up any error messages. Why is it changing the data between Access (where the query works per... Read more

More replies
Answer Match 70.98%

Hello,

I have a new issue that has come up since we converted an Access database to 2007 file format.
Here is the history.

We have an access database that was created in the old file format. In that database there is a button that opens up word and a mail merge file. Word's mail merge then uses a query from the access database to populate the mail merge document.

We recently converted the Access database to the Office 2007 file format and now the merge process will not work.
I have tried to relink the files and have done some research and it appears that the DDE way of connecting is no longer used in Office 2007. I did finally get to the point where I could see the queries i needed but once I try to open that data source Word give me a general error that it can not open the data source.

How can I get these merge files working again?

PS. We are running Windows XP if that is needed.

We are quickly moving to office 2010 also but that uses the same file format as 2007 so I assume it won't be an issue. Any help you can give me would be GREAT!.
 

More replies
Answer Match 70.98%

Thanks in advance for your knowledge and help...so here it goes....Running XP (last update 1/16/2010) IE8 SP3 (late update 1/23/2010) and Avast 4.8 Home edition w/ ZoneAlarm firewallI have read the tutorial for this forum and have tried to follow all instructions, however I was not able to backupmy data using Cobian. I followed the instructions in the tutorial but I could not get my system to recognize the new drive of G:\ so at this time nothing is backed up. I know this is a "stupid" questions but if I back up my files willit backup any of the virus/malware/trojan programs on my desktop?Some other info:Originally the malware disabled my fire wall (the MS onboard one) and the malware displayed a "fake" security center screen and all links brought up various fake pop-up's of infections etc... I was able to download the ZoneAlarm firewalland it seems to be working. It is blocking outbound requests from my system to the internet and asking for approval..I have to assume this is a good thing.This morning when I tried to run Avast it said the operating system was infected and to reboot and a virus scan would be run at boot-up. I did this and now things are better (ie the Security setting look Microsoft normal for the firewall)....I'm still running the ZoneAlarm firewall at this time. However all the pop-ups and other crap is still there.*** Additional info added 1/28 **running avast at bootup found approx 20 virsus and rootkit files and... Read more

A:IE Redirect Virus/XP Guardian 2010 and Internet Security 2010 Malware

Hello , And to the Bleeping Computer Malware Removal Forum. My name is Elise and I'll be glad to help you with your computer problems.I will be working on your malware issues, this may or may not solve other issues you may have with your machine.Please note that whatever repairs we make, are for fixing your computer problems only and by no means should be used on another computer.You may want to keep the link to this topic in your favorites. Alternatively, you can click the button at the top bar of this topic and Track this Topic, where you can choose email notifications. The topics you are tracking are shown here.-----------------------------------------------------------If you have since resolved the original problem you were having, we would appreciate you letting us know. If not please perform the following steps below so we can have a look at the current condition of your machine. If you have not done so, include a clear description of the problems you're having, along with any steps you may have performed so far.If you have already posted a DDS log, please do so again, as your situation may have changed.Use the 'Add Reply' and add the new log to this thread.We need to see some information about what is happening in your machine. Please perform the following scan:Download DDS by sUBs from one of the following links. Save it to your desktop.DDS.scrDDS.pifDouble click on the DDS icon, allow it to run.A small box will open, with an explanation about the tool. No inp... Read more

6 more replies
Answer Match 70.98%

Hi All,
I would like to know is there is any way i can Integrate of Access 2007 , Sharepoint 2010 and Info Path 2010, because as far as my knowledge we can upload Access 2007 into Sharepoint 2010. In Sharepoint i cannot able to use Access 2007 forms so i need to create another good looking way of showing the access lists.
Can you please anyone help me how i can implement this and if we can what are the requirements need to be done, like tools required and steps for the implementation.
If anyone can suggest some books also i can able to read it and learn it myself.
All the response are welcome and thanks for all your support.
 

A:Integration of Access 2007 , Sharepoint 2010 and Info Path 2010

I see no one is offering anything on this post. Not a great site for SharePoint(SP) information. But SP its self is relatively new for developers. We can't afford real SP developers so se make our own. Not a great plan but we are supporting a large SP site.

I think with Access 2007 the best approach is to use it to update list and make reports from list. There is no integration to InfoPath forms that I know of. You have to build them on top of your list with SP Designer.

I did find this video in my favorites that says publish access 2007 to SP2010. I haven't whatch recently...
YouTube
If you really need Access (in SP) you have to go to 2010. I waited till Access and SP 2010 were available on a test site and build a relatively simple db with a couple of reports and queries that did funcion correctly (without too much alteration). I did have to key each table before it would 'publish'. The 'publish' wizard will walk you thru needed fixes. I looked for the DB to refresh my memory but someone has rebuilt the test site and dropped it.

Any way good luck. I wish I had some recent experience on the issue to offer. Maybe this will 'bump' your thread and get some more information!
 

1 more replies
Answer Match 70.56%

Hello,

I want to create a table as in the drawing below, where the first cell is table-wide (as it contains the heading common (pertaining?) to all columns and rows under it) but, and this is where I cannot get it together, where those cells are divided into several columns.

It's a cinch when drawing a table in MSWord (2003) so I cannot imagine why this should not be possible in Excel, but then I don't know everything

Thank you

A:Formatting Excel 2010, Excel 2003

If I understand your problem then it is quite simple. Assuming A1 has the "heading" then select thsi cell and all the other cells in row A which pertaim to the tanle and then "merge the cells" and centre the title. I forget how this is done in Excel 2003 but I do remember it being available on the screen on the Edit toolbar I think.

Cheers

5 more replies
Answer Match 70.56%

Hey all,

I'm having an issue with the Xerox Workcentre 7120 and Excel 2010. I simply cannot print Excel files whatsoever. It tells me that the document has been sent to the printer, yet two minutes later it tells me that the print job has failed - no reason given, it just says in the Completed Jobs tab that it was cancelled. When looking at the Completed Jobs tab on the printer itself, it tells me that it was "Completed-Error" - basically meaning that nothing happened. I'm running Windows 7 64-bit.

I've tried many fixes, including restarting the PC, restarting the printer, restarting the print spooler, reinstalling Office 2010 completely, installing another driver for the printer, running a repair on Microsoft Office 2010, reinstalling the printer completely (it's a network printer) and dancing around the PC in complete frustration whilst chanting (the last one helps a lot, strangely enough).

The weirdest thing is that it's just an issue with Excel - Word, Office and other Office programs print fine with this specific printer. Does anyone have any suggestions? I've tried printing to another printer in another part of the office, and that works perfectly fine. It's just a hassle having to go through multiple doors and parts of the office to retrieve a simple document.
 

More replies
Answer Match 70.56%

i am mail merging (word 2010 and excel 2010 database).

when i choose to send the messages as HTML, all is good.

when i choose to send text or attachment - i get this security warning. even after pressing "allow" - nothing happens. (nothing = no trace of messages in outbox and no mail sent)

i know that: "If you choose a format other than HTML, an Outlook message may inform you that a program is trying to access e-mail addresses and send e-mail. This message is a security measure designed to protect against viruses that replicate through e-mail. To continue with the merge, select the Allow access for check box in the security warning dialog box, and then select the amount of time that you need to complete the merge. Click Yes. If you are prompted again, continue to click Yes until the merge is complete."

thank you very much!!!!

_____________________________________________________________
Tech Support Guy System Info Utility version 1.0.0.1
OS Version: Microsoft Windows 7 Enterprise , 32 bit
Processor: Intel(R) Core(TM)2 CPU 6600 @ 2.40GHz, x64 Family 6 Model 15 Stepping 6
Processor Count: 2
RAM: 2045 Mb
Graphics Card: NVIDIA Quadro FX 3450/4000 SDI, 256 Mb
Hard Drives: C: Total - 50006 MB, Free - 27905 MB; E: Total - 102577 MB, Free - 102479 MB;
Motherboard: Dell Inc. , 0DN075, , ..CN708217847009.
Antivirus: Kaspersky Anti-Virus, Updated and Enabled
 

More replies
Answer Match 70.56%

Win 7 SP1 64-bit
Word 2010
Access 2010

We have some fill-in form templates that we have moved from Word 2003 to Word 2010 (properly) and in the underlying form macro, there is a call to a database to pull office address information that originally was in Access 2003. The macro works just fine if it opens the 2003 version, but I want to update the database to 2010 so that I don't have to worry about compatibility issues. So, after creating a new 2010 database, I went into the Word macro and changed the name of the database in the macro to reflect the new 2010 database, and nada. The statement that accesses the database does not seem to work. Here is the text:

Dim conn As New ADODB.Connection
conn.Provider = "Microsoft.Jet.OLEDB.4.0"
conn.Open Environ("ALLUSERSPROFILE") & "\Application Data\sgData01.accdb"

Dim rs As New ADODB.Recordset
rs.Open "select * from offices where shortName = '" & sCity & "';", conn

I am NOT a programmer so if there is further information you need, please let me know. I assume, though, that perhaps 2010 uses something other than Microsoft.Jet.OLEDB.4.0 or something like that...

Any and all assistance will be HUGELY appreciated!!

C. Homer
 

A:How to pull data from an Acess 2010 database using Word 2010 VBA

Allen Browne has a utility to establish the Jet version (among other properties) of the current database. See
http://allenbrowne.com/ser-53.html
 

1 more replies
Answer Match 70.56%

Can this be done?

A week ago, I bought a new CD of MS Office Home and Student 2010. Before I did that, I asked my wife, who has occasionally used Access 2003, "do you still need a database program?". I SWEAR she said "no I don't use it any more". The FIRST time she sat down to use MS Office 2010 she asked me "where's the database program?" aarrrrrrrrrrrrggggggggggggghhhhhhhhhhh....

So is it possible for me to buy a way to upgrade the version I have now, or must I buy a completely new stand alone CD for just Access 2010?
 

A:Adding MS Access 2010 to my MS Office Home and Student 2010

I have NOT seen any upgrade to a higher package.

I think the only way is to buy the stand alone package.

Now that you know, you will be buying the Pro version when you upgrade to 2013!
 

1 more replies
Answer Match 70.56%

My beta expired so I uninstalled the beta. I restarted and tried to install the trial but I get this error.






Quote:
Error 25004. The product key you entered cannot be used on this machine. This is most likely due to previous Office 2010 trials being installed. (System error: -1073418160)


I read then that I was to delete the following reg entries






Quote:
HKEY_CURRENT_USER\Software\Microsoft\Office

HKEY_LOCAL_MACHINE\Software\Microsoft\Office


Problem is the bottom entry is not deleteable. If I try to delete it or a subfolder or the key I get






Quote:
Cannot delete office: Error while deleting key.


I tried deleting the key in safemode or by altering the permissions of it and running regedit in admin mode but nothing worked. I'm running win 7 x64.

I would greatly appreciate any help so I can clean this and install the office 2010 trial.

A:After uninstalling Office 2010 beta can't install 2010 trial help

Down load and use this Ccleaner Piriform - Download CCleaner, Defraggler, Recuva, Speccy - Millions of users worldwide!
then try to install
If you still cannot, try in safe mode

9 more replies
Answer Match 70.56%

I have a word document set up with fields that I want to create a mail merge from a Query. When I go through the steps to add my query as the source then click on edit recipients there are no recipients. I have tried the same steps with other queries that I have and it works. I'm not sure why the query I want to use isn't working. The query I have set up does have a lot of expressions. Here is an example IIf([fie dt] Between #8/1/2010# And #7/31/2011#,[fie dt]+1096,Null) I have tried to change the expression and it still doesn't work. Any ideas? Thanks!
 

A:mail merge issue with Word 2010 and Access 2010

10 more replies
Answer Match 70.14%

I have a document in Excel 2010 which contains 2 columns. Data from 2nd column is constant, does not change and is assigned to data in 1st column. Names and surnames are great example, so I will use this case for explanation.

Currently there are 200 unique names in 1st column and of course 200 surnames, attached to them in every row. There won't be any new names ever.

This is functionality I'd like to have. I often have to copy some of those names from external database (software) in various numbers. Let's say 50 random names to 1st column. But when I do that, I have to manually write down surnames to 2nd column, because they come from another database (software) which is not synchronized with the first one, so I cant just copy/paste them.

Is there any way to save (connect?) all 200 surnames to all 200 names in Excel, so when I would copy some of names from external database to 1st column, Excel would automatically attach appropriate surname to 2nd row?

I hope I was clear. Thanks for help in advance!

A:Excel 2010 help

Hi,

Seven Forums is an excellent place to get answers. But sometimes, you might find that there is a more focused, dedicated forum for a specific topic, such as in this case.

One of the best excel resources with a bunch of extremely helpful people is at MrExcel.com | Excel Resources | Excel Seminars | Excel Products.

Jump on the forums there. I'm sure you will have your answer very quickly.

good luck
Tanya

2 more replies
Answer Match 70.14%

I wanted to see if there is a way to add next invoice number, once printed, to an invoice template I downloaded.

Also, I tried copying Original Copy Sheet to the Customer Copy Sheet & File Copy Sheet but if the Original Copy Sheet doesn't have information in it, it copies "0" which I would like to stay blank. How do I do that? I was using = and clicking on that certain cell.

I tried VBA and enabling macros, but I didn't have any luck.

Please help.
Michele
 

A:Excel 2010

Hi,

Here's a simple code to increase the invoice.
Code:

Sub Update_Invoice()
Sheets("Original").Range("K12").Value = Sheets("Original").Range("K12") + 1
End Sub
 

1 more replies
Answer Match 70.14%

Need some help in excel please
Got this project where i need to make a table in excel with info innit and such but the words are too big so it looks bad as pic related
How do i make it bigger?
 

A:Need help in excel 2010

Hi, welcome to the forum.
You can cahange the columns width, you kan change the font sieze.
Could you be more specific?

You can select the 4 columns and then double click in the border between A and B to autofit.
Because you are using the autofilter you van also increase the column width a little, but with your info it's unclear what you really want / need

SVP duidelijk uitleggen
 

1 more replies
Answer Match 70.14%

Hello. I am having an issue with formulas. Whenever someone emails me a spreadsheet or if I open a previously done spreadsheet that I have not opened before, there are formula errors thru-out. Some are just simple addition. What is the cause of this and how can I fix it? Also, my co-worker and I have the same Excel versions and it still comes up. Thanks!
 

A:Excel 2010

http://chandoo.org/wp/2009/04/20/excel-formula-errors/

need to know what the errors are
 

1 more replies
Answer Match 70.14%

Hello,

I have an excel (2010) spreadsheet with 14 associates, we have to taken coporate courses throughout the year. I would like to have an email message automatically go out to that person on the date in the cell (cc'd to me). Also, maybe have that cell change a color a week before the date. I will send you the form, maybe I need to change the format of the form? I really appreciate your assistance. We use Lotus Notes not Outlook. My system here at work is the following:
Tech Support Guy System Info Utility version 1.0.0.2
OS Version: Microsoft Windows XP Professional, Service Pack 3, 32 bit
Processor: Intel Pentium III Xeon processor, x86 Family 6 Model 23 Stepping 10
Processor Count: 2
RAM: 1977 Mb
Graphics Card: ConfigMgr Remote Control Driver, 1024 Mb
Hard Drives: C: Total - 238472 MB, Free - 196882 MB;
Motherboard: Hewlett-Packard, 3048h
Antivirus: None

 

A:Excel 2010

Since you've found the correct forum for your inquiry I'll go ahead and close this duplicate.

Continue here: http://forums.techguy.org/business-applications/1096917-send-email-excel-conditional-format.html
 

1 more replies
Answer Match 70.14%

Hi all
I'm trying to add a little Calculator function to a Spreadsheet I use for trading shares.

I pull basic data from YAHOO finance and would like to have at the bottom of a spreadsheet a calculator which would allow me to enter Nr of shares bought, Price Paid and return things like Profit / Loss.

The advantage of having it on the spreadsheet is then it's all in the same place.

The spreadsheet looks something like this -- enclosed pic

I'd like to embed the calculator in column M say starting at Row 15-- I'm not sure whether this should be done with a FORM or embed another spreadsheet.

Any ideas / links --- all the googling I've done either quote examples that are so impossibly complicated or hard or just too basic.

Cheers

jimbo

A:Excel 2010

It is possible that there already exists a function formula for the purpose:
Excel functions (by category) - Excel - Microsoft Office

e.g. PV - Returns the present value of an investment
Edit:
I just came across this, which might also be useful:
Excel VLookup Function and VLookup Example

9 more replies
Answer Match 70.14%

Hello,

I'm having this weird problem with MS Office 2010. When I'm working on excel files tend to crash for no reason and too frequently when I try to open them.

I have gotten these two messages:

1) Excel cannot complete this task with available resources. Choose less data or close other applications.

2) Excel found unreachable content in "XYZ.xlsx". Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.

3) Excel cannot complete this task with available resources. Choose less data or close other applications.

This is what I did until now trying to fix the issue.

Fully updated the system
Upgrade RAM from 4GB to 8GB
Upgrade from MS Office 2007 to MS Office 2010
Re-image the machine and re-install MS Office 2010

Any ideas what else could be causing errors when opening excel? I'm using a Dell machine, W7 professional 64 bit, 8GB RAM.

A:Excel 2010

What happens if you start with a fresh XLSX file and fill it with similar data?

Do you have an XLSX file that is causing this problem that you can attach to a post?

5 more replies
Answer Match 70.14%

I have a document in Excel 2010 which contains 2 columns. Data from 2nd column is constant, does not change and is assigned to data in 1st column. Names and surnames are great example, so I will use this case for explanation.

Currently there are 200 unique names in 1st column and of course 200 surnames, attached to them in every row. There won't be any new names ever.

This is functionality I'd like to have. I often have to copy some of those names from external database (software) in various numbers. Let's say 50 random names to 1st column. But when I do that, I have to manually write down surnames to 2nd column, because they come from another database (software) which is not synchronized with the first one, so I cant just copy/paste them.

Is there any way to save (connect?) all 200 surnames to all 200 names in Excel, so when I would copy some of names from external database to 1st column, Excel would automatically attach appropriate surname to 2nd row?

I hope I was clear. Thanks for help in advance!

A:Excel 2010 help

I'm not sure I understand 100% what you are trying to do; however, I think you could achieve this using a VLOOKUP function.

3 more replies
Answer Match 70.14%

When trying to open Excel 2010 file "Excel cannot complete this task with available resources. Choose less data or close other applications."
Anyone else having this issue?

More replies
Answer Match 70.14%

I have created a worksheet which I need to expand to fit an A4 page for printing. How do I go about it please?
 

A:Excel 2010 help

Select File > Print >Settings, Choose A4 Paper and change Scaling to fit to one page.
 

1 more replies
Answer Match 70.14%

For my workbook, I have defined the default font to be 11 pt Calibri. However, when I select a row (or column) and select Clear Formats, the cells are reformatted to 10 pt Arial. To me, this seems like a bug. Am I missing something?

A:Bug in Excel 2010?

How have you set the default font. You can set the Default Font by opening Excel, select file & then Options & under General there is a Sub Heading "When Creating new Workbooks" & there you will see "Use this as the default font". Then you can use the drop down list to select the font & size. If you change this it will only operate on any new workbooks that you create. Any previous ones will remain in the font that was originally used.
I use Excel 2013 so this info comes from that, but I think Excel 2010 is the same or very similar.

8 more replies
Answer Match 70.14%

When trying to print a selected area, the "rows to repeat at top" are greyed out (as are the other two adjacent options.
Have read the "cures" for Excel 2003 and 2008, (leave print preview and use file/print/page setup) but these do not work for my 2010 version.
Can anyone help please?
 

A:MSO 2010 - Excel

I've heard of this error before, it seems to be a bug in Excel. Did you get to the page set-up through the print options? If so, try the button on the ribbon instead - select the Page Layout tab, the click on the Print Titles button in the Page Layout group. Hopefully it should allow you to select the option you're after.

Let me know how you get on
 

6 more replies
Answer Match 70.14%

Hi Guys,

I have an issue with my Excel application. Every time I open Excel and click on File from the menu bar the application keeps freezing. I can click on the other menu bars but not FILE.

I have tried safe mode, re-installing the the whole MS Suite, and repairing and nothing worked.

Does anybody have some tips for me.

Thank you,
 

A:MS Excel 2010

I found this article that may help you:
https://support.office.com/en-us/ar...-working-37E7D3C9-9E84-40BF-A805-4CA6853A1FF4

Failing that you could contact Microsoft themselves if you believe it is a problem with their software:
https://sales.liveperson.net/hc/216...21661174&SESSIONVAR!campaign=officeUniversity

The last idea I have is to make sure your Anti-virus and Malware software are up-to-date and working, in case that it causes a problem. Although that might be more than just the one program.

Hope this helps
 

1 more replies
Answer Match 70.14%

I have a spreadsheet for my family expenses and I would like to make excel to send me a email when a payment is due. If it is possible like 5 days before the due date. And also tell me which bill that I have to pay.
 

A:excel 2010

Are you going to have Excel running at all times?

You can do it with VBA... but not sure it would make any sense or actually work, as Excel isn't generally running and I don't expect anyone to run VBA every day.
 

1 more replies
Answer Match 70.14%

Hi, my boss clicked on install upgrade to change to windows 10 everything is pretty much ok apart from all my excel spreadsheets. There are cells on each spreadsheet that wont print out the text in them. Only a few random ones here and there. In print preview they show the text there but when printing it doesnt show up. Anyone have any suggestions please
 

A:EXCEL 2010 HELP

That's weird! Have you tried resetting the print area?
 

3 more replies
Answer Match 70.14%

When I click on my Excel 2010 shortcut instead of Excel opening I get a Windows message asking if I want to allowthe Programme to make changes to my computer. If I click 'yes', Excel opens but with a blank blue screen in the working area instead of the normal grid. Likewise if I click on an Excel attachment in an email the same thing happens. To open an Excel document I have to go to the main Microsoft Office section in Programmes and click on Excel. This has only happened recently. Any ideas on the cause of the problem and on a solution?

Many thanks.
 

A:Excel 2010

Try System Restore - choose a restore date which precedes the date when the problem was first noticed.
Start >> All Programs >> Accessories >> System Tools >> System Restore
 

1 more replies
Answer Match 70.14%

I am ready to pull out my hair (and Ive already lost too much of it already). This virus/malaware is making my life miserable. I did a google search and saw many other people were also having the same problem which lead me to your website. Thank you for taking the time to assist me.I am using Windows XP and two days ago noticed the computer going VERY SLOWLY. So I rebooted thinking that would solve the problem and immediately got the aforementioned tell-tale warnings: Tracking software found! XP Internet Security 2010 Firewall Alert!Immediately I freaked out. I am using a laptop I was loaned by my friend as I am recovering from an accident and recently had surgery and am currently immobile. After some inspection I noticed he did not have his Firewall up, nor did he have anti-virus software running/installed or spyware software installed. My first thought was to pay the fee for what I have since discovered is bogus antivirus software. Since I am currently on disabilty this was not something I wanted to do, but after doing more research online I am so glad I didnt fall for this trap.So I immediately downloaded Avast home edition, and did a virus scan. It found several infected files which I removed. It asked me to restart saying there was something in the operating system. So I did another full system scan and Avast found a few more. I later used MalwareBytes Anti-Malaware which found a few more which I also removed. What a relief. I thought all was good. Until I woke u... Read more

A:XP Internet Security 2010/XP Guardian 2010 malaware

Hello and welcome to Bleeping ComputerWe apologize for the delay in responding to your request for help. Here at Bleeping Computer we get overwhelmed at times, and we are trying our best to keep up. Please note that your topic was not intentionally overlooked. Our mission is to help everyone in need, but sometimes it takes just a little longer to get to every request for help. No one is ignored here.If you have since resolved the original problem you were having, we would appreciate you letting us know. If not please perform the following steps below so we can have a look at the current condition of your machine. If you have not done so, include a clear description of the problems you're having, along with any steps you may have performed so far.Upon completing the steps below another staff member will review and take the steps necessary with you to get your machine back in working order clean and free of malware.If you have already posted a DDS log, please do so again, as your situation may have changed.Use the 'Add Reply' and add the new log to this thread.Thanks and again sorry for the delay.We need to see some information about what is happening in your machine. Please perform the following scan:Download DDS by sUBs from one of the following links. Save it to your desktop.DDS.scrDDS.pifDouble click on the DDS icon, allow it to run.A small box will open, with an explaination about the tool. No input is needed, the scan is running.Notepad will open with the results.Foll... Read more

3 more replies
Answer Match 70.14%

Hello,

My trouble started with a window called Home Antivirus 2010... (is this the same thing as PC Antispyware 2010 that is now sitting in the tray?).

I believe I have followed the instructions and successfully ran Avenger, and Malwarebytes to remove PC Antispyware 2010. Then I realized braviax was out there running and I ran SDFix in safemode followed by another scan and remove with Malewarebytes. It finds and remove the files (56), but doesn't seem to solve the problem. I've now run HJT and have the following log file:

Logfile of Trend Micro HijackThis v2.0.2
Scan saved at 8:47:54 PM, on 8/9/2009
Platform: Windows XP SP2 (WinNT 5.01.2600)
MSIE: Internet Explorer v7.00 (7.00.6000.16876)
Boot mode: Normal

Running processes:
C:\WINDOWS\System32\smss.exe
C:\WINDOWS\system32\winlogon.exe
C:\WINDOWS\system32\services.exe
C:\WINDOWS\system32\lsass.exe
C:\WINDOWS\system32\svchost.exe
C:\Program Files\Windows Defender\MsMpEng.exe
C:\WINDOWS\System32\svchost.exe
C:\Program Files\Common Files\Symantec Shared\ccSetMgr.exe
C:\Program Files\Common Files\Symantec Shared\ccEvtMgr.exe
C:\WINDOWS\system32\spoolsv.exe
C:\Program Files\Common Files\Apple\Mobile Device Support\bin\AppleMobileDeviceService.exe
c:\program files\mcafee.com\agent\mcdetect.exe
c:\PROGRA~1\mcafee.com\vso\mcshield.exe
c:\PROGRA~1\mcafee.com\agent\mctskshd.exe
C:\PROGRA~1\McAfee.com\PERSON~1\MpfService.exe
C:\PROGRA~1\McAfee\SPAMKI~1\MSKSrvr.exe
C:\Program Files\Norton Ghost\Agent\VProSvc.exe
C:\Program ... Read more

A:Braviax.exe / Home Antivirus 2010 / PC Antispyware 2010

Hi Welcome to TSG!!

Download ComboFix from one of these locations:

Link 1
Link 2

**Note: It is important that it is saved directly to your desktop**

--------------------------------------------------------------------

With malware infections being as they are today, it's strongly recommended to have the Windows Recovery Console pre-installed on your machine before doing any malware removal.

The Windows Recovery Console will allow you to boot up into a special recovery (repair) mode. This allows us to more easily help you should your computer have a problem after an attempted removal of malware. It is a simple procedure that will only take a few moments of your time.
Go to Microsoft's website => http://support.microsoft.com/kb/310994

Select the download that's appropriate for your Operating System


Download the file & save it as it's originally named.
Disable your AntiVirus and AntiSpyware applications, usually via a right click on the System Tray icon. They may otherwise interfere with our tools.

Please note once you start ComboFix you should not click anywhere on the ComboFix window as it can cause the program to stall.

Drag the setup package onto ComboFix.exe and drop it.

Follow the prompts to start ComboFix and when prompted, agree to the End-User License Agreement to install the Microsoft Recovery Console.

At the next prompt, click 'Yes' to run the full ComboFix scan.

When the tool is finished, it will pr... Read more

3 more replies
Answer Match 70.14%

Quote:
If all goes according to plan, Mozilla might release no less than three versions of its open source browser in 2010, culminating with Firefox 4.0. The next major version of Firefox is scheduled for general availability by the end of 2010. Of course, this is nothing more than a preliminary estimate of the delivery deadline for Firefox 4.0, and an optimistic one at best. The fact of the matter is that, Firefox 4.0 could also slip into early 2011, which would leave just two releases of the browser in 2010, namely 3.6 and 3.7.

At the start of this week, the number of Firefox 3.6 Beta Testers was approximately 600,000, but expected to lower over the holidays. Mozilla shipped the fifth Beta build last week, introducing more than 130 fixes over Beta 4. Firefox 3.6 Beta 5 is currently available for download for early adopters. At the same time, the company is laboring to produce the first Release Candidate of Firefox 3.6. In this regard, testers could be getting their hands on Firefox 3.6 RC by year?s end, although this development milestone could also slip into 2010.


Source -
Firefox 4.0 Beta in mid-2010, Final in Late 2010 - Early 2011 at the latest - Softpedia

A:Firefox 4.0 Beta in mid-2010, Final in Late 2010.

I want 3.7!! It's got that new look!

3 more replies
Answer Match 69.3%

Hi I have had office 2010 installed for about 2 months now but on a regular basis when I am working in Excel I am unable to save the document. When I select save or saveas nothing happens and when I close the document I am asked if I want to save and again if I select yes nothing happens. Currently my only workaround is to email the document to myself.

How can I go about reporting this to Microsoft or find a patch for this bug?

Regards,
DP

A:Excel 2010 not saving.

Have you installed the latest updates for Office 2010?

9 more replies
Answer Match 69.3%

Attached is a excel spreadsheet. What I have been working on is a formula that would do the following; If sheet1 A2=sheet2 A2 and sheet1 C2=sheet2 C2 then copy sheet1 to sheet 2 for that row from D to J.

Hope I have explained it well enough.

Thanks,

Derald
 

A:Excel 2010 Formulas

7 more replies
Answer Match 69.3%

I have a workbook with codes and dates in it that I updated with new codes and dates as needed.

Others use other workbooks that use the same codes and dates, but they have to manually update the new codes and dates when I enter them.

Is there a way for one excel workbook to look at another and add the new information?

I know that there are many other ways to do this through access or other programs, but we are using excel and will not be upgrading anytime soon.

Any help would be great.

Thank you very much.
 

More replies
Answer Match 69.3%

Hi There,

What I have is a spreadsheet with several sheets. I have created a summary sheet that I want to pull all the active information out if it meets a certain criteria.

I have the formula's put together so that it pulls the info correctly, but I need to know how to format the page so that it auto sizes the number of rows shown. I did it once before abotu 4 years ago.. but I can't figure it anymore.

I hope I'm explaining myself well. but here is a second go just in case. The formula to pull the data from each sheet is placed on the entire sheet (so that when that cell is populated the summary sheet will update) but I don't want the summary sheet to show hundreds of empty cells until they meet the criteria, I'd like it to only increase what you can see when they are populated. Thank you!!!
 

A:Solved: Excel Help 2010

7 more replies
Answer Match 69.3%

placing formula in c4 -=IF(AND(B2="CST",D2=2%),"CST FORM 'C' DUE",IF(AND(B2="CST",D2=14.5%),"",IF(AND(B2="",D2=""),"CST FORM 'H' DUE"))) ORIF(D2=2%, "CST FORM 'C' DUE", IF(D2="", "CST FORM 'H' DUE", IF(B2="CST",??)))format cell: b2 & c4 "general" and d2 "%"pls. send solution at: soalram - email removed by moderatoredited by moderator: Email address removed

A:not working in excel 2010

Please do not post email addresses in this forum. We do not want to become known as forum where email addresses can be harvested. Once the bad guys start hanging around, it is very hard to get rid of them.I have edited your post to remove your email address.All answers should be posted to the forum for all to share.Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

2 more replies
Answer Match 69.3%

Hi
I am looking a a workbook containing survey data for a building. The data is organised by floors/rooms.
I want to use a pull down menu to allow users to pick the room they want to look at and then a macro which copies that information into the text filter function.
This works well with static text, but I need help with making this work with text changing depending on the choice made from the pull down menu

Any help greatly appreciated

PG
 

A:Excel 2010 Macros

Hi,

Welcome to the forum.
It would help if you provide a copy of your workbook.
 

1 more replies
Answer Match 69.3%

'
' SavePrint Macro
' Macro recorded 8/1/96 by RON
'
'
Sub SaveAndPrint()
ActiveWorkbook.Save
ActiveSheet.Unprotect
ActiveWindow.FreezePanes = False
Range("A1:AZ5500").Select
Selection.Copy
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Application.CutCopyMode = False
ActiveSheet.PageSetup.PrintArea = "$B$2:$L$38"
With ActiveSheet.PageSetup
.PrintTitleRows = "$42:$44"
.PrintTitleColumns = ""
.LeftHeader = ""
.CenterHeader = ""
.RightHeader = ""
.LeftFooter = ""
.CenterFooter = ""
.RightFooter = ""
.LeftMargin = Application.InchesToPoints(0.25)
.RightMargin = Application.InchesToPoints(0.25)
.TopMargin = Application.InchesToPoints(0.25)
.BottomMargin = Application.InchesToPoints(0.25)
.HeaderMargin = Application.InchesToPoints(0)
.FooterMargin = Application.InchesToPoints(0)
.PrintHeadings = False
.PrintGridlines = False
.PrintComments = xlPrintNoComments
.CenterHorizontally = True
.CenterVertically = False
.Orientation = xlLandscape
.Draft = False
.PaperSize = xlPaperLetter
.BlackAndWhite = True
.Zoom = 80
.FitToPagesWide = 1
.FitToPagesTall = 50
ActiveWindow.SelectedSheets.PrintOut Copies:=1
End With
Application.Goto Reference:="R2503C2"
ActiveCell.NoteText Text:="temp", Start:=1
Range("A45:N2503").Select
Selection.Sort Key1:=Range("A45"), Order1:=xlAscending, Hea... Read more

More replies