Using expression builder object
I'm developing a wizzard in Access which builds import templates for various
data sources to a fixed set of tables. In step 3 the users must be able to
build an expression ; for instance Left([Fieldx],20) . Now I would like to
have a command button on my form which calls the Access expression builder to
allow the users to use this to build the expression. This expression will
then be stored in a text box linked to the templates table.
Anybody know how to call and use this object from VBA code?
I th...Automatic Email Reply
I am going out of town and would like to have an
automatic email replied to all emails that are sent to
me. I know this can be done, but I just can not remember
how to do it.
Basically what it is, is when an email comes into my
address my outlook will automatically send them an email
back saying what ever I want it to.
Can anyone help me?????????????
What version of Outlook are you using? Note: this group does not support
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups.com...Exchange 2003 new install can not receive external email.
I have just setup a new Windows Server 2003 standard edition with
Exchange 2003 standard edition on it. I have been working for a while
trying to get it to receive external email. I can send out and send/
receive internal messages, but when someone trys to send me a message
from outside our network they get the following returned mail message
This Message was undeliverable due to the following reason:
Each of the following recipients was rejected by a remote mail
The reasons given by the server are included to help you determine
each recipient was rejected.
Recipient: <**...Recieve Mail Before Sending
How do I set up Outlook 2003 to recieve mail before sending
Set your send/receive group settings to receive and not send. Or are you
talking about setting authentication?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups.com and finding no answer:
Keith <firstname.lastname@example.org> asked:
| How do I set up Outlook 2003 to recieve mail before sending
...Can I send a recurring e-mail automatically each week
I want to send a e-mail with the same verbiage to the same person once a week
and make it a recurrence with no end date. Can I set this up once in Outlook
so it is scheduled automatically?
Microsoft Office 2003 Version
Students and Teachers Edition
Windows Vista Home Premium
Happy new Year!!
...Crash on 'Send"
My wife's Intel Celeron running ME started having this problem
sporadically - now constantly.
Outlook 2000 receives OK - everything seems fine until you hit the 'Send'
button then Outlook crashes giving an error message that says 'Outlook has
caused an error in <unknown> and has to shut down. If the problem persists
you may have to restart your computer.'
Re-starting however has no effect.
I have re-installed Office. Used 'Detect & Repair' under the 'Help' tab, and
installed all patches/updates from the Office site. But this error
continues, now...Hdtv Receiver Tuner
Channel Master CM-7000 Digital to Analog TV Converter Box
Best deal: http://bestdealfinder.us/index.php?id=B000XQTDR2
Elgato Systems 10020974 EyeTV Hybrid TV Tuner Stick for Analog, HDTV and FM Radio Reception
Best deal: http://bestdealfinder.us/index.php?id=B001QCYHXM
Hauppauge 1192 WinTV HVR-1950 External USB HDTV Tuner/Video Recorder
Best deal: http://bestdealfinder.us/index.php?...Using part of a cell in a chart title
I have a chart which should get a title. However, this should be partly be
used from a cell e.g.
"counted with 5%"
5% should be taken from the cell and used in the title.
Is this possible?
Yes it's possible but all of the chart title needs to be in the cell. So you
may need to use a helper cell and concatenate text and value.
Andy Pope, Microsoft MVP - Excel
"Nicole" <Nicole@discussions.microsoft.com> wrote in message
news:5CB7A971-AA7F-4C34-BB42-7DC283AA2958@micro...How can I change 'Normal' Style for Word e-mails to 'Normal (Web)'?
Hi, I'm using Word as my e-mail editor in Outlook 2003 and want to change
the default Style for e-mails from 'Normal' to 'Normal (Web)'.
The problem is that new e-mails and replies in HTML format use the 'Normal'
Microsoft Word 'Style', and this has no gap after paragraphs. The upshot of
this is that when sending an e-mail, I have to press return twice to create
a gap, but when the recipient views this, their software shows it as four
gaps (the extra carriage return I typed + their correctly viewed HTML
carriage return after each line).
E.g. I type this:
Sorry folks. I asked a question and went to the hospital for a while and
the question expired.
I have an address list in excel 2007 and am using word 2007. In my address
list I have a code column which should allow the selection of addresses to
put on labels. I used to have a query section what allows for that but I
cannot find query any more. can anyone help me?
Questions here never expire, though it may become difficult to find the
answer. The previous post received one reply, from Doug Robbins, as follows:
See the article "Mailmerge Labels with Word ...How To Copy MS Word mailing labels into Excel
I have a word doc that I want to put into Excel. I want to add some
more fields to the names and addresses. Is this simple or do I have to
learn how to program?
City of Grand Prairie
Michael, have you tried to copy and paste the data into excel?
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
"Michael Rodriguez" <email@example.com> wrote in messa...How do I use traffic lights in excel
I am wanting to use traffic lights in excel that change colour based on the
result of a variance cell, ie if the result of the cell is 10 make the
traffic light green, if it is 20 make the traffic light amber, if the result
is 30 make the traffic light red. How do I do this?
Format>Conditional Formatting>Cell Value is:
Note: you can add up to 3 conditions(4 if you count default)
Gord Dibben Excel MVP
On Wed, 22 Dec 2004 16:35:03 -0800, Shorty <Shorty@discussions.microsoft.com>
>I am wanting to use traffic lights in excel that change colour based on the
&g...Filter recordset using query results
I have a form based on a query called [qry Quarterly Planning], it lists all
Itineraries on the system. On this form you can filter records by specifying
a Start and End Date for the [ReviewDate] and/or [Specialist]. It is a
subform on a main unbound form, lets call this Subform1. Along side this I
have another subform (Subform2) which displays ReviewDates that exist
against an Itinerary. In other words Subform1 has a start date of an
activity and if the activity lasts longer than 1 day, then the additional
dates are stored in Subform2 (ItineraryDates). Currently when I...[Exchange 2003] Mail enabled public folder and sender address
I have a Windows 2003 domain with a native mode Exchange 2003 organization;
there are some mail enabled public folders.
When a user replies to a message in a public folder, the outgoing mail's
sender address is the user's one; I want it to be the public folder's one,
or at least I'd like the "reply-to" address to be set to the public
How can I accomplish this?
You would need to grant the user permissions to be able to Send As the
public folder. By default, when you reply to a message that is in a PF, the
PF is not composing the ...Outlook 2003
we have one client pc with Outlook 2003 where the following problem
if a mail is replied from a user created sub folder of the inbox, the
reply will not appear in sent mails, but will end up in the same sub
folder, sender and recipient appear as identical. The mail goes out
properly though, it's just that Outlook sets internally sender =
recipient and bounces the reply back to the subfolder in which the
original mail is stored.
This happens on a Win 2000 machine with SP4 and all updates, the other
clients use Outlook 2000 or XP and there is no such problem.
There are no ru...hyperlinking email addresses
I have a list of email addresses that have hidden text before the first
letter of the email address. I tried all the functionalities to get rid of
this spacing/hidden text, but, it does not work. Now I am trying to
hyperlink the email addresses, how do I do that?
Most likely a non-breaking space...........char 160
CLEAN and TRIM will not pick it up.
What: Alt + 0160(on numpad)
Gord Dibben MS Excel MVP
On Sat, 9 Jan 2010 13:44:01 -0800, CharlesZ
>I have a ...office 2010 and windows 7
word 2010 is hanging (seems on autosave) a great deal, especially with larger
(>3MB) files. it hangs the system and I have to do a hard reboot (power
down). any idea as to why? system is windows 7 ultimate, office 2010.
Right-click My Computer, Disconnect Network Drive.
Mary Sauer MVP
"KPTools" <firstname.lastname@example.org> wrote in message
> word 2010 is hanging (seems on autosave) a great deal, especially with larger
> (>3MB) files. it hangs the system and I have t...Using Visio HTML output within frames
I want to include visio HTML output in a frame of another html file.
Unfortunately it is not working.
I understood the problem is in vml_*.htm files. It is due to, the
target arrtibute(pointing to _parent) in v:shapetype tag and
href attribute (pointing to #) in v:shape tag. These attributes should
point to "_top" and "<target-html-file>#" respectively inorder to work.
I want to change these options while saving .vsd as web page?
I would appreciate if you can help me in this regard.
coor...Outlook freezes after sending one email after upgrading 4.0
We just upgraded from 3.0 to 4.0 this weekend. All client machines have had
the desktop client upgraded and 2 have the same issue. One is XP with Outlook
2003 and the other is Vista with Outlook 2007. Open opens and the CRM addin
initializes correctly. As soon as you compose and send an email, Outlook
locks up and you have to kill the process in task manager to close Outlook.
I've had the same problem and have tried all I can think of...how did you fix
> We just upgraded from 3.0 to 4.0 this weekend. All client machines have...Strange Access Denied Problem with Windows 7
I got a new computer about six months ago that came with Windows Vista
Home Premium 64bit. Before that I had done all of my .NET development
either on an XP Pro VM or my former XP Pro computer at home. Shortly
after getting my new computer at home, I also got a license for VMWare
to be able to test my software on multiple platforms and
I had wrote an application originally in VB.NET that was a simple
backup utility. It supports mutiple backup configurations. Any given
copnfiguration would define a backup which would be a list of files to
backup, a list of folders to ...Slow receive via VPN
I'm using Outlook 2000 in Exchange mode via VPN over DSL. Everything works
great except when someone sends mail with an attachment. Even a small
attachment like a 150k Word doc locks up Outlook for about 45 seconds. If I
have Outlook closed and open it to find the same attachment no problem.
Only when Outlook is currently open and is receiving it is there a problem.
I thought the mail was stored on the server and was only retrieved when
requested. Why would it freeze only during receive? After Outlook starts
working again I can retrieve the email in a couple of seconds. BTW, I have ...Incoming email slow to come in
Don't know if anyone can help, but here goes. We are running an
Exchange 5.5 server and I am running Outlook 2003. Email that is sent
to me internally is very slow to arrive (up to 30-45 seconds),
including email I send to myself. Nobody else in my immediate vicinity
is having the same issue, their email arrival is instant. We have
reviewed Outlook settings and they are identical. One strange thing is
this: If I send myself an email, don't do anything, it will come in
within 30-45 seconds. However, if I send myself an email, then
immediately send another email both of them will ...Can I make messages unable to be forwarded by the receiver?
We are interested in setting up a private email group at work that receives
Is there a way to make the emails that these users will receive unable to be
forwarded to people outside of the group? Make private, or somehow else
prevent the information from getting outside of the approved recipient list?
no. and you can't keep people from printing it, copying and pasting the
contents of it, taking a screen shot of it, etc, etc...
"Jonna Kosalko" wrote:
> We are interested in setting up a private email group at work that receives
...Mails not appearing in Inbox although on Server and viewable by colleague
I have searched the archives and found a few more or less related
topics to my problem, but unfortunately none of them helped.
Here's my problem:
I know that I recieve several mails at a specific time each day. Those
mails are sent to a colleague of mine and myself but only he recieves
My admins looked on the Exchange Server and all say, that they can
definetely see these emails in the server logs and that the server
delivered them to the right mailbox.
If my colleague looks into my mailbox before(!!) I open Outlook, he
sees these mails as unread in my inbox. As soon as I op...Newbie Question: Using Web Services
I've been trying to implement Infopath with CRM with no success. I've
tried the example, http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmbscrm1_2/html/mbs_crminfopathcrmintegration.asp,
to no avail. I have followed the example to the letter, but find the
information about publishing the Web Service to the server to be
somewhat lacking. Admittedly, I am not a programmer, and I am
continually running into an error in line 54:
Has anyone else ...