Sorting & Grouping On Multiple Fields
Hello, can anyone help me with this? I have four fields in a table call
Team1, Team2, Team3 & Team4. Each of the fields are linked to a lookup table
that has 22 team names. Persons in the database can be a part of up to four
I wish to group my report by the 22 teams. My problem is how do I tell my
report to check all four fields for each of the 22 team names before it
starts to group. For example a person can be in a team call "Hawk" and that
is listed in the field call Team1, while another person can also be in "Hawk"
but have that listed in the field ...Push single contact field data into prepared excel workbook
I am new to macros but ameager to get some formulated to help run my small
I have been trying to find some code which suits my requirement of pushing
signgular fields from a contact into a pre-prepared excel book which is
loaded with the next stage of macro-powered automation.
I recieve enquiries both via email and by phone. I use my blackberry to
save phone enquiries to address book and Anagram for Blackberry to capture
the required contact data from our email enquiry form. Both are then
synchronised with my Outlook contacts.
Either from the point of creation, or through ...Can you move a page from one publication to another?
Is there a way to pick up a page from another publisher document and move it
into the one you are currently creating?
Select all, copy, and paste.
MVP Microsoft [Publisher]
How to ask a question
"Melis" <Melis@discussions.microsoft.com> wrote in message
> Is there a way to pick up a page from another publisher document and move
> into the one you are currently creating?
...how to change default delivery location to my new pst file
my user has outlook 2000 sp3 running on windows 2000.
i have change the default delivery location to my new pst file in
but it did not work, new email is delivered to old pst file.
do you have any idea on resolving this issue??
Try renaming the old .pst to .old and then retry it when Outlook is opened -
point it to the new .pst file.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, sf= asked:
| dear al...Clear rows where field contains a negative sign
I have a procedure called that looks for a negative sign (*-*) in the D column
for all records. If it exists, the entire row is deleted. The procedure below
works well for this situation, BUT when there are no records with the negative
sign in the D column it deletes the first record in row 1. The Range somehow is
set for the value in the D column for row 1.
I have been unable to stop this so far.
Does anyone have a way to not delete row one if the filter is not met?
Here is the procedure:
Dim r As Range
ActiveSheet.Columns(&...Tasks with no due date at the bottom?
Is there any way to convince Outlook 2000 to show tasks with no due date
at the bottom of the task list -- when the sort is on by due date,
I know if it's sorted by due date descending, the no-due-date tasks will
be at the bottom, but that's just not it; what I need is a view sorted
by due date, ascending, with no-due-date tasks at the bottom. I suppose
it seems quite logical: the closes due dates on top, the farthest due
dates lower down the list, the ones without due dates at the very bottom.
I would love to do the same with Outlook 2003. I think the answer is that...Outlook 2002 Vcard attachment shows as a .msg file-opens but no information
I am receiving forwarded attachments as a Vcard file from
a contact list. It shows up as an envelope on the
attachment and as a .msg file. It opens but there is no
information there other than a name.
Is there a setting in Outlook that is incorrect or is
this something to do with a setting in the Microsoft
Exchange Server Administrative Rules. I have searched
the knowledge base and cannot find any specific answers
Anyone have any feedback on this or the same problem?
...How can I have an initial zero in an Excel cell?
I want to be able to enter times as eg 0845 but no matter what cell format I
use, there is a problem, either that the initial zero is lopped off or that I
am informed there is an error. Is there any way of solving this?
and you will get a four digit display with an initial display with a leading
Note this is not a time function
> I want to be able to enter times as eg 0845 but no matter what cell format I
> use, there is a problem, either that the initial zero is lopped off or...How can I shrink a flyer to print two to a page?
I am using Microsoft Publisher and I can't seem to get it to print two whole
flyers on one page. I tried using the two page spread option in the view
tab- but this just gets a portion of the center twice? How can I get the
publisher to do this?
CS Flower wrote:
> I am using Microsoft Publisher and I can't seem to get it to print
> two whole flyers on one page. I tried using the two page spread
> option in the view tab- but this just gets a portion of the center
> twice? How can I get the publisher to do this?
What if y...Can't open database window using shift key...
I have an Access database that I distribute to my client on CDROM. The
start up options of the database are set so that the database window
is not visible to the users. When the database is updgraded the
database manager copies it from the CDROM to the relavant PC and then
uses the shift key on opening in order to display the database window
and link to the tables in the existing back-end. This procedure has
been done many many times without a problem...
BUT last week he found that holding down the shift key whilst opening
the database no longer opened the database window and leave...Fill null fields from last record non-null in that field
Access 2000 -- I have a database table which is built from an import from a
I want to fill blank fields in records from the last previous record that
has a value in that, and then when Access encounters a new record with a
value in it, have this pasted into the fields below it.
Now, it looks like this:
I want it to look like this:
9 "0...Can't see printers in directory
The shared and network printers aren't showing up in the directories of the
workstations. On XP machines, the network printer does show, but no shared
printers. On Windows 7, no printers show. I need to get this resolved.
Thanks for any help and God Bless,
Mark A. Sam
Which directories are you talking about? How did you add the printers to
the machines? Please describe some more details.
Disclaimer: This posting is provided "AS IS" with no warranties, and confers
** Please do NOT email, ...lead source field not populating during import
I added more choises to the lead source pull down. Restarted IIS. When I go
into CRM they show up fine and I can choose them for a new lead.
However I am importing leads (using Scribe) and I cannot get this field to
populate. If I assign the number value associated with each pull down choice
I get the number in that field. If I put nothing in that field to import
when I go into CRM only the original choices for the pull downs are there,
not the ones I added.
I know I published them because I can see them if I'm just adding a lead
from within CRM
Any suggestions anyone.
Hi...task pad #2
What is the difference between these 2 Task Pad views in Outlook 2003:
All Tasks also shows completed Tasks.
"Dorothy" <Dorothy@discussions.microsoft.com> wrote in message
> What is the difference between these 2 Task Pad views in Outlook 2003:
> -All Tasks
> -Today's Tasks
Is it possible to change the column type of the 'Title' field in my
SharePoint list for example, to a 'Choice' field?
I don't really need a 'Title' field, but of course I need to have the 'Edit
menu' option on one of the fields, and I don't want it to be a 'single line
Any help would be appreciated.
I wouldn't recommend messing with the title column. It's a system column and
it's better to be left alone.
What you can do however:
1) Hide the Title column
http://ferraradata.co...Please Help...I can not send/receive or delete email on outlook 2000
It gives an the following errors" Error has been detected
in the file C:|Windoews\Outlook.pst. quit all mail
applications and then use Inbox Repair tool."
I spent hours tring to find a solution on the support
section. Couldn't find it.. Thank you so much for help..
What size is yr *.pst? OL prior to 2003 can have problems when greater than
The inbox repair tool is scanpst.exe
If oversize; http://support.microsoft.com/?kbid=296088
"Daniel" <firstname.lastname@example.org> wrote in message
> It gives an the follow...Can you still run Clip Gallery in Publisher 2003?
I just recently upgraded from Publisher 2000 to 2003, and now I can't figure
out how to use Clip Gallery. I gave up & copied my clip gallery files to my
hard drive, and ran Clip Organizer, but none of the keywords "stuck", so I
can't search for clips using keywords anymore. I'm not real keen on searching
thru thousands of thumbnails for an appropriate clip, so for now I'm finding
my clips in Home Publisher, then copying and pasting into my Publisher 2003
documents. Publisher 2003 help makes a reference to still being able to run
Clip Gallery, but gives no i...Can't upgrade HQ to 2.00
I try to upgrade HQ database from 1.3 reresh to 2.00 but I have Error "An
error occurred while attempting ti upgrade the database
'DF_Configuration_SoftwareValidation1' is not a constraint "
How should I do?
Help me plz. >_<"
...Add CRM 'Subject' look-up field to the Phone, Email, and Task form 01-30-06
Is it possible to add CRM 'Subject' look-up field to the Phone, Email, and
Task forms? Existing Category and Sub-Category fields sound like they should
be linked to it. A good example would be Membership as a Category and
Application as sub-category (Membership being a subject and Application being
Yes, this is possible.
You will need to create a new entity called i.e. Email Subject and then
create a 1 to many relationship between email and this new entity.
> Is it possible to add CRM 'Subject' look-up field to the Phone, E...Believe it...You can be rich with only $910 investment !!!
<META NAME="GENERATOR" Content="Microsoft DHTML Editing Control">
<P>If anyone interested to find out what can $910 do for you, please go to below
URL to view the online presenation.</P>
<P>You won't regret if you view the presentation.</P>
<P><A href...Can't Import old files
I have a system crash and had to re-install XP. My Outlook express files are
on a other drive. I had that because of other experience. That worked verry
But now i want to import my old emails and i can't get them!!
I can't acces the files.
I have already looked into the help in different sites but no sollution yet.
I cant copy,rename, the files.
I tried to get them back with DBxpress (recover program) but also that
program can't open the files.
It look like that the files are protected with a NO write/read function.
I can deleted the files but thats not a option till i ha...How can I use Outlook in two computers (my PC and my laptop)? I o.
How can I use Outlook in two computers (my PC and my laptop)? I can only see
my incoming emails in my PC, but not in my laptop; even though I have
configured Outlook in both computersto received the incoming emails to my
"osiris" <email@example.com> wrote in message
> How can I use Outlook in two computers (my PC and my laptop)? I can only
> my incoming emails in my PC, but not in my laptop; even though I have
> configured Outlook in both computersto received th...Using SQL Query to mass update a field.
Having a problem in eOrder where the pictures are not showing up. I found out
the Inventory image in internet information is mapped to a drive letter. If I
remove the drive letter, I can see the picture in eOrder. I would like to
mass update the SY01200 INET4 field and change all from f:\inventory
pictures\image.jpg to image.jpg (where image.jpg is the file name). It sounds
like I need to create a cursor script but am not sure how to do this. Can
anyone help me with this?
Backup you data first.
You might be able to use DTS to trim the data with a string transformation.
Or you ...Even after switching to newView . previousView can be seen
I am working on an SDI application.
It has 3 views(With corresponding buttons to open
them).When i switched from 2nd to 3rd view...I can see
the 2nd view between the gaps of controls on 3rd view.I
think the 2nd view is not completely erased.
Pls suggest me What to do..its urgent
Are you remembering to hide the 2nd view when you show the 3rd view?
Perhaps even destroying the 2nd
view when you create the third view? How are you displaying the views?
"vani" <firstname.lastname@example.org> wrote in message
> I...Save data in a worksheet in fixed length fields...
I have data in a worksheet (Office 2000) which I would like to export in
fixed length format for importing into another application. Is there a way
to use column settings or a wizard to export the file in correct format
rather than exporting and then having to do signficant editing before I can
import the file into the other application?
In article <9C97DB7F-65EB-4438-926E-23906D56E75D@microsoft.com>,
dietzd <email@example.com> wrote:
> I have data in a worksheet (Office 2000) which ...