Crystal Reports add on to HR software
Here's the situation, i am currently working on a HR system, the report
writer within the system is totally useless, and can not be used to
write reports. Crystal reports has been provided, as a starting point
i am trying to extract data from the system thorugh Crystal, I have
connected to the file.ddf of the data ont eh system, and have to hand a
dictionary containing what is held within the fields.
My question is i have printed off basic reports within Crystal, however
when i print the report it gives me mulitple records for memebers of
staff, is there a formula or am i doing ...e-mail #3
I am using Publisher 2007 and and new to using it. I have a newsletter
(11"X17" with some graphics) that I print and mail bi-monthly. Is there any
way I can create the same file into an e-mail in Outlook or Outlook Express?
Any Ideas or suggestions for using other programs instead of those mentioned
2007 Microsoft Office Add-in: Microsoft Save as PDF or XPS
Mary Sauer MSFT MVP
In plain english the formula above means: Sum cells E1 to E500 (last
argument) if in B1 to B500 the value is "March" and if in C1 to C500
the value is "New York".
SUMPRODUCT is like SUMIF on steroids and it allows you to automate all
these reports that you develop with data that you import from a large
centralized database, centralized accounting, manufacturing and sales
programs or the Internet.
The last argument (preceded by a comma) tells Excel what to...e
...Word Mail merge lables from .xls document
Office 2000 Windows XP Pro: I am trying to create Avery 8160 lables in WORD
form an Excel database. . My sequence in WORD is as follows. Tools>Mail
Merge>Create Main Document>Mailing Lables> Active Window>Get Data>Open Data
Source. When I get to into folder that contains the .xls file the only files
listed in that folder are WORD files. When I click on the File Type drop down
menu at the botton of the OPEN DATA SOURCE window, the only options I have
are "All Word Documents", "Word documents", "Web pages", "Rich text format",
I am making a mailing list of customers addresses. I own a pizzeria and at
the end of the night I take the order slips and type the addresses of
customers who ordered that day into microsoft word. After a few weeks of
doing this I am getting a lot of repeats. How do I avoid this?
If you're doing it in Word, make each address its own paragraph,
select all the paragraphs, and choose Sort (Word2007: Home tab;
Word2003 and earlier, Table menu [they don't need to be in a table]).
Then when you want to add a new one, just go to where it would fit in
and see if it's alrea...Information from table to report.
I recently created a report using a query. The query draws its information
from a table. One of the field in the table has a drop down box with the
options "Yes" and "No". If the option "yes" is selected, it shows on the
table and in the corresponding query. However, it does not appear in the
report. There appears to be a blank in the report where the work "Yes" is
meant to be. I tried deleting the field from the report and adding it again,
anf i also tried moving it around on the report to make sure it was not
hidden. But that did not help. What ...i dont no how to send a mail could u plz tell me wot to click on
What do you mean by "send a mail" ?
Could you please keep the subjects brief and explain what you would like in
as much details as possible please
> help plzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzzz
...How do I block messages from one particular e-mail adress?
I dont want to receive e-mails from one certain adress. Is it possible to
block those messages?
yes. right click an email from them, Junk mail, add to junk senders list
Are you sick of bad email practice? Get a copy of my paper "Implementing
Email Policy" from the Desk Doctors website.
"Marco" <Marco@discussions.microsoft.com> wrote in message
>I dont want to receive e-mails from one certain adress. Is it...out look mail
How do I get my out look mail back to my schools imail accout?
On Thu, 22 Apr 2010 14:08:29 -0700, "Donna" <firstname.lastname@example.org>
>How do I get my out look mail back to my schools imail accout?
Ask your school email administrator. Nobody on this volunteer-staffed
technical support forum for Microsoft Access databases will be able to help
You'll also want to change your email address; it's now been published to tens
of thousands of computers worldwide, and spammers and junk mailers can and
will harvest it to send you SPAM....How to forward mail from internalmail to external address?
I have internal is email@example.com and want to forward this address to firstname.lastname@example.org in MS-Exchange2003. How can i do?
Ask your Exchange administrator to set up a mail-enabled contact for your
hotmail account, and use alternate delivery/delivery options on the
email@example.com mailbox to send a copy of all inbound mail to the
Mark Thailand wrote:
> I have internal is firstname.lastname@example.org and want to forward this address
> to email@example.com in MS-Exchange2003. How can i do?
Mark Thailand <firstname.lastname@example.org> wrote:
> I have internal is user@mydomai...Auto-response e-mail: Generate auto-response e-mail to
How to set-up next feature
Auto-response e-mail: Generate auto-response e-mail to
customer requests. (MS CRM Overview from MBS site)
I have not seen an auto-response feature in CRM.
"ed" <email@example.com> wrote in message
> How to set-up next feature
> Auto-response e-mail: Generate auto-response e-mail to
> customer requests. (MS CRM Overview from MBS site)
...Attachments in a mail merge document
I am trying to do an e-mail merge from Microsoft word. I
have been successful with just formatted text. I would
like to however, send an attachment along with these
I have tried various methods to achieve this, but have
not been successful. Can someone please point me in the
Is Outlook 2002 (XP) capable of doing an e-mail merge
No. You would have to use a 3rd party mass mailing program if you need to
send attachments. Look here for a list of possible programs:
...URGENT: Mail access issues
I am having a problem logging into my Outlook mail
account on my laptop. I get the following error:
"Your logon information was incorrect. Check your
username and domain, then type your password again. If
your account is new or if your administrator requested a
password change you need to click Change Password then
logon with your new password."
Seems like a straight-forward message, but here is the
problem. I can access my mail account when logging on to
the client's desktop computer. I should be able to logon
to this account from my laptop, just like my co...Report on select general ledger accounts, that are not sequential.
There are many time when we need to review specific general ledger accounts.
These accounts are not necessarily in sequential order, therefore we have to
print much more than is needed or may separate reports.
It would be helpful if a detail/summary trial balance report could be
generated, using some type selection criteria other than account
number,segment or date.
Example: We have multiple general ledgers that relate to mortgages. These
accounts can be income, expense, assets, etc. They cover a large range of
general ledger numbers. I'd like to pull all accounts related to mort...A program is trying to automatically send e-mail on your behalf...
I'm using Outlook 2002 and a UK Accounts package called Sage. This package
allows me to send invoices via email.
Everytime I send an email I have to wait 5 seconds before I can click YES,
and if I have a lot of invoices to send, this does take quite some time. Is
there a way to "override" this setting so that it sends them automatically
without asking me? I know the security reasons why this feature is there,
its just a hinderance thats all. I do have uptodate virus checking on my
emails that will hopefully catch worm viruses trying to send without my
Anyway, I h...P L E A S E
Please, could someone help me with "DLL (Resource)" post (some 25 posts
below this post). Please.
"Jan Plastenjak" <firstname.lastname@example.org> wrote in message
> Please, could someone help me with "DLL (Resource)" post (some 25
> below this post). Please.
I'm to search through the newsgroup looking for find your post?
I don't think so...
I have already answered your post, let me repeat it:
"If you go to www.microsoft.com and enter the fo...How do you sort 2 date fields in assending order (query or report)
I have 2 DOB fields (client and spouse) in a table that I currently print off
the birth month and call them on their b-day. I really wish I could figure
out how to get them to print/display in assending order of date (ie: 11/1
followed by 11/2) even if the spouse is before the client. Is this possible
without having to do a bunch of programming? Thanks!
Yep. Use a calculated field like this --
DOB_Sort: IIF([Client_DOB]<[Spouse_DOB], [Client_DOB], [Spouse_DOB])
Build a little, test a little.
> I have 2 DOB fiel...E-Mail Printing Problem
I posted this problem 6 or 8 months ago and have not yet seen a solution.
The problem is on certain emails (Schwab Confirms as an Example) about 1" of
the right side of the email is cropped. I documented and reported the
problem to MSFT and
someone from MSFT replied that they were aware of the issue and were working
on it. That was many many months ago. The problem is/was not printer
dependent or operating system dependant - just Internet Explorer and/or
Windows Live Mail. It was apparent at that time that other people were
experiencing the same problem. Is anyone aware...New Mail Desktop Shortcut
Is there a desktop shortcut for creating a new mail message (running Windows
XP)? In Windows 2000 there was a shortcut bar with a new mail message icon
on it. I'm wondering if there's something similar in XP?
Rob D. <RobD@discussions.microsoft.com> wrote:
> Is there a desktop shortcut for creating a new mail message (running
> Windows XP)? In Windows 2000 there was a shortcut bar with a new
> mail message icon on it. I'm wondering if there's something similar
> in XP?
It's easy enough to make one. Open Outlook and search for "command line&qu...Unable to send via windows mail
Hi everyone, I am having trouble sending via windows mail, one day it was
working and then for some reason it doesnt. I can still received email but
unable to send. I have all correct settings, I have deleted accunt and re
installed account, changed port settings as requested and still get the same
error. which is the following
The message could not be sent. The authentication setting might not be
correct for your outgoing e-mail [SMTP] server. For help solving this
problem, go to Help, search for "Troubleshoot Windows Mail", and read the
"I'm having problems ..."Send to Mail Recipient" icon not working
As you know, in Excel you there is an icon on the Toolbar for "Send to Mail
Recipient". For some reason, my icon does not appear. When I select Tools >
Customize > Select and drag the Mail Recipient icon to the toolbar, as soon
as I close the customize menu box the icon I just dragged to the toolbar
disappears. When I click on the little arrow at the end of the toolbar, I do
not see it listed under the Customize area (to check or uncheck). Anyone
know why this may be happening and how I can get the icon to stay in the
Also, if I go under File > Send To, ...auto e-mail checking
I was wondering if someone out there could tell me if
there's a way to check for e-mail automatically. What I
mean by this is that I would not have to be "clicking"
send/receive, each time that I need to check for new e-
Thanks in advance.
Tools > Options > Internet E-mail. Check my local network for
connections(s) for new mail every ____ minutes. You may also want to check
the auto dial button if you're not always online.
"Rudy" <email@example.com> wrote in message
news:firstname.lastname@example.org...E-mail Router doesnt get E-mail from Exchange
I've setup CRM with Exchange E-mail Router successfully until I did either 1
of the following.
1. Disabling E-mail user
2. Change server IP address
3. Installing RAS
Does anyone of the above affects Exchange E-mail Router? If not, may i know
whether is there any place where i can configure Exchange E-mail Router?
Last solution, do you think reinstalling Exchange E-mail Router will help?
Any help appreciated.
Thanks a lot!!
ReadySpace Network Pte Ltd
Is there a way to print a POSTNET barcode on a Publisher
document? More specificly, I'm mail merging an address
list to a publisher document, and want to add a barcode
to each page. Is there a way to do this (you can do it
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from AlphrettaRealtor <AlpharettaRealtor@hotmail.com>...
> Is there a way to print a POSTNET barcode on a Publisher
> document? More specificly, I'm mail merging an address
> list to a publisher document, and want to add a barcode
> to each page. Is t...