I'd like to know if there someone has written a RMS report that shows the
customer account number, customer's name (last, first), and other customer
statistics that INCLUDE pieces purchased and pieces returned.
Or, if someone with more knowledge of SQL would care to share their coding
expertise to accomplish the same, it would be appreciated.
...Return-Path: <> from Postmater
I got Exchange 2003 SP1 on Windows 2003 in Native Mode and when I receive
bad mail the response is made from email@example.com but the
return-path field is blank. With some anti-spam filter this Email is Junk.
Anybody know how to specifeid a return-path to the NDR mail?
On Fri, 4 Nov 2005 12:48:04 -0800, "Sebas"
>I got Exchange 2003 SP1 on Windows 2003 in Native Mode and when I receive
>bad mail the response is made from firstname.lastname@example.org...Is there a way to color code Outlook Contact File Folder Labels?
Is there a way to color code Outlook Contact File Folder Labels?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Join OneNote Tips mailing list: http://www.onenote-tips.net/
"isailhbca" <email@example.com> wrote in message
>...Recovering a publisher file from its .tmp file
I am not familiar with Publisher 2002 and its workings. One of my bosses was
creating a company news letter and while inserting, rather large, pictures
she crashed and it saved all the work as a .tmp.
I tried renaming the file to a .pub with no avail.
I am primarily interested in recovering the text.
Any hints or suggestions would be greatly apprieciated!
Try Open, files of type, scroll down to "recover text from any file" and browse to
Mary Sauer MS MVP
"Jim&quo...Editing Package Files
I have a VBA modified report that I need to distribute to users. Our report
dictionary is shared on the network but the VBA code needs to be installed
Could I take the package I created, install it once to update the shared
reports dic then edit the package and delete out the report modifications
part? That would leave the VBA update part to install on the clients.
Does this sound feasible?
that sounds like a lot of work for no particular reason.
the vba and dictionary changes know where they should go. so there
shouldn't be any reason you canno...links to excel file question
I have a hyperlink in an Outlook 2000 email that links to
a Microsoft Excel 2000 file that contains vba code. The
Excel program generates the error however it's based on
how the link is handled in Outlook.
When I click the link through the preview window in
Outlook everything works fine. The link looks like this -
When I open the email (i.e. view the email in it's own
window) and then click the link I get the runtime error in
excel. The link display look likes this - \\sfna-fs4
\hrs\shared\ctm trai...SaveAs wk3 file type error message
I'm trying to convert an Excel worksheet to a Lotus 123, wk3, file format.
I've had to use Excel 2003 as Excel 2007 no longer appears to offer the Lotus
123 file formats. When I do the SaveAs command in Excel 2003 an error is
generated saying "You are attempting to save a file type that is blocked by
your registry policy setting."
Does anyone know a workaround for this issue?
Error message when you try to save a file in Excel 2007 or in Excel
2003: "You are attempting to save a file that is blocked by your
registry policy setting"
http://s...Site for SOP Returns
Is it possible to have a different default Site ID for Returns than Standard
Yes. You must make sure to change the site when performing a Return
Richard L. Whaley
Author / Consultant / MVP 2006-2008
Documentation for Software Users
Get our Free Tips and Tricks Newsletter and check out our books at
"Everton Raymond" wrote:
> Is it possible to have a different default Site ID for Returns than Standard
Sorry, I did not see the word "default" in your post until after I r...I need help with VBA and a CSV file output
I am using Excel 2003 in XP Pro.
I am trying to export/saveas one tab from a workbook that contains one tab
and one column of data into a CSV file.
My data is in column A in multiple rows and looks like the following on each
I have everything working fine except for one large issue, excel adds " "
to the begining and end of each cell of data and looks like the following:
These quotes are an issue for what this file will be us...Query regarding A,B,C char. width values returned in 16-bit and 32-bit OS
I am trying to retrieve individual character widths of a string
(from a TrueType font) and I tried using GetCharWidth (which weirdly
works for TrueType fonts too tho' MSDN says otherwise) and/or
GetCharABCWidths to retrieve the A,B and C spacings. Please
note that I have selected the TrueType font (hFont) into the Device
I used GetCharABCWidths. Problem is this: GetCharABCWidths returns
correct A,B and C widths in Win 98 and incorrect (much lesser A,B and
C widths such that the characters OVERLAP) in other 32-bit OS (NT,
The effect is seen across all TrueType fonts, th...Starting Excel from file
Can anyone help?
I've just started getting a problem loading excel from a
It starts just fine from the start menu etc. and I can
open files from
However, if I click on (say) an excel file icon in My
Documents or on one of
my saved icons on the desktop then Excel loads fine but
NOT the file!!
This is really frustrating as it means I have to go
through the process of
loading excel separately every time I wish to use it.
I Use Office XP + Windows XP PRO.
I have done a system restore to before the problem
occurred - no luck.
I have completely uninstalled Office...Outlook 2002 and file attachments
I am unable to receive any file attachments in Outlook.
They are all blocked. How does one go about changing the
default settings to allow the attachments to come
through. I have a firewall and virus protection to stop
any problem files.
See if the information on the following page helps:
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***
> I am unable t...Transferring Outlook Files to New Computer
Just bought a new Dell laptop with XP Professional. How
do I transfer my old Outlook files including address book
from Outlook 2000 to new computer Outlook 2000?
On Sun, 03 Aug 2003 17:26:15 GMT,"Jay F." <firstname.lastname@example.org> penned
this whopper in news:email@example.com:
> Just bought a new Dell laptop with XP Professional. How
> do I transfer my old Outlook files including address book
> from Outlook 2000 to new computer Outlook 2000?
File > Import/Export > export to .PST personnal folders file. Move that to
new machine and impo...Report for Returns
Anyone know a why to report on frequency of customer returns -- so we can see
if any customers are making habit of this?
Thanks and regards,
Try running a detailed sales report filtered to only negative sales
"hitman" <firstname.lastname@example.org> wrote in message
> Anyone know a why to report on frequency of customer returns -- so we can
> if any customers are making habit of this?
> Thanks and regards,
...Store the full path and document name in a hyperlink
I need to create an Access database to track a number of documents
that are created and stored during the tendering process. I have
created a number of tables with hyperlink fields that will store the
information eg Tender proposal document (a Word doc); Tender budget
document (an Excel book) and company profiles (pdf) from companies
submitting tenders. To create the hyperlink to each of these
documents in the form, at the moment I right click, choose Hyperlink,
Edit Hyperlink and navigate to the required document and select it.
The path and filename is then stored in the field, which is ...Returning the Beginning of the week
Returning the beginning of the week.
e.g. if the date == 02/03/04 (Friday 2nd March 2004)
the beginning week for that date == 01/03/04 (Thursday 1st March 2004)
Hows does one go about achieving this?
Rizitsu's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=15840
View this thread: http://www.excelforum.com/showthread.php?threadid=314968
This formula will take a date in cell A1 and give the start of the wee
* assumes that monday is the start of the week, so i...Export Table Records to txt file
Hi all, I have Table "T_Data" in my database. In "T_Data" I have
220000 records. I need to export them into txt files. I need some
kind of macro which should export chunk of 60000 records into one txt
file and save that file in folder called "Data" on "C:\" drive. Macro
should also put numbers at the end of each txt file name. Like (See
I'll be very greatful if any friend can help me on this as I am
struggling on this.
...you cannot save to this file format when the VBA project is protected
How can we abe to save the worksheet and at the same time still able to
protect the VBA project coding for viewing ? This development is just like
creating a Template with many macros programming and you do not want the
users go into the project and modify your programs.
It can be done before, why in Excel Visual Basic version 6.3 when you
protect the project for viewing , you workbook can not be saved any more,
unless you unprotect your project coding ?
Your kind solution at this matter is greatly appreciated.
Message posted via http://www.officekb.com
This is n...Large file size in Excel
I've got a worksheet that is blank, and the Ctrl-End key combination jumps to cell A1. I originally pasted 5 colums by 138 rows of data into this spreadsheet, then erased the columns completely by using 'Ctrl+-'. I've also selected the entire sheet and used Edit->Clear All. All this to no avail. I have an empty spreadsheet that takes up 900 KB, but zips to 30 KB
Any suggestions on how to reduce the file size is welcome.
"Jon" <email@example.com> wrote in message
> I've g...RESCUE PST.FILE OL2000
This is a multi-part message in MIME format.
I need to repair/reinstall XP but want to rescue the pst.file on the =
C-disk. The Hard disk is now a slave on another computer but I'm not =
allowed access to DOC/RICHARD/APPL/MS/OL.=20
Is this because it had a password on the user ??
<!DOCTYPE HT...File Names
What is the name of the Sent file in Outlook. I
accidently deleted it and want to retrieve it.
There is no file specifically for a Sent item. All data is stored in a
pst-file. Is it no longer in your Deleted Items folder?
Microsoft Office and Microsoft Office related News
Also Outlook FAQ, How To's, Downloads and more...
Tips of the month:
-Create your own fully customized Toolbar
-Creating a Classic View in Outlook 2003
Subscribe to the newsletter to receive news and tips & tricks in your
(I changed my reply add...xpath
I'm using the following xpath in .net
to test if there is a Board element with NO "finish" attribute.
If there is, I need to get the @title of the WI element...but haven't
been able to figure it out yet (and yes, I do user XpathVisualizer!).
Also, how can I test if the above xpath results in no/null nodeset? It
doesn't seem to work for me unless I first set an attribute.value
string to test (e.g., Dim unfinished As String =
n1.Attributes.GetNamedItem("start").Va...Converter failed to save file
I've recently installed Office 2007 Enterprise package and can no longer read
pdf files either directly from a web site or in an email from another PC.
There seem to be several references to this issue on Google but no-one seems
to have a definitive answer.
Can anyone help please?
A. T. Hen
Do you get an error message? If so, what does it say *exactly*?
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Attila the Hen" <AttilatheHen@discussions.microsoft.com> wrote in message
news:A...Alpha sort names/numericals
I have 2 columns. 1st column has names, 2nd has numerical values relevant to
the names. How can this data be alpha sorted and keep the same name/numerical
"dane" <firstname.lastname@example.org> wrote in message
> I have 2 columns. 1st column has names, 2nd has numerical values relevant
> the names. How can this data be alpha sorted and keep the same
Please state clearly what the problem is.
If you sorted and got the names sorted and the numbers did not...return
Capability of the system to automatically change the status of the PO to
change order, and add line items that have been returned.
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.