Can I format Outlook2002's email so that every time I click on Send, the new
email page opens with a specific text in the Subject line?
I want to set up all the computers in my office so that every time a member
of staff sends an email, the company's name appears first in the subject
This way, even if the recepient doesn't recognize the sender's name, they
will see what company it's coming from and won't delete it as a spam!
...hyperlinks in getting external data through web query
This is a multi-part message in MIME format.
The WEB PAGE I am downloading using the WebQuery with <full Html =
formatting> is something like the following=20
5,154.32 - 5,240.29
A C C-A
255.30 - 262....Use of the automatic cancellation of a subscription marketing
I have a base of accounts to which I send regularly documents (email.).
However I know that in CRM there is a possibility of updating automatically
the field "to send the documents marketing" (to put it at the value "no")
when we receive a request by email of withdrawal of subscription of the
Do you know how that functions it because I can't make it function properly?
Thank you by advance for your answers (and sorry for my bad english).
I'm not sure exactly what problems you are having, but here's the basic
1. you need ...Using Access Reports in other EXE file
I'd like to use access reports from any access version XP, 2000 or 97;
because of the easy way to build such reports.
Have you ever found or built any solutions permitting to reuse such access
reports objects in other exe files, developped in Visual Basic, Visual
Studio or even Delphi....
Thanks a lot for your suggestions
Most programming languages support launching an executable, so the Snapshot
Viewer executable would be a good choice for viewing reports exported from
Access as Snapshot (*.SNP) files. Access would not need to be installed on
the computer in order to view ...How can I compare 2 sets of Social Security #'s and Identify dupes
I'm sure this can't be that difficult but for some reason it's just not
working for me. I have 2 lists of social security numbers that I need to
compare and pull out duplicates. Any help would be greatly appreciated.
Use a formula of
in C1, and copy down
(remove nothere from the email address if mailing direct)
"vwwolfe" <email@example.com> wrote in message
> I'm sure this can't be ...Form property as query criteria
I am working on an Access 2000 db in Access 2003 (using 2000 format). In
my original 2000 database, I would create properties in VBA (using Property
Let and Property Get statements) for my forms and use them as criteria in
queries. For example, if I had a report that should show data for a
specific date range, then I would create properties of a form (call it
"frmReport"), and name those properties ReportStartDate and ReportEndDate.
Then, in the design of the query that the report is based on, under the
criteria for a date field, I would add ">=
[Forms]![frmReport].[R...Multiple <> query criteria
I am trying to create a query to say I want everything from a table but not
the following multiple reference numbers e.g.
If I do just 1 not criteria it works, as soon as i try to put more in it
does not work. I have tried putting each one in on a seperate row and tried
<>4000 or <>3568 or 5869 etc but neither works
You should be using AND instead of OR. You want records where the value is
NOT 4000 and the same Value Is NOT 3568 etc.
You can also use this expression which is equiv...monthly/weekly reports
This is probably really easy to do but I can't seem to figure it out. I have
a report that displays records from a table. Each record has a corresponding
date. Right now, the report shows every record in the table, going back more
than a year. How can I make it so the report just shows the records from the
previous week or month or whatever dates I choose. And then how do I use
this same report over and over for each month or week? Basically I just want
to hide certain records on the report (ones that were created before a
specific date). Thanks
You can base the 'record s...Can't Open Money
I was using MS Money 2002 this weekend and everything was
working fine. I tried to open it later in the weekend,
and the program will not open. I hear my hard drive make
some noise, but then nothing happens. Everything else on
my machine is working fine. Does anyone know how I can
In microsoft.public.money, Sean wrote:
>I was using MS Money 2002 this weekend and everything was
>working fine. I tried to open it later in the weekend,
>and the program will not open. I hear my hard drive make
>some noise, but then nothing happens. Everything e...Can't send email 04-22-10
Can someone help me? I am only sending to a list of 20 recipients, yet I get
the following error:
The message could not be sent. The authentication setting might not be
correct for your outgoing e-mail [SMTP] server. For help solving this
problem, go to Help, search for "Troubleshoot Windows Mail", and read the
"I'm having problems sending e-mail" section. If you need help determining
the proper server settings, please contact your e-mail service provider.
The rejected e-mail address was 'firstname.lastname@example.org '. Subject
'Catholic Financ...How can I use conditional formating between two sheets in one work
If employee number 5263 found in sheet 2, show the raw in main data on sheet
1 in red, for instance.
ok this is how i did it
use a helper column and a vlookup formula back at sheet 2
so if employees name is found on sheet 2 this formula returns found on the
same row as the emplyees name
conditional formatting for this row is
i had to change the formatting formula for each row,hopefully there is an
remove nospam for email addy!
"...Commission Report #2
I must be missing something but is there any way to generate a list of
commissioned items. Not sales of commissioned items just a list of the items
that offer a commission.
This is a multi-part message in MIME format.
Try this one attached.
Check Point Software
I'm trying to create a macro to open all the Excel files in a folder and
copy/paste the second line of each worksheet in a separate file already
created. Could somebody help me? I don't know a lot about macros. Thanks!
The code below should do the trick for you. To put the code into your
workbook, open it up and press [Alt]+[F11] to open the Visual Basic Editor
(VBE). In the VBE use its menu to Insert --> Module. Then copy the code
below and paste it into the code module presented to you. Close the VBE and
save the workbook in the SAME FOLDER with the other files...Problem using two timezones
I'm having a problem with Outlook 2003, trying to use two time zones. The
time display for both zones is correct when I initially set up the two
zones; but if I swap the time zones, the first zone displays an hour less
than it should. If I swap back, they're correct. What's going on and how do
I fix it?
does the second zone have the correct daylight time setting?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
O...Recently Used File List Problem
I have Excel 2000.
I have the recently used file list set to 6. During a session of
Excel, it will expand from, say, 4 files to 5 (when I click on
File/Open), but after I close Excel and relaunch it, it loses the last
file opened and only shows 4. This seems to happen ONLY with
spreadsheets from a particular folder. Others stay across sessions.
What happened, and what can I do to get it back to working properly
...Edit cell by using mouse
How do I restore the function of Edit cell by using mouse - right click?
Try double-click with left mouse button instead.
> How do I restore the function of Edit cell by using mouse - right click?
...Create and Use Button Menu using visual Basic in Excel
The following code is very simple. All I need to do is figure out how get the
result of the userform entry from the click event. I apologize if seems to
easy but I have trouble with userforms and menus getting user data.
Thanks for Your Help
If Me.OptionButton1 = "True" Then
Debug.Print "Option One has been Selected"
Debug.Print "This has failed miserably"
Private Sub OptionButton1_Click()
Dim Sel As String
MsgBox ("You Select Buton 1")
Sel = Me.OptionButton1
Private Sub OptionButton2_...Can this Be Done in Excel ?
I have a employee job scheduling table that I would like to populate
based on criteria from 2 other tables.
The scheduling table has the employee names listed in each row and
across the top is the period of the day broken into 4 time periods.
The critera tables are:
1. A training matrix that lists the employee names in each row and
jobs listed across the top. If an employee is trained, the
intersecting cell has a "T". If they are not trained, the cell is
2. An attendance table that lists the employee names in each row and
if they are absent, there is an "A"...Can Macro read line graphs?
Is there a way macro can read line graphs?
I have a graph with temperature along the bottom, weight along the left side
and in the the graph area there are several diagonal lines as pressure
altitude. By entering the graph at Temperature going straight up into the
graph to the correct pressure altitude then move left horizontally left and
that will give you the answer (weight).
Do you have formulas relating these numbers to each other? It would be
straightforward to solve these for the missing variable.
Trying to read values off a chart is not going to be easy. Tushar Mehta ha...can you control how comments print in excel xp or 2003?
I noticed a user at the copier today, using the blow up function to
try to enlarge the comments that he had printed out at the end of his
excel worksheet. He commented that he could not change the font for
the comments. I went back to my desk, and was able to replicate the
In short, you can format comments for on-screen viewing (and
presumably when you print comments "in place"), but if you print out
all the comments at the end of your document, you apparently can't
control the font/size/formatting/etc. The only thing I could find that
made a different to how it printed...Which Exchange-aware Anti-Virus can I use ?
Is it not wise to use Symantec AV Corporate edition client (8.00.9374)on
Exchange 2003 ?
I had to rebuild our Exchange Server and I want to be sure which AV client
WE have been using trend micro for exchange where we have to....
You do not want to be scanning the drives with a 'regular' AV client.
"chrism" <chris@no_spam> wrote in message
> Is it not wise to use Symantec AV Corporate edition client (8.00.9374)on
> Exchange 2003 ?
> I had to rebuild our Exchange Server a...Outlook express #72
I cannot delete sent emails in the the sent folder. I have
no trouble deleting anywhere else.
This newsgroup is for support of Outlook 97, 98, 2000, 2002 & 2003 from the
Office family for Intel PCs. For Outlook Express (OE) support try posting in
one of these newsgroups:
microsoft.public.inetexplorer.ie4.outlookexpress for OE 4.x
microsoft.public.windows.inetexplorer.ie5.outlookexpress for OE 5.x
microsoft.p...Report website problems here
I reported the problem last week of the email not working properly. I was
asked to send mycomments to the website below using the case number
SRX1110134208ID. I recommend alld user to respond to this case number with
their comments. I think it is silly that Microsfot doesn't maintain their
own website properly and it take almost 2 weeks to fix problems that effect
thousand of customers.
Were you having email problems with Publisher?
"Joel"...Query Return Recordset As...
Is it possible to run a query from a form and have the query return
its recordset in continuous form format rather than a datasheet?
>Is it possible to run a query from a form and have the query return
>its recordset in continuous form format rather than a datasheet?
That doesn't make sense to me, but you can set a form's
DefaulView to Continuous and use the query as its record
source. Then the form; will open using the query's data and
display it in continuous view.
I guess if you want to be tricky about it, you could open an
unb...Reports in column format
My report page set-up is for 3 columns with zero spacing between
There is a box around the set of controls. I have the palette
narrowed to the absolute minimum width so that there is no working
space to the right of my controls. The result is a calendar-like
presentation. The problem arises when I want to center text in the
headers and footers. If I simply place my header text in the header
section, it will appear more or less towards the left side of the
page. In order to get it centered, I have to widen the palette and
then center the text manually. If I do this, then...