Access/Excel 97 Macro Error -After Upgrading to Win2000 Pro
i call Excel 97 from Access97 to perform a data export to Excel.
since upgrading to Win2000, if the macro is ran as Administrator, then no
when run by a user with only Domain User rights..
the macro still runs but it brings up the DNS Data Source screen...
the user then must select MS Access driver from the list....
and enter 'Admin' in the user name...
if this is done, the Excel sheet is created ok..!
if not, the sheet is still created but with no data attached..!!
Function LeadsToExcel...Spell Check Error Message
I have a user that gets the message "Error occurred while
checking Spelling" when trying to spell check an email
message. This is the only message she gets. Spell check
works fine in Word.
Thanks for your assistance.
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...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",
&qu...deleted database in error in sql
We deleted the TWO database by mistake through SQL. I have made some changes
in TWO and have a backup.
Can I simply create the TWO database again through sql and restore the
backup? Will this work?
Yes, just create a new database called TWO, and then restore the database and
you should be fine.
"Jack Tundra" wrote:
> We deleted the TWO database by mistake through SQL. I have made some changes
> in TWO and have a backup.
> Can I simply create the TWO database again through sql and restore the
> backup? Will this work?
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...Trying to apply rule fails with error
A user that has in the past, now can't apply a workflow rule to a record
(Specifically a lead). The following error is displayed, "You do not have
sufficient access rights or privileges to perform this action." I've looked
through all the roles and find nothing that should be preventing the user,
and she used to be able to do this same task. It started happening the day or
so after I applied Service Pack 1 for Windows Server 2003.
Any one else seeing this behavior or have any ideas?
I've seen something similar(ish). Have you had the user login from a
d...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...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...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" <email@example.com>
>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....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" <firstname.lastname@example.org> 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)
...Recover messages after crash
I'm using XP and OExp. I would be most grateful if
someone can tell me how to retrieve my email messages and
address book from the most recent CD backup I made of the
computer before it crashed. Is there a way to copy some
files from the CD to the computer now that I have re-
installed windows and Outlook Express?
...SQL Server Connection Problem Error when using Org Mass Assign
I am trying to assign accounts based on a segment and I'm getting the
A SQL Server connection problem has occurred. Please try your operation
again when the server is less busy.
It worked on the other segments. Has anyone seen this? Thanks
...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:
...duplicate messages #5
When I hit send/receive to get my new messages they arrive in duplicates.
How can I change this?
Do you have any rules set up?
"Cindy" <Cindy@discussions.microsoft.com> wrote in message
> When I hit send/receive to get my new messages they arrive in duplicates.
> How can I change this?
Here are some things to look for that can cause duplicates.
1) Two or more accounts that check the same mailbox.
2) Two or more inbox rules that act on the same message.
3) Antivirus/Antispam software that doesn...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...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...How do I copy outgoing messages to another person
I would like to copy all outgoing messages (To:) to my colleague in the
office. Is this possible in MS Outlook and how do I configure this please?
You should be able to use the Rules Wizard to do this for you.
"Hazel" <Hazel@discussions.microsoft.com> wrote in message
> I would like to copy all outgoing messages (To:) to my colleague in the
> office. Is this possible in MS Outlook and how do I configure this please?
...Outlook Express Error Message Since Installing XP SP2
Since installing XP Service Pack 2, Outlook Express will not download my
family's Hotmail accounts.
The error message is displayed below.
Have deleted accounts and re introduced them, have uninstalled Outlook
Express and Re loaded it, have added it to the Exceptions section in the New
Windows Firewall Utility and all to no avail.
What have I overlooked?
User name: email@example.com
David Wh...error in excel #2
I when I try to open document in excel I keep getting
a "cannot use object linking and embedding" error and I
can't open the program.
Did this just start happening? If yes, were you hit by the MSBlast worm?
One poster (Lutz Meyer) guessed that this was the cause of his problems. I
haven't seen any confirmation/denial, but you may want to read his post:
Post back with your results. I'm curious if that was the problem. (It's come
up quite a few times since MSBlast hit.)
Je...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...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...