Excel as a database #3
is there any possibility that i used to print a invoice through excel for my
product sale. is there any way excel can generate monthly sales book as a
Please show me any path
Thanks in advance.
Rao Ratan Singh
Consider Access for this project. To do this properly, you'll likely need a
table for your products (your inventory or product line), one for your
invoices, one for the items in your invoices, and if you're keeping customer
information, one for your customers. Excel is terrific, but a lot of darn
work to implement related tables, move records around, ...Outlook Inbox running tally of e-mails in it
HELP ! This should be simple for someone but not me. I
used to have a number on the left side of my screen when
in my in-box that would tell me the total number of e-
mails in my inbox (normally around 200-300). This was not
JUST the new ones which are reflected on the folders
line. It was at the bottom of the page and would change
immediately if I deleted or added one.
I lost the number and want it back. How do I do that?
Thanks for any help anyone can give !
view - status bar
"Suzanne" <email@example.com> wrote in message
news:0bb901c3deda$1...Exchange 2003 smtp queues e-mail delay outbound mails
Our exchange server is creating several smtp queues whit not valid e-mails
I tested our server, and is not a relay problem.
The outbound mails should be enable or not ?
On Fri, 6 Jan 2006 00:01:02 -0800, Rui <Rui@discussions.microsoft.com>
>Our exchange server is creating several smtp queues whit not valid e-mails
>I tested our server, and is not a relay problem.
>The outbound mails should be enable or not ?
They will be attempts at NDR's back to non existent senders following
incoming spam m...#REF #3
I'm doing a projection spreadsheet. The new months in diff sheets will be
added as and when the actual month passes, ie, up to now i have sheets up to
Aug. But in the MAIN sheet, I'm supposed to have months for the whole year up
to Dec. Since Sep to Dec don't have equivalent sheets yet, the cells show
#Ref since my formula is =Oct!A1.
I want to tell the cell to get the amount from "Oct" sheet if there's such a
sheet and if not, get the amount from "Sep" sheet. I tried this
"=if(Oct!A1="#REF", Sep!A1,Oct!A1)" but it doesn'...Beginner
I am a beginner to databeses, and particulary to MS Access 2003. (althought I
passed the first lessons)
I want to make a small database with possibility to grow up. (max. 100
entries for a table)
I think that in my case the data must be structured like loop into loop.
So for every Year it must exist some Power Plants, and for every Power Plant
it must exist some Generators.
I already have ma...new mail notification in 2003
I just upgraded to Outlook 2003 and I no longer recieve new mail notification unless the message is in my Inbox. In previous versions you would get notifications as long as the folder the message went to was a sub folder of Inbox. Any ideas?
This is by design. In your rules that you have setup to move messages from
your Inbox to other folders, you can add "display a desktop alert" for each
of those rules.
Author, Special Edition Using Microsoft Outlook 2003
***Please post all replies to the newsgroups***
"Brian" ...Attachments in e-mail sent to many users
I am trying to find out how to send an e-mail attachment to a lot of
different contacts in CRM 3.0. We were told there was a way but the
instructions don't work. The e-mail goes to all the receipents but no
attachment is every sent. Can someone please give me directions on how this
...mail que not sending
the exchange 2003 server has messages banking up in its out going queues.
E-mails to external addresses are not sending. they are just sitting in the
wue and constantly retrying.
Ee-mails sent to internal e-mail adresses are working fine.
what would be causing this? how do i get the messages to send again as they
How does your system send outbound email to the internet?
Could be one of a few things, have you checked DNS, Internet Connectivity?
Can you telnet to port 25 on the email systems which outbound messages are
Are there any NDR's and what do the...Cannot send mail using either port 25 or 587
I don't understand why this has only recently been happening but I cannot
send mail using smtp in ol 2003.
I am trying to send using my Yahoo account but the send receive says that it
is sending messages that are not actually in the outbox, e.g (bottom rh
corner of screen sending 2 of 3 messages when there are no messages there to
send) then after a short while it says error send receive.
My ISP is BT and apparently they block port 25 so I changed the port
settings (as recommended by Yahoo) to port 587 but I still cannot send from
I have configured my e mail accou...how do i verify my e-mail address?
PLEASE HELP ME VERIFY MY E-MAIL ADDRESS?
And by verify you mean?
"AMANDA" <AMANDA @discussions.microsoft.com> wrote in message
> PLEASE HELP ME VERIFY MY E-MAIL ADDRESS?
Send an email to yourself? If it leaves your outbox and later on arrives in
your inbox, everthing should be OK?
Hope that answers your question.
"AMANDA" <AMANDA @discussions.microsoft.com> wrote in message
> PLEASE HELP ME VERIFY MY E-MAIL ADDRESS?
Start a...Saving messages other than in formats given? i.e., rtf or pdf (html with complete pictures)
I get a lot of mail from yahoo groups, in particular some graphics
groups. In it, I get very good tutorials or tips which involve
graphics that explain or illustrate the text.
O2K allows me to save as text or html, but the pictures get left out
of both formats, of course.
The text can be converted to rtf and I can pull the graphics via the
Outlook script to save embedded graphics and I can manually create the
rtf file; or I can open up the html file, and reference the pulled
embedded graphics, but both methods have proven very time-consuming
considering the number of messages I recv that I ...can't find how to confirm e mail address
i am new to e mail and am having trouble confirming my e mail address
Outlook can't really help in that effort. What provider are you using for
"newcomer" <firstname.lastname@example.org> wrote in message
>i am new to e mail and am having trouble confirming my e mail address
...Out of Memory #3
As a spreadsheet grows, I'm beginning to have occasional "Out of Memory"
problems while doing "Paste" operations. Grumble, grumble....
Digging into the problem a bit, I find the INFO statement tells me that
I have roughly 50MB available to Excel and that most of it is used up.
My question is simply whether there's anything that I can do to increase
that 50MB gross amount before I tinker with how Excel is actually using
it in the spreadsheet?
1) Would it make any difference if I changed from Excel97 to the current
version? Or does the same 50MB limit exist ...How do I stop saving attachments with sent mail?
I have many >5 Mb attachments in my sent mail and archive sent mail
folders. As I understand it there is no facility to afterwards strip
the attachment but keep the mail.
So how do I change my Outlook 2003 settings so that I do not save the
attachment when sending mail?
To strip the attachment open the message from your Sent Items folder
rightclick the attachment and choose Remove. Save and close the message.
Robert Sparnaaij [MVP-Outlook]
Tips of the month:
-Navigation Pane Tips & Tricks
-Create an Office 2003 CD slipstreamed with Se...Broke mail
Whats causing this ?
only thing in the event viewer is
Event Type: Warning
Event Source: Marc3Host
Event Category: None
Event ID: 6204
Plugin DSScheduler reports exception.
Data Sources: Builder failed.
Additional info: Could not resolve url
For more information, see Help and Support Center at
been trying to remove a 2007 server but its infected everything it seems
Marc3Host? What's that? You've probably got something else installed on
the Exchange server....more problems with windows mail
I changed the port # for outgoing mail and it works.... but now I can't
receive anything in the windows mail account. I have 1 new mail if I go
directly to AOL but it doesn't come up in Windows. What do I do?
Thanks again, Dave N9 for your previous help.
Do you get an error message when you try to receive? If so,
right-click on your error message, copy, then paste it into a reply here.
We can't do much troubleshooting without the complete error message.
Gary VanderMolen, Microsoft MVP (Mail)
"ms" wrote in message news:39477D36-4145-45C1-B652-526E471313...401k Account Missing
In Money 2005,I have a 401k account that shows up in my portfolo but on the
Account List under Investment Accounts, just the name shows up and no
balance. I can't print a report for this account (it will not show up on the
list) or include this account in my lifetime planner.
When I go into Change account settings, the retirement box is checked, under
budget the "Include this account in the budget planner" is checked. The "use
this account for budgeted savings goals" is not checked and the system will
not let me check it.
I have repaired the file just to make ...Change Headers That Exchange Uses To Deliver Mail?
When someone sends a BCC mail to recipients in my domain, the TO: header
field is blank and as a result, the message is getting dumped into my
badmail and a copy is going to the postmaster in my domain.
It turns out that our ISP has some kind of SPAM filter that parses the BCC
content prior to delivery to me and places the intended recipients in a new
Is there a way to tell my exchange server to use the contents of that new
header to determine the recipients in addition to the normal TO: header
which works the rest of the time?
So, have it check TO: and X...want certain junk mail to auto go into junk folder
want to receive certain mail but have it automatically go into my junk folder
instead of having to move it manually after I've already read it. Want
Outlook to recognize the sender and put it in junk.
> want to receive certain mail but have it automatically go into my junk folder
> instead of having to move it manually after I've already read it. Want
> Outlook to recognize the sender and put it in junk.
What Outlook can do depends on which version you are using but didn't bother
You could use the Blocked Senders blacklist....Error When Creating E-mail Message
I posted this earlier and never got an answer..
I updated the windows updates for Office and ever since
have been getting an error message when I attempt to
create a new email message.
A program is trying to access e-mail addresses you have
stored in Outlook, Do you want to allow this?
If this is unexpected, it may be a virus and you should
Allow access for x minute (in box)
I have done the following:
1. Checked for a virus. I don't have any.
2. I have re-installed office over top of itself. That
...How do I make sure an e-mail is deleted from my computer?
vickbrk509 <email@example.com> wrote:
Always provide a description of your configuration, including Outlook
version, when posting.
If you want to delete a message, select it and click or prfess Delete. Then
empty the Deleted Items folder. Was that really too hard to figure out?>\
Brian Tillman [MVP-Outlook]
...Gift Cards #3
I am looking to create gift cards. Cards that customers can buy as gifts, add
any amount of credit on them. I would like wither bar code or magnetic
swipe. Is this possible to do without having to use the cervice of an
outside company (beyond making the cards)?
Yes it is called vouchers. Built in to RMS can be used with barcodes as well
as mag stripe.
"Willie" <Willie@discussions.microsoft.com> wrote in message
>I am looking to create gift cards. Cards that customers can buy as gifts,
> any amoun...Upgrading CRM 3.0 from SQL 2000 to SQL 2005
We are planning to upgrade CRM 3 to CRM 4 but currently our CRM 3 runs on
SQL 2000 and according to the upgrade path CRM4 requires SQL 2005!
So, what is the process of upgrading SQL 2000 to SQL 2005 for CRM? I have
found the method of upgrading SQL itself whcih basically entails installing
2005 SQL then moving the 2000 databases to the 2005 instatnce, but will this
work OK for CRM as well? Are there any other steps/dependancies than need to
Thanks in advance (of a long night upgrading!)
Upgradation is SQL Server 2005 installation which will upgrade from SQL 200...Public folder for storing e-mail message
Exchange 2003 server, Outlook 2002 client. I want to set up a mail enabled public folder to store all e-mail addressed for customer support group. I also want to be able to forward e-mails from this public folder to an external address automatically. How do I set this up. Any help will be appreciated.
"Dipti" <firstname.lastname@example.org> wrote:
>Exchange 2003 server, Outlook 2002 client. I want to set up a mail enabled public folder to store all e-mail addressed for
> customer support group. I also want to be able to forward e-mails from this public fol...Mail server name
I have to migrate from Exchange 2000 (on windows 2000 server) to Exchange
2003 (windows 2003 server).
The new server has a differente name from the older.
The problem is that I have to change, in each client, the mail server name
Is there a way to update the Otlook client with the new server name ?
There's a tool available from MS, you can find it here:
hope it helps!
"Rod" <email@example.com> wrote in message ...