Best Way ?
Looking for some information. With Outlook you can have all your
contacts...address, email address, yada, yada, yada. Can I use this
information in to say mail merge with Word and email a letter to the ppl
with email addresses? Or is this better done with a Access?
The reason I ask is that we want to deliver an email to all our clients with
the latest promotions. And want it to be a bit more automated?
Any information or pointers in the right direction would be appreciated.
Have a good one,
You can use either Access or Outlook as the data source for a ma...outlook express font settings
Does anyone know how to set the font in Outlook Express.
I've set it in Options/Accounts/Signatures. This works
when I create a new mail message, but when I use
the 'Reply To' button, the signature is in a different
font and size (Times New Roman, 12 pt), though the message
text is correct. It's not a big deal, but certainly
frustrating. Please respond via email. Thanks.
...How to use AND with "WHERE" in OpenForm... like (idA=Me.idA) and (idB=Me.idB)
How do you specify two conditions in the where clause in a
DoCmd.OpenForm instruction ??
So the "Where part of.... DoCmd.OpenForm "AltForm_A"
would look something like, , ,
"[idA] AND [idB] = " & (Me.idA) AND (Me.SubForm_B.idB)
----- Below is my simple setup ---- showing what I'm trying to do.
1 - I have 2 tables...tblA and tblB
2 - While looking at... MainForm_A with SubForm_B
3 - Double click on a record in SubForm_B
4 - and open AltForm_A with AltSubForm_B - a form with a different
view of the same data
Thanks for any help with this.
MyEmai...Like Operator in the Criteria in a Query
I have a database that will be looking at Work Requests numbers and if
certain criteria is met, it will add either an A or B or C or D to the end of
the Work Request #, What stipulates whether an A or B or C, etc. is added
depends on how many Work Requests are found that have the number, then one
that has the A, then one that has the B and so forth. I am trying to create
a query that will look at a text box that has the Work Request number in it
and counts the number of times that work request is in the table whether it
have an A, B, C, D. or none but just the number. I am jusing thi...XmlDocument and FileStream's with trailing contents after edit
I have used an XmlDocument object to edit an xml files
contents which sometimes results in the Xml content being
shorter that what it originally was, when i save the new
contents i end up with junk at the end of the file
Code i use is
FileStream _FileStream = null;
XmlDocument _Doc = null;
XmlNode _Node = null;
// Open file stream exclusively
_FileStream = new FileStream(strFileName,
FileMode.Open, FileAccess.ReadWrite, FileShare.None);
_Doc = new Xml...Is there a way to color code Outlook Contact File Folder Labels?
Is there a way to color code Outlook Contact File Folder Labels?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Author, Google and Other Search Engines (Visual QuickStart Guide)
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Join OneNote Tips mailing list: http://www.onenote-tips.net/
"isailhbca" <firstname.lastname@example.org> wrote in message
>...A way to create sub-categories?
I want to group contacts by category and then a sub-category for easy
viewing. Apart from creating a new field for sub-category is there a way of
doing this? Outlook doesn't seem to support sub-categories.
Author - Special Edition Using Microsoft Office Outlook 2003
Lead Author - Access 2003 VBA Programmer's Reference
Author - Absolute Beginner's Guide to Microsoft OneNote 2003
"Casebase" <email@example.com> wrote in message
news:%23rx5a...Big difference in performance
I wrote a class on which I perform unit-testing before integration in
the main development line, the unit-testing and main dev being two
I wrote a routine which constructs a data structure in the class,
which uses CArrays, vectors, and the nth_element routine from STL,
with the routine being recursive.
Now, in the unit-test project, the routine takes ~3-4 seconds to
execute. In the main development code, it takes ~70 seconds to
This is measured for the routine itself (no setup or cleanup), same
data as input, same computer, and both projects compiled for debug.
...is there a way to crop a corner out of a rectangular image in Visi
Using subtract on two shapes accomplishes what i want to do, but when the
first shape is a .gif image, it does not work.
No, the "boolean operations", as they're called, do not operate on foreign
objects like bitmaps and controls.
Visio has crop functionality for imported graphics, but it is only
You could draw a small white triangle and give it "no line". Then place it
over the corner of your bitmap.
Hope this helps,
"doug" <firstname.lastname@example.org> wrote in message
news:29D479A6-6099-4051-B7A0-1...There should be controls, edit lists, and approvals in BankRec
Without controls in the bank rec module I am forced to have a more senior
person prepare all my reconciliations. Junior people can post transactions
without approval and this significantly effects internal controls for the
most liquid asset.
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&qu...is there a way to change the time card repor format?
i'm using activereports in RMS to generate a custome timecard report. for my
timein and timeout colums, the datatype i have assigned to the columns is
vbDate. when I generate the report, the columns only show the date as
mm/dd/yyyy, they do not show the time of day piece for exactly when the
cashier punched in or out. is there any way to change the formatting of this
so that in the report the time shows up? for example, instead of showing
2/6/2005 in the time in column, it would show 2/5/2005 8:00:00 AM.
thanks in advance,
There is a timecard report on the Reports Library...updating a worksheet from another worksheet
I have a workbook that contains worksheets for each Month
and 1 worksheet called Combined
Example : Worksheet names in workbook are:
Each of the worksheets except the Combined worksheet
contains the same column Titles
January worksheet has columns
A1 = NAME
B1 = Telephone
c1 = City
D1 = State
February worksheet has columns
A1 = NAME
B1 = Telephone
c1 = City
D1 = State
March worksheet has columns
A1 = NAME
B1 = Telephone
c1 = City
D1 = State
Combined worksheet has
A1 = City
B1 = Name
What I am looking to do to the Combin...dial up settings
I have a new PC (Windows XP home) and Office 2003. If I run Outlook and
click "Send and Receive", a dial up connection is established and I receive
email correctly. The dial up connection remains open, which is OK. If I then
compose email and click "Send", it is sent correctly. However, if I do not
have a dial up connection established when I compose email, when I click
"Send" a pop-up box appears with an error message saying that there was a
mail send error. I have to close this and click "Send and Receive"
Is this normal? I would have expe...best way to deserialize xml
I'm at a quandry as to what's the best/fastest way to deserialize an
incoming xml stream?
I ran a small test on xmlserializer and on a small file it performed 10
times worse then when I used the XMLDocument and deserialized the values
myself. Is the xmlserializer really that slow?
I'm expecting a file about 1 MB in length and if it's that slow on a 2 K
file then I can't phantom how it's going to behave on a 1 MB file.
Should I just skip the xmlserializer and XML Dom and go straight to
xmlreader and do the deserialization myself?
This has been discussed a few times...Can You Count This Way?
I have some cells with note type data:
Is there a way to count every item between the commas?
Timothy Wright wrote:
> I have some cells with note type data:
> For ex:
> Is there a way to count every item between the commas?
On Wed, 19 May 2004 20:13:53 +0200, "Frank Kabel"
>=LEN(A1)-LEN(SUBSTITUTE(A1,&q...Is there a way to Sort data by color in Excel?
I am trying to sort data by color, is that possible?
"SRTUC" <SRTUC@discussions.microsoft.com> wrote in message
> I am trying to sort data by color, is that possible?
You're gonna need a User defined function to get the value of a color.
See Chip Pearson's site for a nice version:
Look for: Returning The ColorIndex Of A Cell
Then you could use that UDF in a separate colu...Urgent Please: Development Environment Convert to Access 2002/2003 a Property
Windows XP w/SP2
Access 2002/2003 w/SP3
Can someone please help me to understand this Property of an OCX
I need to convert it and use in Access 2002/2003 in order to display
the SftTree.Version Property
Softel vdm, Inc.
Returns the product's exact version.
Text = object.Version As String
Text = object.Version As String
string Text = object.Version;
_bstr_t Text = object->Version;
_bstr_t Text = object->GetVersion();
HRESULT object->get_Version(BSTR* Text);
Text := objec...Copying Security Settings
Is there a way to copy Security Settings between users, in
the same company, via a SQL script?
We have several users who need similar rights and want to
make sure that everyone has the same rights as their
counterparts with minimal input, hence the SQL script.
Although this would work, I would set up a user class with
the general settings you want, then add users to the
class. It copies the settings just like you are wanting
to do with an SQL script.
>Is there a way to copy Security Settings between users,
>the same company, via a ...Fastest way to load an xml file into an array in .net
VS 2005 SP1 (C#, VB.NET)
I need the absolut fastest way of loading an xml-file of about 700KB into an
I need to load about 1500 of those xml-Files into arrays on startup of my
Therefore it needs to be as fast as possible.
Please also tell me if the xml structure can be improved.
the xml looks like:
<v y="1998" m="1" h="1">0.227777109151971</v>
<v y="1998" m="1" h="2">0.206573903224972</v>
<v y="1998" m="1"...Is there a convenient way to save data
Is there a convenient way to save dialog data so it remembers the users last
selection? I have a dialog based application that only has three user
variables all of which are ints. What is the best way to make theses
variables persistent for a given user on a given machine?
"Jeff B" <email@example.com> wrote in message
> Is there a convenient way to save dialog data so it remembers the users
> selection? I have a dialog based application that only has three user
> variables all of which are ints. What is the best w...Eudora "like" stationery in Outlook?
I love the ability in Eudora to create "stationery" - actual letters, not signatures (Outlook refers to signatures as stationery but that isn't what I'm asking). I want to write a unlimited numbers of 'FORM" letters, and store them, and use them when I reply to emails that ask for the same info over and over again.
In Eudora I have about a dozen of these form letters, but I'd like,with the new 2003 Outlook version to bringing everything over to Outlook so it's all in one place. But not if I can't store standard email responses.
Just a *bump* to...I don't like the MDW file
can anyone think of any alternatives to use instead of the MDW file?
In other wors, provide the same type of security in a dirfferent way,
withouth using the MDW file?
What sort of security are you looking for?
Access User-Level Security, which is probably what you're talking about when
you're saying MDW file, isn't that secure anyhow.
Doug Steele, Microsoft Access MVP
(no e-mails, please!)
"Anthony" <firstname.lastname@example.org> wrote in message
> can anyone think of any alternatives t...How do I create a master set using my own design?
I don't like any of the selections for master sets. How do I design a master
set using my own design?
Open help, search for custom scheme.
Mary Sauer MSFT MVP
"Lainee" <Lainee@discussions.microsoft.com> wrote in message
>I don't like any of the selections for master sets. How do I design a master
> set using my own design?
...Is there a way
Is there a way to turn off NDR's in Ex5.5 SP4 on an NT server running SP6a ?
Also, can the ability for the server to receive TELNET connections be turned
My server isn't an open relay, but, I know it's being used to SPAM using
DNR's and I can see TELNET connections in the log files....
i know that u can turn off the ndrs to be sent from exchange at the standard
poliy setting, thats how i configured it at exchange 2000 ....
there must be also a setting at exch 5.5, actually i dont remeber it ....
"Steve@Home" <sprob@...Total Gym Blast Vol. 1&2 Series DVD Set
Best deal: http://thediscounfinder.info/index.php?id=B000PQKKQS
Rev 'em up fast and furious. Each of these tough, challenging, progressive workouts is an intense 15-minute muscle isolation superset targeting Abs, Back/Chest, Shoulders, Biceps/Triceps, Buns & Legs. Focus on a different key muscle group each day or through the course of each day. Within a week, you'll get a fun and memorable full body workout. Before you know it, you'll see and feel results.
Total Gym 1700 Clu...