How to delete stuck file from "All Junk e-mail" Box ?
How to delete stuck file from "All Junk e-mail" Box ?
I'm using WLM on Win7. Thanks for any help.
"Jdr" <firstname.lastname@example.org> wrote in message
> How to delete stuck file from "All Junk e-mail" Box ?
> I'm using WLM on Win7. Thanks for any help.
try dragging it to the deleted folder.
"c.d." <email@example.com> wrote in message
> "Jdr" <firstname.lastname@example.org> wrote in message
> news:C29193...CRM 4 and SQL upgrade
I have a CRM 3 installation on a SQL 2000 box which is also the CRM app
Planning for the CRM 4 upgrade, I have a new physical server with SQL 2005
What is my most efficient upgrade path?
I think you can do the following:
1. Move the CRM 3.0 database to SQL 2005.
2. Point the CRM 3.0 application to the new database server. (There's
documentations on how to move database to a new server on the
3. Install/Upgrade CRM 3.0 to CRM 4.0 on the CRM 3.0 application
I think this is the fastest and easiest in my opinion.
Darren Liu, Microsof...AVERAGE function returns #DIV/0! error
I used AVERAGE function in my spreasheet and received #DIV/0! error from it.
Is there a safe proof way to omit the invalid values out of the average
Try this. I assumed your range was A1:A10, change this to fit your data.
Enter this formula by using CTRL+SHIFT+ENTER as it is an array formula:
> I used AVERAGE function in my spreasheet and received #DIV/0! error from it.
> Is there a safe proof way to omit the invalid values out of the average
social security number has 7 numbers. However, when I type
0454636, 0 will be gone.
Ex: Type 0454636. It will become 454636.
I have almost 8 columns stored social security numbers.
Please show me how to fix the problem.
Try format cells -- custom and type 0000000 in the box.
>social security number has 7 numbers. However, when I
>0454636, 0 will be gone.
>Ex: Type 0454636. It will become 454636.
>I have almost 8 columns stored social security numbers.
>Please show me how to fix the prob...Pivot Tables #4
When I double click to drill down to the supporting data
in a pivot table, the data is displayed on a new tab
within the workbook. Then to close that data, I have to
delete the tab.
1) Is there a faster way to view then close the data
without having to delete a tab every time?
2) If I leave the new sheet open, is it linked to the
pivot table? In other words, if I refresh the pivot
table, will the data on the new sheet be automatically
refreshed as well?
#1. I don't think so. But maybe you could apply Data|filter|autofilter to the
original da...Out of Memory #4
I have an application that is used by over 8000 users worldwide. There
are several that are reporting an "out of memory" problem using one of
the functions in the tool. One user just received a brand new laptop
(T41) and is now encountering this error. It was working on their old
laptop. The function that they are trying to run when they get this
problem opens up another excel spreadsheet and then selects sheets from
the first spreadsheet and then copies it into the second spreadsheet.
It goes through a loop and does this for each sheet. It is only
copying the values and forma...IMO Recover Deleted Mail Items
Any way to recover a file containing mail items deleted to
the Deleted Items Folder then deleted by emptying the
Deleted Items Folder?
No - if you don't have a backup of your PST file, they're gone, sorry.
> Any way to recover a file containing mail items deleted to
> the Deleted Items Folder then deleted by emptying the
> Deleted Items Folder?
No. Not unless you use Exchange server.
[MVP - Outlook]
Author: Absolute Beginners Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Optio...SystemParametersInfo(SPI_GETWORKAREA,0,&o_Rect,0);
Im trying to make my GUI controls monitor display format settings
independant. I put a CButton control on the so called "work area"
I do :
x = o_Rect.Width ();
y = o_Rect.Height ();
o_Verwijderen.MoveWindow(10,(int)(y * 0.82),o_Rect.Width
My CButton is called o_Verwijderen and i put it on 82% of the y ...? about 2007 deleted folder
My Deleted Items folder contains deleted emails as well as deleted calerndar
items, tasks, et c. How can I arrange my folders so that only deleted
emails go into the Deleted Items folder and the other deletes go elsewhere?
Anything you delete goes to the deleted ITEMS folder - where do you want
them to go?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
ALWAYS post your Outlook version.
How to ask a question: http://support.microsoft.com/KB/555375
After furious head scratching, Markb asked:
| My Deleted Items folder con...great palins 8.0 us payroll
can i see a traning demo session on us payroll 8.0
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
having trouble finding the proper spreadsheet for windowsXP...I HAVE A XLS FILE TO OPEN, anyone used a spreadsheet, that could direct me? Thank you
Windows XP is an operating system. You also need to have a version of
Excel as well.
Norman Harker MVP (Excel)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"rick" <email@example.com> wrote in message
> having trouble finding the prop...Prevent others from deleting worksheets
I'm on a system using Windows XP with several user accounts. It's
possible to share a document by putting it in a directory called,
unsurprisingly, "Shared files' or somesuch. Anyway, I wish to put one
of my Excel spreadsheets into this directory so that other users can
The workbook itself has about 10 worksheets and I want other people to
be able to edit only one of them. So I used the "Protect Worksheet"
option within Excel to protect those worksheets I don't want edited.
However, I notice that it's still possible to delete a worksheet even
thoug...2007 print merge 4 postcards/4 different addresses per page
I have read the previous posts regarding this issue. I cannot resolve my
I have created a 1/4 page postcard. Information on page one and successfully
merged addresses on page two. I only have one postcard on my screen and as I
scroll through, I see all the correct information in the merge.
I am having trouble printing the merge. I want 4 postcards on one 8 1/2x11
piece of cardstock. One side with the same information and the other side
with four different addresses from my merge. I am getting side one with
information and side two with four duplicated addresses. The second pi...delivery restrictions #4
I have a mailbox that is used only to receive fax attachemnts emails from a
service that a phone company provides us.
I want to allow only emails coming from this domain
(*@voicemail.telepacific.net) to be allowed in this mailbox.
How can I chieve this? The delivery restrictions area allows only specifying
internal addresses but the address I want to allow is external.
On Thu, 10 Aug 2006 19:28:32 -0700, "Perecli Manole"
>I have a mailbox that is used only to receive fax attachemnts emails from a
>service that a phone...Great Plains 8.0 Macro
I am trying to learn how to write different Macros in GP. I recently
mastered the old "Mail Merge" and I would like to take it one step further.
Is it possible to add an "IF, Then..." statement to the macro? Sometimes when
changing Standard Pricing a Pop-Up Box Appears and Other Times it doesn't, so
I would like the macro to see if it's there and click OK, otherwise, just go
on to the next thing.
Second, I would like to be able to write the results to a log file. For
example, a Part Number goes through add it to the log file with an OK,
another ...Error 4.4.7 -
We are not able to deliver mail from our Exchange 2003
server (part of SBS) to certain domain names including
hotmail.com, microsoft.com and msn.com. Here is the
messages that we get.
First message from Exchange..
This is an automatically generated Delivery Status
THIS IS A WARNING MESSAGE ONLY.
YOU DO NOT NEED TO RESEND YOUR MESSAGE.
Delivery to the following recipients has been delayed.
Contents of attached text message (ATT04044.txt.) sample.
Final-Recipient: rfc822;Gary.Megson@fds...record of marking messages unread?
Is there anything w/in Outlook or Exchange (running OL2003 & EX2003)
that keeps a record of when somebody marks a message as unread?
For example: I have a delegate on my mailbox, she can read my emails,
reply to them etc... if she reads one of my messages and marks it as
unread, is there anything w/in Outlook (or Exchange) that would record
such an event? The only thing that I can think of that even comes
close would be the event 1016 that records when somebody accesses my
mailbox but is not the primary user on the mailbox.
My gut feeling is that there's no way to record this type ...please help #4
Please guys I really need some help with this, I'm at my witts end.
We are using sbs server 2000 with exchange. If and email is sent to one of
our users say firstname.lastname@example.org with an other address in either the to/
cc/bbc fields, say email@example.com. Exchange is routing the
same email from the orgianator (spoofed) to the second address. so that the
other address recieves two copies as if from the original sender, but it
your servers that are send it out.
Now I'm asssuming this is a relay problem, but can not find any why of
Your help would be greatly ap...NDR 4.4.6?
I get the following error when attempting to send to a particular DL.
A configuration error in the e-mail system caused the message to bounce
between two servers or to be forwarded between two recipients. Contact your
How do I check the possibility of looping?
Do the users in the DL have forwarding turned on within their mail
properties in AD?
"pscottlee" <firstname.lastname@example.org> wrote in message
>I get the following error when attempting to send to a particu...Using Fintech with GP 9.0
We are going to be using Fintech to pay for alcohol purchases via EFT, has
anyone discovered an easy way to set up EFT vendors? all I can find info on
in the help file is European EFT.
Open one of the EFT setup windows and click on the Help button within
the window. The correct EFT help will open.
Frank Hamelly, MCP-GP
NOVA Solutions LLC
...Changing user business units = authentication error in CRM3.0
When we change a business unit for a user (and assign the appropriate
roles�) the user is unable to signon to CRM. The user is signed off of
crm before we change the BU. We have had them reboot and try to sign
on and cannot. They get an error which indicates the user is unable to
authenticate. When we do an IISReset on the CRM server the user is
then able to signon to the new BU and everything works fine. This is a
problem because we do not want to kick everyone off the server every
time someone changes business units. Please help�
Remember when you change a BU, their security roles get dro...deleting worksheets from names in a range
Is there anyway to delete worksheets via code where one worksheet contains a
range with the names of the tabs on the worksheets I want to delete?
i.e., Sheet 1 has a range that has the values, A, B, C.
These are the names on tabs for 3 worksheets. I want to have code that says
"delete worksheets with the tabs named A, B, C.
Let me know if you need more info.
Application.DisplayAlaerts = False
For i = 1 To Cells(Rows.Count,"A").End(xlUp).Row
On Error Resume Next
no se me instala el excel, ser� la versi�n antigua que no me deja?
...10.1.4 can't find an installation???
I have Office X SR-1 installed, and whenever I try to upgrade to the 10.1.4
(Exchange update), the installer fails telling me it can't find a valid
installation to upgrade. Office is located in the Applications folder of my
hard drive and is a legal copy, so I don't know why it won't install?
Thanks in advance!
On 10/3/03 8:35 PM, in article BBA3B855.28Eemail@example.com,
"Mailinglists" <firstname.lastname@example.org> wrote:
> I have Office X SR-1 installed, and whenever I try to upgrade to the 10.1.4
> (Exchange update), the installer fails tel...column width #4
I thought it would be much easier but I can't set column widths from VB
After lot of trouble I find out that ColumnWidth is not what I need, i
sets width in characters not in pixels. How can I set width in pixels
I need full synta
AFAIK the width property is read-only. So you can only use ColumnWidth
> I thought it would be much easier but I can't set column widths from
> VB. After lot of trouble I find out that ColumnWidth is not what I
> need, it sets width in characters not in pix...