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...Open Hyperlink without Confirmation Message?
Excel 2003 insists on opening a "Microsoft Office" message box whenever a
hyperlink that opens an external file (.mpg in this case) is clicked:
"Opening xxxx.... some files can contain blah blah blah. Would you like to
open this file?"
Does anyone know how to get a worksheet's hyperlinks to open with a single
click and skip this *annoying* (but oh so safe) message? Changing security
levels under Macro settings does not do the trick.
If yes, then Jim Rech posted this:
Curtis Phi...CD keeps opening automatically
After having installed printer, CD slot keeps opening automatically, as if
I'm going to put a CD in it. Then, I need to keep closing it every two
minutes or so.
My question is;
How to stay CD slot keeps closing?
Thanks for your help in advance.
"MapleE." <email@example.com> wrote in message
> After having installed printer, CD slot keeps opening automatically, as if
> I'm going to put a CD in it. Then, I need to keep closing it every two
> minutes or so.
>...How to forbid opening subform
Can i forbid opening the subform by itself ? I want my subform to be opened
only by the main form and i somebody wants to open the subform not to allow
Message posted via http://www.accessmonster.com
samotek via AccessMonster.com wrote:
> Can i forbid opening the subform by itself ? I want my subform to be
> opened only by the main form and i somebody wants to open the subform
> not to allow it
Try referring to the subform's Parent property in the Open event. When NOT
opened as a subform that will raise an error. You can then have an error handler
that cancels the Op...How do I eliminate restrictions to opening hyperlinks in emails?
When I click on a hyperlink in an email, I get this message: “This operation
has been canceled due to restrictions in effect on this computer. Please
contact your system administrator.” I just started receiving this message on
my private laptop that is not connected to any system. How do I remove the
Reassigning or resetting your favorite Internet browser usually does the
trick. For details see;
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
http://www.howto-out...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...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...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...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...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"...Hidden Figure after closing then opening the Visio file
I have a Visio file which has PNG/JPEG figures attached on it.
However if I close that file, then opening it again those figures are
And whenever I saved the Visio file as EPS or other, I also can't see
Strangely, I still can see the "dashed frame" of those figure in Visio
It seems that the figures are still there, I just can't see it.
Why is this happening?
Is there a way to prevent or recover those figure back again?
I am using MS-Visio Pro 2002.
On Thu, 05 Jul 2007 07:01:56 -0000, foolishbrat <email@example.com>
wrot...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" <firstname.lastname@example.org> 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...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@...Word Won't Open with File Double-click if Word not open
I'm running Vista Home Premium SP2 on an Acer desktop system with 2 gigs of
Ram and running Office 2007. My primary internet browser is Firefox.
For the past few months I can no longer double click on a Word file (not
matter where it's stored or what it is) unless I first open up Word itself.
I get an error message (see below).
When I first purchased and download Office 2007 in 2006 there was no problem
opening up Word files with a double click and it's been that way up until a
few months ago. Opening Excel files has always and now works just fine.
Here's the ...Office Crashes When Opened
Operating System: Mac OS X 10.5 (Leopard)
Whenever I open any Microsoft Office 2008 application I get the "Microsoft App has encountered a problem and needs to close. We are sorry for the inconvenience." I can't find any solution online that is working, what should i try?
> Whenever I open any Microsoft Office 2008 application I get the
> "Microsoft App has encountered a problem and needs to close. We are
> sorry for the inconvenience." I can't find any solution onli...way to verify time stamp?
Is there a way to verify when a forwarded message to you
had originally been sent? I suspect someone is mis-
representing themselves and simply typed new fields into
the "original message" time and date.
If not - is it possible (or at all likely) that someone
sent me two emails days ago and they never bounced back
and never made it to my inbox, while all other email
functions appear completely normal??
"Julie" <email@example.com> wrote in message
> Is there a way to verify when a for...VB6 Code 1/2 way finished......any suggestions
Have a issue with a VB6
program, had someone write some code, he got 1/2 way thru and decided to
work on other projects and keeps putting us on the back burner, been waiting
4 months now, looking at what he has put together looks very nice, but is
trademarked? so we cant get to the code, any ideas or suggestions? Thanks
On 4/1/2010 12:48 AM, David Kaye wrote:
> "Bill"<firstname.lastname@example.org> wrote:
>> trademarked? so we cant get to the code, any ideas or suggestions? Thanks
> If it'...How can I open a text file to the screen
Can anybody tell me how to open (print)a text file to the screen. For
example, to click a botton and the file will be shown in the screen. Using
something like the code below.(the code below is not good, but I want to
give you an idea)
private: System::Void ShwCrdBtn_Click(System::Object^ sender,
FileInfo^ fi = gcnew FileInfo("C:\\MyFile.txt");
Basically, there are several things you can do depending on exactly what you
want the result to look like. If the only thing you want to be vis...spreadsheet won't open "too many
different cell formats".
There's a guy in our company that has created this HUGE
spreadsheet - and now they can't open it because it gives
the error message "too many different cell formats". I
know how to resolve the issue if I can open the file - is
it too far gone? Is there any way to open this file?
Any help is appreciated! Thanks so much!
xl2002 has a better reputation for opening files that xl2k and before couldn't.
So if you're not using xl2002, you may want to see if you can find a copy so you
can try it.
And I think I read someone post that t...OPEN RELAY #6
I am running Exchange 5.5 and I've noticed a lot of
messages in the IMS SMTP Protocol Log that have an unknown
sender and recipient that is NOT in my domain. It looks
like I have an OPEN RELAY. When I RCPT TO: my Exchange
server, it says that "Relaying is Prohibited". I've
deleted these messages, but more arrive. There are a few
NDRs, but most of them are being transmitted out again.
HELP! I can't seem to figure this one out.
> I am running Exchange 5.5 and I've noticed a lot of
> messages in the IMS SMTP Protocol Log that have ...Modal dialog box with a tree control is hidden
I am facing a strange problem on Windows 98 system,The Modal dialog
box with a tree control is hidden behind the property sheet, which
invokes that dialog.
The application is a MDI application with two views,the view which is
derived from the scroll view class invokes the property page for a
widget in that view.In the property page on clicking on a button
should invoke a modal dialog box with a tree control in it.This works
fine on Win Xp, WinNT machines but on Win98,it behaves strangely as i
have mentioned above.
Is it a know bug ??
Thanks in advance.
Pavan K Thirunagari
It sounds like i...trying to figure out a two way lookup to determine a value
I have a large spreadsheet that lists numerous customers. Each
custtomer has a code for the service that we provide them and then has
a price negotiated at the time of service. We are have set up a price
list that gives the service code, in a vertical column and then has a
range of dollar values for each service code (about 20 separate codes)
ranging from $0 to $75 broken up in 5 grade (E,D,C,B, A) categories.
The pricing is different ranges for each service code. What I need to
do is have each customer line, take their code, find a match in the
Price LIst code, the take the price they are pa...