Is this do-able?
A user has created a 'select' query in MS Access.
1/ runs the query (the user is prompted for an 'end' date / filter)
2/ switches to 'pivot table view'
3/ exports to MS Excel
We would love to do this in one step.
* I know how to link to external data in MS Excel, and could then refresh
the raw data in Excel. However, the number of lines in my resulting
spreadsheet varies so my pivot table would have to be recreated or the range
reset, I believe.
Thank you for any ideas.
(** Is there a better newsgroup to post thi...How can set up Excel to be able to print checks?
I wish to be able to build a template so I can print checks from an excel
This file might be a help:
It's in the "Accountants" section on page:
It contains the "SPELLNUMBER" function, which can be used in your
spreadsheets, two methods to convert numbers to words and two cheque
The code is open and commented.
Andy Wiggins FCCA
Excel, Access and VBA Consultancy
"catherine" <catherine@discussio...Getting an instance from RUNTIME_CLASS
A line of code:
CRuntimeClass* prt = RUNTIME_CLASS(FlamingoListView)
Does this actually create an instance of the FlamingoListView class? If so,
then how do I get a pointer to my new instance? The only operations and
variables available through the *prt don't seem to help!
> A line of code:
> CRuntimeClass* prt = RUNTIME_CLASS(FlamingoListView)
> Does this actually create an instance of the FlamingoListView class? If so,
> then how do I get a pointer to my new instance? The only operations and
> variables available through the *prt don...Deleted emails #4
When I delete an email that was not opened from my inbox it goes to the
deleted items folder. When I delete an email that I read it permanently
deletes the email without going to the deleted folder just as if I held down
the shift key when deleting. I cannot find a switch to turn this on or off.
Check your View settings. Make sure it is set to show all Messages.
> When I delete an email that was not opened from my inbox it goes to the
> deleted items folder. When I delete an email that I read it permanently
> deletes the email without going to the dele...Email quotes
This sound quite simple but I can't seem to find this?
Where and how does one email an quote out of CRM directly to the client or
opportunity if it is activated?
You can do this with Workflow.
"Warren O'Reilly" <email@example.com> wrote in message
> This sound quite simple but I can't seem to find this?
> Where and how does one email an quote out of CRM directly to the client or
> opportunity if it is activated?
...Interstore Transfers getting lost
We have the problem that sometimes a HQ generated Interstore Transfer gets
lost- So the Receiving store has the Tranfer but the issuing does not. They
also do not show up in the HQ E´vent Log. Any idea?
RMS Distribution Europe
We've encountered similiar problems with Interstore Transfers generated at
the local stores. Our problem was related to the fact that our Inventory
transfer order numbers exceed the 14-character limit.
The transfer order number field actually accomodates more than 14
characters, but RMS appends additional characters in the backend. ...PL2 : Tracking who opened an email
We have an Exchange 2003 server. One of our users have noticed that their
emails are being read whilst out of the office. Nobody has access to her
It seems that somebody is accessing her mailbox with her login details. We
can easily change her password, but want to track down who is viewing her
We did a test and logged out of Outlook. 30 minutes later Exchange system
manager showed she logged back in and logged off again. Does the message
tracking log store IP addresses when emails are opened?
I'm sure that there are commercial (3rd party...How do I setup my email account using comcast.net?
Please tell me how to setup Microsoft Outlook using comcast.
See if this info helps:
"AQZWyf" <AQZWyf@discussions.microsoft.com> wrote in message
> Please tell me how to setup Microsoft Outlook using comcast.
"AQZWyf" <AQZWyf@discussions.microsoft.com> wrote in message
> Please tell me how to setup Microsoft Outlook using comcast.
Call Comcast....Allow only email send privileges to only certain domains for a gro
How would I configure our Exchange 2003 system to only allow email
communications with the domain and to only select external domains for a
large group of users?
For example...we are abc.com. All abc.com users should be able to send and
receive to one another only. A smaller group needs this same restriction,
but needs to be able to email def.com occasionally as well. def.com is not
associated to abc.com.
Use SMTP connectors:
"CasinoSA" <CasinoSA@discussions.microsoft.com...ITK ... how can I get it?
How can I get the Implementation ToolKit?
Course 8018 refers to the ITK as methodology and templates in CRM deployment
Thanks in advance.
It's on the partner site, if you have access go to:
You can download it there from a link at the bottom of the article.
> How can I get the Implementation ToolKit?
> Course 8018 refers to the ITK as methodology and templates in CRM deployment
> Thanks in advance....Email from Excel
Hi. Can someone please tell me how I can set up emailing function in Excel?
I use Excel 97 and Win XP. I used to be able to go to File, then Send To,
then Mail Recipient and it would open up my "New Mail" window from the email
client that I use which is IncrediMail and it would automatically attach my
spreadsheet for mailing. All I had to do then was type in the email address
of the recipient. I reformatted my computer this weekend and now when I go
to File, Send To, Mail Recipient all I get is a box open up that says "Choose
Profile" that in the drop-down field...Export emails...
I have a bunch of emails from my customers that need to
be exported to be imported onto another computer....Can I
do this?? I have all of the emails that I need to export
in one folder....
Okay, this is pretty easy if you are using Outlook 2002 (XP), I don't know
for sure about other versions but I think its close to the same process.
Click (in the folder list) to highlight the mail folder in the to be
exported. Then click on "File" (menu tool bar), then choose "import and
The export wizard will open. Then pick the top one; "export...winxp not able to join domain
hi! recently, i've some issues in a small grp of clients about 5% of the
total 1000 PCs. We're not able to join these PCs into our win2003 domain.
I've to rename the PCs before i can join to the domain. I've checked in the
AD, the computer name is not there and all the dns, gateway and etc are
correct. I didn't see any related msg in event viewer as well.
for some of these pcs i've to re-join the domain for the user to login again.
has anyone encouter this before? pls advise. thx
Are the machines created from a not sysprepped image? Did...how do I get the ampersand character back?
I'm parsing an XML file with XMLDocument, each node I write to SQL server.
Sometimes values in the XML have to contain an ampersand, so they are in the
XML as & obviously.
I assumed the .net framework took care of converting & back to &
But I'm wrong in that assumption.
For every & in the XML I receive
in the SQL Server data.
What am I needing to do to restore that & character?
As far as I know, when you load the Xml data into the XmlDocument class,
the & will be converted to &...how to get Corresponding cell value
I have 2 cols displaying name and work done like
Col A Col B
If a user input Col B value in an InputBox then
how should I get corresponding cell value?
thanks in advance
johnbest's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2969
View this thread: http://www.excelforum.com/showthread.php?threadid=49605
If you do Data > Filter > AutoFilter, and select 20 from the dropdown arrow
at the top of column B, it will filt...Recovering Deleted Emails
I found the option in Outlook 2003 where a user can recover deleted email for
a specified period of time (determined by setting on Exchange server).
However, is there a way an administrator can view all deleted emails for all
users? Maybe something via a web browser directly on the Exchange server? We
don't really have a need to restore the emails from the Exchange server but
we would like to review emails that users are deleting without having to log
into their workstation and recover the emails then delete them again. Any
I think does not support this
Ja...Getting the current date/time
I'm trying to access a date field of a particular database and the code
generated by MFC defines the date variable as "DATE".
I believe this DATE referes to COleDateTime and I don't know how to get the
current date/time to populate this field.
I'm tried the following already, but none of these worked:
----------- Example 1 -----------
test = COleDateTime::GetCurrentTime()
VC says that COleDateTime is not defined.
----------- Example 2 -----------
test = ::GetCurrentTime()
-------------------------------...Transferring email account from Outlook Express to Outlook
I have transferred by main BT email account from OE to Outlook with no
difficulty. However, a subsidiary account that I use will not be accessed.
I have added it to the accounts list and checked all settings. I have
removed it from Outlook Express. When I run the Test Account option, all
seems well, but when I send a message to myself at that account it appears to
send successfully, but cannot be received.
What SMTP server are you sending through? Primary or secondary?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. ...When I click on the tabs, I get a page icon and all is stuck
I was just asked to help a lady in the office, that I helped copy a
excel file from one computer to her computer. I was able to open the
file and as soon as I tried to click on the tabs (sheets) on the bottom,
the mouse pointer had a little page attached to it, and everything was
frozen. I hope one of you wonderful experts out here can help me with
this problem. BTW, when I tried to x out of the file, I got a whatever
the European sign is for not enter, I know I'm not good as describing
the problem, maybe one of you is a mindreader as well.Many many thanks
When ...Email Subprocess failing
I have a Workflow Rule that will kick off a common email based on case
status. However, what I have found is that executing a subprocess to send
the email does not work or pauses. If you find it paused, and refresh, no
email is sent. Changed the Exec subprocess to Send Email and the rule is
running fine. I would like to know if sending emails in a subprocess is a
problem or just is not supposed to work?
Sending email in a subprocess works fine in my experience
Check error logs to provide more info
"Alice C" <AliceC@discussions.microsoft.com> wrote in message
news:5...outlook classifying ALL emails as junk and moving to delete
How do i change this?
...get rid of file winmail.dat
Every time I send an email, MS Outlook always inserts the
following attachment file to my outgoing email:
Does anyone know how to get rid of this action from MS
I woud appreciate if you and forward the answer to my
Thank you very much !
You're using RTF formatted messages - change it to plain text or HTML and
you should lose the winmail.dat files. Look in tools, options, mail format.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickS...should be able to print ATP
I would like to be able to print out the Available to Promise information.
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.
http://www.microsoft.com/Businesssolutions/Community/NewsGroups/dgbrowser/en-us/default.mspx?mid=2d089892-1a1b-4a8a-9e3e-16757d015fff&dg=micros...Business Cards--Getting Started, Office 2003
How do I get started with business cards? I have a MS Press Office 97 book,
and see nothing about Publisher. Was it dropped from 2007?
I'd like to design my own. Roughly, it looks like:
.... about my
Wayne Watson (Watson Adventures, Prop., Nevada City, CA)
(121.015 Deg. W, 39.262 Deg. N) GMT-8 hr std. time)
Obz Site: 39� 15' 7" N, 121� 2' 32" W, 2700 feet
Solid waste produced to generate electricity per person
...Getting Meeting invites
I have a small question that someone may have run into...
I have different users that on different occations have created a meeting
and invted folks and sent out the meeting. On a few of the occations someone
who was not on the invite list or within any of the groups that were invited,
gets an invite. I went through the invite but couldn't see what would cause
this person to get invited. Has someone run into somthing like this before?
There could be several reasons for this. I'll name a few off the top of my
1) One of the invitees has someone else as a delegate...