PowerPoint 2007 / 2003 "Compare & Merge" crosswalk?
I cannot find the "Compare and Merge Presentations" function on 2007. The
tutorial says some of 2003 functions were lost, and you should check with
online help. Have not been able to locate anything equivalent or close in
That feature was removed from PPT 2007. It's back (and better) in PPT 2010,
though. PPT 2010 is in beta right now.
Echo [MS PPT MVP]
"Confused Presentor" <Confused Presentor@discussions.microsoft.com> wrote in
> I canno...How to create report from Pivot Table View of Union Query?
I have create a Union ALL Query. I want to generate a report from it.
The Pivot Table View of this Union Query shows exactly what I want (having
Row Heading, Column Heading and Detailed Data), so how can I make it as a
I have tried to create new report, but there is no options of making a pivot
(something like Crosstab Query and Pivot Table View of the Union Query).
Also tried to export to Excel, but it shows only count of records.
I want all detailed records.
Message posted via http://www.accessmonster.com
I tried to create a crosstab qu...Windows mail comes alright but then disappears
I run my Gmail thorugh Windows mail. The settings in Gmail is activated for
pop. The settings in Windows mail are “recent: email@example.com”. The server
port settings are 25/995. Furthermore I use Windows Vista, F-secure, Internet
Windows Mail arrives alright. To the inbox. I can open it and so on. Problem
comes when I have a look in another folder in Windows mail, such as sent or
junk. Then the newly arrived mail just disappears from the Windows mail. It
can still be found in the Gmail, but that´s not what I want.
What am I doing wrong...Zip codes in mail merge
Office 2007 - used spreadsheet to create an address list; zip codes appear
correctly in spreadsheet but when using spreadsheet as a mail merge document,
the first digit disappears in the zip code field, i.e., 05401 becomes 5401.
or use Word field formatting codes:
Mail merge Excel to Word:
e.. news:microsoft.publi...Thanks for all the help on Year-to-date query!
It's so great to know that there are folks out there that can take the
time to help someone whose 78 year old brain is slowly turning to
Francisco 9 @ ATT N E T
...Add Movie to Outlook E-Mail Message via "Web Tools" toolbar--question
Using Outlook 2003 (in fact all of Microsoft Office 2003), and have Word
selected as e-mail editor. Windows XP Pro with all updates.
Recently I discovered on the Office web site a way to insert a movie
(inline) to an e-mail message. I have one question about its implementation.
If (in an HTML-formatted e-mail, and Word selected as e-mail editor) with
the cursor in the body of the message, you click on "View", "Toolbars", you
can select a toolbar called "Web Tools". On that is an icon that says
"Movie". If you click on it you can add a movie to the e-ma...Query from Multiple Workbooks
I have 12 files in a directory with a sheet name Sales containing
Sales data for each month having more than half a million rows in each
The field names are all the same in all the files like date, item,
itemgroup, branch, unit, salesman, amount etc
I am looking for a way to get a query from all these workbook and get
a summarised report based on criteria like sales by salesman, by
month, by product, by product group, by date, by branch etc.
Is this will be possible through code?. Itry to use MS query but not
Using Excel 2007 and Win XP
...Forward mail through other smtp server.
I have exchange 2003 with sp1. My ISP started blocking port 25 and
forcing me to send mail through thier server. Is there any way I can
send my exchange mail through their server or curcomvent thier port 25
On your Internet Mail Connector forward your mail to their server instead of
using DNS (aka smarthost)
"Eric" <firstname.lastname@example.org> wrote in message
>I have exchange 2003 with sp1. My ISP started blocking port 25 and
> forcing me to send mail through th...forward exchange 2003 mail to external email #2
hi anybody knows how to do this?
i tried this but it didnt work
its ok now..i just create another account..and and configure an
external mailbox to that account..and then on the first account, i
just put a forward to under delivery options the another accoount..:>
...merging two accounts
This seems like something that should be easy, but it's
totally stumped me. I use my laptop at home and at
work. At work, I log onto a domain, so that I actually
have two accounts on my laptop: "username"
and "username.domain". So far so good. My problem is
that I use the same email accounts both at work and at
home. To avoid having two independent Outlooks on my
computer that check the same email accounts, I moved the
data file (.pst) locations of both accounts to one
place. This worked fine, and when I opened Outlook from
both accounts, it shows the sa...Query to Redistribute a Table
I am struggling with how to query a table with the current structure:
Field1 Field2 ...Field14 Jan Feb Mar Apr...
x y ...z 10 15 13 16...
It represents sales per month to customers per delivery adress,
product and so forth.The numbers under each month respresents the
sales for that month.
I need to be able to query so I can see all detalis (ie fileds 1-14)
per row per month, ie redistribute that original table so I can use
month as a field and still use all the original fields. My new table
needs to be something link
Month Field 1 Field2 ... Field14 New ...2007 dst issue
the client i support currently has about 20 exchange 2003 sp1 servers (mixed
FE/BE (mostly clusters) PF, BH)
i am putting a plan in place to move to sp2 early next year
i have since come across article 926666 regarding the post sp2 exchange
update for 2007 dst change
i have built a test environment to successfully create this issue
i have a 2003 sp1 dc and a 2003 sp1 server with exchange 2003 sp2 including
the windows dst update but not the exchange update
i then created a test mailbox and from outlook setup 5 calendar entries the
week of march 26 at various times
when viewing in OWA, al...Outlook integration issues
We're running Outlook 2K3 and the CRM client with ver. 1.2, when I try to import the contacts list it tells me that Outlook cannot be started even if it is running. Can anyone assist me with troubleshooting this issue.
...How to reorder email accounts in Mail view?
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: Exchange
Is there a way to change the order that email accounts display on the left side in Mail view?
sorry, you can't change that. The accounts are ordered alphabetically,
with the default account on top.
On 22/02/10 18:51, email@example.com wrote:
> Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor:
> Intel Email Client: Exchange Is there a way to change the order that
> email accounts display on the left side in Mail view?
Mi...CRM Report Issue
I designed a custom report to run pending activities & assigned
activities of current loggin user.
This report is running in report server and showing current user's
assigned activities. i am passing current user name in parameters as
@User Name from sql query. After deploying this report into crm. its
throwing an error message like this.
"An error has occurred during report processing.
The Value expression for the query parameter =91@UserName=92 contains an
error: Index was outside the bounds of the array"
The current user name passing from crm report as "...lost e-mails 08-24-10
I am losing my e-mails after I open them. They are disappearing from the
inbox . I believe they are still being saved somewhere, but don't know
where, or how to locate and fix the problem. Please help.. anyone.
While in the Inbox: View | Current View. Show All Messages should be the
only option checked.
Imperial Beach, CA
"len" <firstname.lastname@example.org> wrote in message
>I am losing my e-mails after I open them...Update Query ctnd:
I have tried the code from Arvin however I now get 2 paramater
prompts. The 1st is for "transactions.Datefield" and the 2nd "Please
enter Waiting or Pending"
UPDATE transactions SET transactions.Status = "Cleared"
WHERE (((transactions.datefield)<Date()-10) And
((transactions.Status)=[Please enter Waiting or Pending]));
Can I run this procedure atomatically when the database opens without
the prompts & user input
The first prompt implies that datefield isn't the actual name of the field
in your transactions table.
The second prompt...Can't access send/receive under mail setup
I am using Outlook 2003 with exchange. I want to add a pop3 account. The
Pop3 account sends but won't receive (although the Outlook test message is
fine). When I go to tools/options/mail setup and push the send/receive
button, nothing happens.
I have just installed a new hard drive. This worked on the old one, and on
other computers. I have recreated the profile from scratch but I have the
What's going on? Can someone help me?
Sammie SBS 2003, OFFICE 2003, XP-PRO-SP3, IE7
...Issue writing IF OR Error Formula Types
Having trouble putting a formala together.
I have the following formula which works:
Senario : $d$d = either weight or unit or unknown (of an ingredient)
e8= is a quantity number ( either in grams or units, o
an ingredient. eg 100 or 1)
Raw data is in nutrition!$b$6:$g$70
The following formula works so far:
f8 ( which is the no. o
But I also want to add to it that
If e8(quantity)=0 or blank or invalid then "qty?" should appear in th
And not sure what to do to avoid an error in f8...Query All records except latest
I need to limit my query to ALL RECORDS EXCEPT the most current record.
Any ideas on how to do this
It will look something like this, assuming no more than one record per date
per key field. You can adjust to use date/time if that is needed. It
depends on what makes your records unique. Try something like this,
substituting your table and fieldnames...
Select myKeyfield, field1, field2, field3, myDate
Where myDate < (Select max(myDate) from myTable AS T2 WHERE T2.myKeyfield =
"d...Discover card issues
I spoke with customer service tonight because after I connected to
Discover through Money, the logon page showed a different card #.
It turns out Discover is assigning new card #s (to what group of
cardholders I do not know). She did say the direct download problem
was fixed. And indeed it did download one transaction and opened a
new account with the new card #. It appears impossible to retrieve by
direct download the transactions that had been missing (due to
download problems) before the card # was changed. The fix I guess
will be an indirect statement download when the next statement...How do I print mailing labels?
By using word's mail merge.
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/
"ckjt" <email@example.com> wrote in message
Use Word... Mail Merge
Alpho...receiving double e.mails
In my inbox in Outlook everytime I get an e.mail there is always 2 of the
same e.mail coming through-Can anyone help me with this Please?
What version of Outlook are you using? Sounds like you may have duplicate
accounts pulling e-mail from your mailbox. Or perhaps a misconfigured rule
that is duping your received messages?
Ben M. Schorr, MVP
Roland Schorr & Tower
"Louise" <Louise@discussions.microsoft.com> wrote in message
>...MS Query cannot be started because it isn't installed
I'm trying to get External Data from SQL Server using my Excel 2000, but it
says MS Query cannot be started because it isn't installed. I've installed
the MS Query Add-in severals times and it's still not working. Does MS Query
work with Excel 2000?
...Create a Group Mailing List
I have created mail groups in the past, but now cannot. I have also read all
the directions on this message board, but nothing works for me. Help!
Why can't you? Are you missing the buttons on the toolbar?
Missing buttons from the Windows Contacts toolbar
Vista - "New Contact" and "New Contact Group" Button Missing
Imperial Beach, ...