Contact with multiple Email Addresses
I have the Tracking device on in CRM 4.0, which is tracking all incoming and
outgoing emails for leads, contacts and accounts. I am wondering if it is
possible to add/track multiple email addresses for one contact. Is there
anyway to associate more than one email address for an entity?
A contact (and also account and lead) has three e-mail fields. CRM uses all
these fields for email tracking.
Patrick Verbeeten (MCPD)
Tools for CRM Developers and Administrators
>...Fixed Asset Import Multiple Times?
We have a new client on GP 9.0, SQL 2005. They are just starting to use
Fixed Assets. We are planning on doing the initial import of fixed assets
via Excel and the Fixed Asset Import Wizard. However, they will have many
acquisitions in the next few months/years of additional companies (from which
they will acquire many new fixed asets at a time).
Can we do additional imports (from excel and the FA import/export wizard)
for new/additional fixed assets we acquire during these acquisitions?
We would want to maintain all our current Fixed Assets, of course, and j...Justify text across multiple columns
I have used Edit, Fill, Justify to fill rows with text within the boundaries
of a set number of columns, but the text in each row is left justified. How
do I justify the text (even spacing) in each row. If I highlight all of the
text (multiple columns and rows) and then select Format, Cells, Alignment,
Justify; Excel jams all the text into the first column. I know I could use a
text box, but I'd prefer not to. Any help would be appreciated. Thanks.
Select the cells you want to center on.
Under Format > Alignment > Horizontal drop down > Center across se...Order in query is lost in report
I have a subreport which is based on a query. When I run the query it
delivers the fields ordered by date descending, as requested. When I run the
(sub)report, all fields are delivered but in date ascending. Any clues or do
I need to post more specifics?
Use Sorting & Grouping in your report at design time. There is a button on
your menu bar that will present you with a dialog similar to setting indexes
on a table.
MCSD, MCAD, MCP
"Jon Geiger" wrote:
> I have a subreport which is based on a query. When I run the query it
&g...if then statement with a vlookup?
I am trying to come up some code to search a workbook for numbers and
then put them in a column on the last page but if the number already exists,
do nothing. I need it to do this everytime I run the macro. Any ideas?
here is an example:
look for "day" if true then i want the number in column j on that page to go
to the last page in column k, but if the number is already there then do
nothing. if it is not there then the next cell down.
Does this make any sense? I think I confused myself.
Any help is appreciated
A little clarification ple...Multiple Versions of Office Apps
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
I have not upgraded to Office 2008 because the budgeting programs I use in Excel require macros. I do, however, want to upgrade Entourage for better Exchange compatibility.
If I install Office 2008, can I still keep my Office X version of Excel on the same system (PowerBook G4)? Will there be conflicts?
On 3/25/08 9:04 AM, in article firstname.lastname@example.orgR9absDaxw,
"email@example.com" <firstname.lastname@example.org> wrote:
> Version: v.X
> Operating System: Mac OS X 10.4 (Tig...Update Query basic
I have Table1 with field Track, I want to update with info from field Track
add both tables to design view field track but don't know what to put in
Am missing something here - hope you can help. Want to eventually use this
to update adress fields from one table to another with EmpID connecting each.
UPDATE table2 INNER JOIN table1 ON table2.ItemID= table1.itemID
SET table2.UnitPrice = table1.UnitPrice
would update the unit price of table2 with the unit price coming from
table1, for the same itemID (ie, the APPLE unit price won't be updated by
the ORANGE ...query tables
i have inherited a database w/ o documentation & noone to tell me its history.
I have a query that shows 2 tables: "A" and "B"
Table A has several fields, B only 2. The tables are joined on these 2 fields.
3 fields called for the query, all from table a.
When i run the query i get data.
But where is this data coming from? I can find no Table A or B; i can find
no query A or B.
I am stumped. Can anyone help me?
Could be a few things. For example A and B are queries and not tables.
Whoops! You already eliminated that. Make sure to scroll left and right on
the d...using MS Query with iSeries ODBC and special caracter
I need help.
I found problems using MS Query with iSeries ODBC driver
when there are table o library named with special
caracters ("$" or "_")
I have a database in Access 2003 about Forest Inventory. I have data
collected from sample plots in a table (T_RawData1991-2001 – linked from
T_SamplePlotsDetails one to many). For each tree I have its SerialNo
recorded manually, so in a sample plot I may have 5 trees (up to 100),
serially 1-5. I have also recorded the distance and the azimuth of each tree
from the center of the sample plot.
Now, I want to have (using a query perhaps) the following results:
The distance combination between all Trees e.g. 1-2, 1-3, 1-4, 1-5, 2-1,
2-3, 2-4, 2-5, 3-1, 3-2, 3-4, 3-5, 4-1...Setting a conditional value in a query to perform an additional qu
Ok, I have a slight brain twister here and wondering if anyone could help
shed some light on this. :)
Im in the midst of creating a database that will hopefully replace a
paper-based system of storing 'shift runsheets' from a 24/7 office. There is
3 shifts per 24 hours; Morning (6am-2:30pm), Afternoon (2pm-10:30pm) and
Night (10pm to 6:30am). Each day it adds a new row of data to the table
"shift" and users can peform searches on previous sheets by searching the
table "previous" which links to "shift". When a user wishes to search, they
select the ...If Statement with Two Conditions
I'm trying to do an if statement with two conditions like the following
If a value falls between two dates then give it a value of 1, if not give it a value of 0. The if statement works well with one condition but when I try to do something like this = if (a2<=b2<=c2,1,0) it does not work. Help
Try something like
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Leroy" <email@example.com> wrote in message
Operating System: Mac OS X 10.6 (Snow Leopard)
How can I copy same info between worksheets?
You need to be more specific about what you're trying to accomplish... For
what little you've disclosed regular copy/paste will work, but storing
duplicate copies of the same data on multiple sheets [or in multiple
workbooks] is redundant & inefficient. I'm sure you're clear in your own
mind what you're trying to do, but these one-liners do not effectively
convey what you're thinking :-)
Also, it's fine to post multiple questions & use sepa...QUERY: export script
I am currently using Outlook Express to handle my POP3 mail however I
sometimes use Outlook too!
There are times when I want to export certain mail in a batch and save them.
Is it possible writing a script for Outlook Express to batch export mail and
save them each with a filename format of (YYMMDD_HHMM, year, month, day,
hour, minute - date-timestamp of the email ofcourse)??
If it is not possible under Outlook Express, is it possible under Outlook? I
have programmed Excel VBA before, so how easy would it be to program for
Outlook or Outlook Express? I have Outlook 97 but never seen an...Criteria Question
*I'm not very knowledgeable with Access*
I want to input a criteria for a query with a range of results, some are all
numerical and some contain letters. How do I create a range criteria for
example "11111 to 33333" or "H12345 to H23456"? The only way i have been able
to do it is very confusing, for instance I use Like
"[1-3][1-3][1-3][1-3][1-3]", which can produce the results but I'm not sure
if there is a better input strategy.
You can use Between with Criteria:
Between 11111 and 33333 (if a numeric field)
Between "H12345" and "...How can I host multiple domain with single EX2003?
Dear all, As titled...
Should I configure the server to bind another IP address to host another domain???
If yes, it's undoubtable to waste IP address....
Please help, thanks....
You mean multiple SMTP domains? If so, check out this article, which
applies to E2k3 as well:
For Exchange news, links and tips, check:
"Keith Ko" <Unavailable@127.in-addr.arpa> wrote in message
> Dear all, As titled...
> Should ...Sum of counted values in a query
I have a query which count the number of records in a table (as a
result of the menuoption view-> totals ->count) as a result of the
group by function for unique records.
The result is:
Now I want to insert a column3 which gives the sum of that counted
values. I'd tried something like: expr1:Sum(Count[column2])
The result should be for each record in column3: 33 (result of the
It doesn't work.
Somebody knows a solution ?
You can always writ...IF statements #5
In column A there are either values of "JR.", "CPA", "MD", or nothing. Can I
create an IF statement that says if there is a text value in the cell put
parentheses around that value and if there is nothing in the cell do nothing?
Any help would be appreciated
=IF(A1<>"","(" & A1 &")","") entered in B1 and copied down.
Gord Dibben MS Excel MVP
On Thu, 28 Jun 2007 09:46:03 -0700, Excel Function Application
>In column A there are eithe...Extract multiple cabs
How can I extract msp files from cab files with VBS? I have 99 cabs. Each
cab may have at least 1 or more msp files.
I'm trying to edit an older script I used to qchain updates years ago, but
getting "Expected end of statement" errors. That script is such a mess now,
it's not even readable or worth posting.
Any help or suggestions is greatly appreciated. Thanks -Steve
"stev379" <firstname.lastname@example.org> wrote in message
> How can I extract msp files from ca...Nested if statements Arrays
I basically have a collum of dates and I want to have a descriptive
cell with the range of dates. The dates are all entered from another
sheet by a user and this page is a summary page the formula looks
with A25 being the first date and the sequence of IF statements
determining what the end date should be. This works...How to round number to the nearest multiple of signifiance?
I have entered the formula in my cell, and I want my result to be rounded to
the nearest multiple of signifiance (for example 5). I have tried with
function CEILING and FLOOR, but these functions only rounds number
UP(ceiling) or DOWN(floor), so for this I have to know what my result is to
rounded it. That is not the solution, I would like for Excel to do it
automaticaly. Here is example:
If my result is say 117.49 and lower (to the limit of 115), I want to round
it to 115, if result is 117.51 and higher (to the limit of 120) to round to
120...(multiple of significance is 5).
Can it be done...POS (Not RMS) Database Query Question
Our owner would like a automated text message sent to his phone every 30-60
minutes with total daily sales.
If we create a query and have it run every 60 minutes, and the query results
sent via SQL Mail, that should do the trick.
What are the tables housing current daily sales totals?
Mark Kalmus wrote:
> Our owner would like a automated text message sent to his phone every 30-60
> minutes with total daily sales.
> If we create a query and have it run every 60 minutes, and the query results
> sent via SQL Mail, that should do the trick.
> What are the table...Passthrough Query
I have a form in a project DB that its source is a view (csp_UserNames) that
accepts parameters,but I would like to pass a parameter that the user types
in the form itself (USRNAME field) and then requery the form. If I put the
following in its source it works;
This returns all values in the users table
If I put:
Exec csp_UserNames alopez
It returns user angel lopez (the login ID is alopez for this user)
But I would like to pass the value in my form (Login_frm) field (USRNAME) to
the parameter so that when I type jsmith in the USRNAME field (afterupdate)
I would just do...Backup Database Queries
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: Exchange
I have several backup copies of my Entourage Database kept as Encrypted Zip files using PGP. <br><br>I recently inadvertently deleted my tasks and want to use the backup Database to get them back! <br><br>On Decrypting my backup it shows as Kind Document; how do I change the extension so that it shows in Finder as a Entourage Database? <br><br>Are there any suggestions about how I can then open the Database, Export Tasks and then re-open the current Dat...Returning Multiple values from A Vlookup
I need a formula to return multiple values from a look up table as the number
appears multiple times in a column.
Reference cell is $C$6 eg = 4101
Current formula only return the first one it finds
I need the Cell to return all the values it finds from the one code eg =
QCBD, QTNS/QCBD/QBMH/QMRE, QCBD/QAGW
Lookup table is TNI (A1:C1053) I need it to return all values in Column (C)
A B C
4077 All suburbs QRLE/QRLD
4078 Forest Lake QRLD/QLGH