Merging Two Office Data Files
This is a multi-part message in MIME format.
Here is the situation:
I've a desktop and a laptop. Before I bought the laptop I was using MS =
Outlook on my desktop. Now that I'm using my laptop mostly, I would like =
to have my old emails from my desktop Outlook merged with the laptop =
Outlook emails. I don't want to replace the laptop outlook files with =
the desktop outlook files is the folder - C:\Documents and =
Settings\Laptop\Lo...Linking files 2 ways
I have a work book that is linked to another and vise versa.
Workbook A is where the input of data is made;
Workbook B has a link to the input from workbook A;
Workbook A retrieves the altered data back as a link.
Although this all works fine with both books open, I note that if I open
workbook A by itself, that the data it retrieves from Workbook B is not
updated . If However, both books are open, there's no problem. I thought
linked books were updated automatically if the Update remote references has
been selected?? But it appears that the second book is not updated until it
...OL2007 not move big files from outbox to sent
We have 2 computers with separate email accounts on Roadrunner. One machine
has XP with Outlook 2002-sp3 and works without any problems. The other has
Outlook 2007 on Vista and has problems sending files over a meg or so in
size. It seems to actually send the file but the file remains in the
outbox folder and does not move it to the sent folder. I say it "seems" to
send the file because some people complain of getting muliple copies and
others don't seem to get them at all. If I hit send again (not set up for
auto send) it seems to send the file again (why some ...Using Relative path for XML data file?
Is there a way to specify a relative path to an XML data file imported into
Excel 2003? I am writing a web app that generates report data as XML for the
user to download to their local machine. This data is to be consumed by an
Excel reporting spreadsheet, which contains display-formatted tables and
charts that are mapped to various data fields in an XML Map, which is in turn
linked to the xml data file they will download.
The idea is the user only needs to download the data for updates, not the
whole spreadsheet. However, since I cannot predict the path where the user
will store their...How to repair a .dll file in IE8
Several days ago I noticed in my Dependency Walker that the IESHIMS.dll files
has a yellow circle with a question mark on it. What does this mean and How
do I repair it?
OS: Windows Vista Home Premium
Browser Internet Explorer 8
See the History tab on that dialog.
A web search for ieshims.dll files will also help you find a solution for
"TW" <TW@discussions.microsoft.com> wrote in message
> Several days ago I noticed in my Dependency Walker that the IESHIMS....unsolicited entry in the folder "Temporary Internet Files"
I am working on a programme which browses web sites and runs under XP.
The http download is as follows:
pServer = Isession -> GetHttpConnection(strServerName, nPort);
pFile = pServer->OpenRequest(CHttpConnection::HTTP_VERB_GET,
strObject, NULL, 1, NULL, NULL, dwHttpRequestFlags);
if(dwStatusCode == 200)
pFile -> QueryInfo(HTTP_QUERY_LAST_MODIFIED, &sysT);
status.lastMod = sysT;
if(DBlastMod == status.lastMod) //URL content has not changed
since the last visit
...RMS V2 and QSC Import
I have successfully imported several of my customers products using the QSC
Import tool as a test but am unable to import the items with any association
with sales tax? The default Sales Tax is TAX which is what I plan on using
but once imported it creates a new item code TAX so now I have two? I plan on
importing several hundred products and any help would be much appreciated.
i use the same tool but i dont tell the import utility anything about tax.
import the items witho...Maximum file sizes
Is there a recommended maximum file size for Excel 2000.
PC spec 2Ghz P4 with 256 Mb
Any advice appreciated
Does Not Exist
have a look at
"Deus DNE" <email@example.com> schrieb im Newsbeitrag
> Is there a recommended maximum file size for Excel 2000.
> PC spec 2Ghz P4 with 256 Mb
> Any advice appreciated
> Does Not Exist
...find action on log file
I want to use outside tool to find who made some update on table in my
I know that there are many tools for this. But can they do it on simple
Roy Goldhammer (firstname.lastname@example.org) writes:
> I want to use outside tool to find who made some update on table in my
> I know that there are many tools for this. But can they do it on simple
> recovery model?
No. If you are using the simple recovery model, the contents of the
log is wasted away everyonce in a while.
Well, if the disk area has not been overwritten...File size #11
I have read the other discussions on file sizes but they do not seem to
address my problem.
I have an Excel file that is 12mb large with low-res jpegs in it. This file
also has merged cells to make it look pretty. Does Excel look at these merged
cells as graphics? Is this why they are too big? I have run a macro to make
sure that it goes to the last cell.
How can I get the file smaller?
How big are the graphics? If you remove them from the file, what is the size
of the file and what is the size of the graphic files?
To be sure you do not have extra formatting, if you open the file...More Columns #2
I am using all columns through IV on one of my
worksheets. Does anyone know how to get more columns?
know way using Excel. this is the maximum!
Stacy Haskins wrote:
> I am using all columns through IV on one of my
> worksheets. Does anyone know how to get more columns?
As Frank said, that's the maximum cols
But maybe you could try transposing your table / data ?
(Excel has a lot more rows than columns)
If so, try: http://tinyurl.com/2nmyy
for an example on using TRANSPOSE()
For a one-time Tranpose:
Copy > Paste Specia...Offline Synchronization Problem #2
I get the following error when I try going offline. The excelption is taken
from Event Viewer of the Client Machine.
Event Type: Error
Event Source: MSCRMOfflineSync
Event Category: None
Event ID: 6000
Time: 5:03:33 PM
An error occurred during Offline Synchronization. Try going offline again,
or restart Microsoft Outlook. saInsert failed for entity
'ActivityMimeAttachment', batchRows=0 with exception System.FormatException:
Index (zero based) must be greater than or equal to zero and less than the
size of the argument li...CSV Files and VLOOKUP error
Does anyone know why VLOOKUP and Compare formulas don't work o
information originating from a CSV file? I've tried copying an
pasting values only (to leave behind any formatting), but it doesn'
Through countless tests, I've narrowed it down to the CSV file bein
the only possible cause
Message posted from http://www.ExcelForum.com
Just a guess but the imported data may have leading or trailing spaces or
are numbers stored as text. You could use the formula =A1=D1 to see if you
get a true or false, where A1 is the lookup value and D1 ia the CVS valu...Contacts in Exchange #2
We are running Exchange 2003 and Outlook 2003. I have tried to give a user
rights to her boss's contacts through delegation and setting the rights on
the contacts folder, however, while she has the rights she is unable to add
or see her boss's contact folder in her Outlook. She can see it if she runs
a search, but can not permanently put it in her list of contact folders. IS
there a way that I can accomplish this through the back-end?
...Goal Seek #2
Can anyone tell me a little about goal seek?
basically it's used to change an input variable so that the result of the
formula equals what you want it to ...
say i have the following
A B C
1 10 20 =A1+B1
now C1 will give me 30, but if i want to know what B1 will need to be if i
want C1 to show 50, i can use goal seek
Set C1 to value of 50 by changing B1
Hope this helps
"Jamie Hart" <email@example.com> wrote in message
> Can a...How do I Remove a Split from my Comments in Excel 2003? #2
I have set my current workbook to split/freeze the first column and first 2
rows. Now, when I add a comment to the second row (in any column) my comments
are cut off if I should scroll down.
I don't ever remember the behavior before. And I don't know what I've done
to enable it but it's really annoying.
How do turn this off ?
...How to automate increasing the form cache registry/file etc...
I want to roll out a batch file to make a number of tweaks to CRM
The body of it would go
REGEDIT /S Kerberosefix.reg
REGEDIT /S ForceFormreload.reg
REGEDIT /S OutlookFix.reg
It would also rename OSA.exe to OSA.bad
Remove OSA.exe From the startup menu
I need help finding a way to use my batch file to increase the Outlook
Form cache from the default 4MB to 50 MB.. This makes CRm more stable
and faster for communications. I dont want to manually do this, as it
time consuming, are my end users would not be reliable in doing it
I also want to make another batch file or button that...Is anyone an expert with outlook that I can call on the phone?
How do I share calenders between outlook and my MSN Premier account?
Assuming you are using the outlook connector, you need to set the msn
account to be the default message store then outlook will use the msn
calendar as the default.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
You can access this...Help with importing data
Can I have users fill in a form in Access and have that data be transferred
and updated to a spreadsheet. Need for fill out several fields and then
export to a specific spreadsheet and place that data into the cells that will
update that cell (add to the total in that cell) of a spreadsheet.
...Increment A2 from A1 and A2 Sum #2
I have two cells:
A1 - manual value
B1 - automatic increment = B1 + A1
How can i make it?
(=error: circular reference)
Note: I have this formula repeated in some lines:
= B2 + A2
= B3 + A3
Message posted from http://www.ExcelForum.com
...Can I share entities in migration process?
The entities in CRM have only one owning user. If I want=20
who a user see a entity of another user, the entity must=20
be shared with this user.=20
Well, I want migrate entities who must be shared with some=20
users. Exists a way to do it?
Thank you for pay attention and sorry my bad english.
Vin=EDcius Pitta Lima de Ara=FAjo
...Can't do adjustment in analytical accounting
I am trying to change an analytical assignmnet through the Edit
Analysis. When I try and change it, I receive an error stating "The
Code of this Transaction Dimension cannot be adjusted". Has anyone
seen this before? I have done similar changes many times, but I don't
know why I can't now. Any insight would be helpful.
What version of Gp are you running? I haveseen this happen in 8 but one of
the service packs fixed it. (I think it was SP 4 or 5)
> I am trying to change an analytical assignmnet through the Edit
>...ERROR: 5.1.2 or other punctuation after the recipient's email address.
I am trying to send a email to a group address I created with 58 addresses
When I try to send the email to this group I get the following Error:
"5.1.2 or other punctuation after the recipient's email address. "
I have gone back to the original contact cards and made sure the addresses
were all legal.
I have re-created the list, same problem
I have re-booted, same thing.
Any thoughts out there?
My wife and I have MBP's and are both running MS Office for Mac's, Entourage
Both of us have messages cued up in the out boxes th...How to import images from Publisher into Picture Manager?
I have images in Publisher that I need to import in to Microsoft office
picture manager. How do I do this?
Find the source of those images and save them.
MVP Microsoft [Publisher]
wrote in message news:B1B1DFC9-0639-49BA-8614-A5AC0DDB596D@microsoft.com...
>I have images in Publisher that I need to import in to Microsoft office
> picture manager. How do I do this?
Right-click the picture, save as picture, or copy/paste to a folder. The Picture
Manager will search for al...form base authentication #2
This is killing me. I'm implementing form base authentication. I have SSL
and everything working but for one problem
when use won't to get to owa they type mail.domain.com which then defaults
the problem I'm having is that FBA need it to default to https not http.
How can I get it to default to HTTPS with out telling the uses to type
I am implementing this on a FE/BE environment
What I do is change the http port on the main site to something like 8080,
and then create a new site that listens on 80. For that site, instead of...