Contacts export display X400 not SMTPHi all,
I'm not sure if this behavior is by default or not, but when my users try to
export their contacts to an Excel file, any internal (domain) contacts show
the X400 address rather than the SMTP address.
Is there a way to change this? I've read some about VB scripts with CDO or
something, but hoping there is an alternate way.
Thanks
Mike
--
what version Exchange?
--
Susan Conkey [MVP]
"Mike W." <wallmr_snowpam@gmailDOTC0M> wrote in message
news:iQ72h.553254$Pi2.240974@fe08.news.easynews.com...
> Hi all,
>
> I'm not sure if this behavio...
Export to XML exports single row onlyWhat I did: On XML source panel of Excel 2007 added XML map, mapped to
columns using ranges (i. e. A1:A1825), selected “Export” from “Developer” tab
in the ribbon.
Result: Output XML file contains only one record (first row from the
worksheet)
I’ve done this numerous times in Excel 2003 with no problem. What happens??
Please help!
Thanks,
Eugene
...
Export / Import SecurityOk, so I have setup my test environment again. Now I have to create security
all over from scratch to define what will be used in production. Is there a
way to export from the test environment and then import it into the newly
upgraded installation? In both cases security has been/will be completely
removed from the 8.0 install (restored on new server) before being upgraded
to version 10.
Dear,
Security will be upgraded upon upgrading GP from GP 8.0 SP5 to GP 10.0.
Converting the Security structure from GP 8.0 to 10.0 will not be an easy
task.
Regards,
--
Mohammad R. Daoud
MCP, MCBM...
Exporting Sent Email Addresses from EntourageVersion: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
Hello!
I'm trying to export email addresses from an employee's Entourage, but would like to include email addresses in his "Sent Items" folder. Is there a way to export these email addresses aside from exporting the "MBOX" file, which has all the email content as well?
Thanks in advance!
On 3/12/08 8:49 AM, in article ee9381d.-1@webcrossing.caR9absDaxw,
"Quinlisk@officeformac.com" <Quinlisk@officeformac.com> wrote:
> I'm trying to export email addresses from an emplo...
Quickly moving down one row on pasted data from another worksheet.Ok, this should be fairly simple but I'm a excel novice. I have two
worksheets. One contains all data with each row representing a
different store. I then have another worksheet that is a form. I
need to fill out a form for each store. The information maps the same
every time, just one row down. It looks like this...
WORKSHEET1
A B C D E
1 A1 B1 C1 D1 E1
2 A2 B2 C2 D2 E2
WORKSHEET2
Name: =Worksheet1!A1
Company: Worksheet1!B1
Parts: Worksheet1!...
Excel XMLHi all,
Newbie here. I have an application that outputs Excel XML, auto-emailing to
a distribution list. This ended up working wonderfully, users can just
click on the attachment in the email and the file opens up in a great Excel
spreadsheet for them. Prior, we would only export delimited text files,
which had to be imported to Excel. Not hard, just extra steps.
However, I have TWO users that are on Macs. Their version of Excel on the
Mac cannot handle XML or read it. I've been Googling for days now and have
only found years old postings about how Mac's Excel left this f...
Export item ID?Hi there. Having resolved my previous EMS Data import issues, I have
now moved on to more complicated things (importing supplier lists,
aliases etc). However, these operations require the item ID for each
item - something I don't have. Is there some way I can export these
from the database so I know what item ID corresponds to each item. I
have run a query in Administrator (select itemlookupcode, ID from item)
which tells me this, but I haven't worked out how to export this out to
a spreadsheet. Any help would be appreciated, cheers
After running your query goto File menu and Export....
JWalk Chart Tools and hidden row problemHi,
I user JWalk Chart Tools to add lables to my bar chart that are
different than the actual values. By bars represent salaries whereas
the lables in each bars represent the salary increase since last year.
JWalk work fine... at least it does if you do not have hidden rows in
your data series.
I have about 100 charts that points to the same data series. The
issue I have is that I have to filter my list based on a different
criteria for each of the 100 charts. When you use a filter, Excel
simply hides rows and the excel chart is smart enough not to include
the hidden rows in the chart
H...
How to get needed data from XML documentHello.
Using VS.NET 2003(VB), .NET Framework 1.1.4322, ASP.NET 1.1.4322, WSE2.0 on
a WinXP Pro Sp2 computer.
I need help trying to extract the "TruckName" data from this XML document
(at the end of this request). I want the data after the equal(=) sign. The
data is the InnerXml and the OuterXml
I tried using this code, but it never executes the For Each loop.
Dim Trucks As XmlDocument =
GetList(XataNetConduitWebService.ClassType.Truck, orgID)
Dim truck As XmlNode
Dim nodeList As XmlNodeList
Dim root As XmlNode = Trucks.DocumentElement
nodeList = root.SelectNodes("//Tru...
Exporting email in Outlook ExpressI am unable to export all emails in Outlook Express. First
it had an error message mentioning MAPI so i followed the
instructions on Microsoft Knowledge Base to install
Windows Messaging - now when i try to export the following
error message is: MAPISP32 caused an invalid page fault in
module KERNEL32.DLL at 0187:bff7b9a6.
Does anyone know what this means?
tania jackson <tania@realtime-bs.com> wrote:
> I am unable to export all emails in Outlook Express.
Ask in an Outlook Express newsgroup.
--
Brian Tillman
Smiths Aerospace
3290 Patterson Ave. SE, MS 1B3
Grand Rapid...
Exporting to PowerpointI have a small table in Excel that I am trying to export
to PowerPoint, for some inexplicable reason one column was
always missing even though it was specified in the range
which the Macro is supposed to export. My manager is the
only was able to see the value in that column and no other
can replicate his success. Do you know any reason for
this? We are all looking at the exact same file, why
could he see something that the rest of us cannot?
Tao,
Why don't you simply copy and paste the whole table into a Powerpoin
slide?
Joh
--
Message posted from http://www.ExcelForum.com...
Export Image PackageI have an access application that has stored .JPG images within the database
as a "Package". How can I export the image back to a normal .jpg file so
that it can be read by a normal (non ole server) imaging application?
...
Export registry keyHi,
Is there an API to Export and Extract a registry key in a text format ?
I need to simulate the operation that is done by the user of exporting a key
(and creating a .reg file in a text format).
I do not want to use RegSaveKey/RegRestorekey which work in a binary format.
Yoav.
I believe you will have to do this yourself. There is no Automation or exported function interface
to RegEdit, and that .Reg file concept is a feature of that program. However, it shouldn't be
terribly difficult to do this, using RegEnumKeyEx and RegEnumValue or the CRegKey class, use a
CStdioFile object...
MDX query be persistence in an XML formatHello Gurus,
Need your help on following:
1. Whether an MDX query be stored in an XML format? e.g. can the below
query be stored in an XML file format: (the query is for illustration
only).
with set [PromoMonths] as 'Filter([Time].[Month].Members,
Not IsEmpty( ([Unit Sales], [Double Your Savings]) ) )'
set [PromoRange] as 'Head( [PromoMonths] ).item(0).item(0) :
Tail( [PromoMonths]
).item(0).item(0)'
member [Measures].[Uplift] as '([Unit Sales], [Double Your Savings])'
member [Measures].[This Quarter] as '[Unit Sales]'
member [Measures].[Last Quarter] ...
Highlighting Every Other Row - Conditional FormattingHello,
Here is my original post, which was very helpful:
http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.excel.misc&mid=6ab8403b-96bb-4c7d-bfb5-a602d4127bde&sloc=en-us
I am now using Office 2007.
When I try to use the formula =MOD(ROW(),2) for highlighting every other
row, it only highlights alternating BLANK rows. If the row is populated, it
will not highlight it.
Can someone help me figure out why this is happening & how to fix it?
Thanks!
NicoleS
Perhaps it is more strongly typed than earlier versions. Try this
formula inst...
Add Rows based on Cell contentsHi all,
I have a spreadsheet that starting at row 18 contains the following
information
A18=M$2
B18= Datavalidation indirect ($M$2)
C18=IF(B18="No More
Options",VLOOKUP($B18,INDIRECT(CONCATENATE($M$2,"_info")),1,FALSE),IF(B19<2,VLOOKUP($B18,INDIRECT(CONCATENATE($M$2,"_info")),1,FALSE),CONCATENATE(B19,"
x ",VLOOKUP($B18,INDIRECT(CONCATENATE($M$2,"_info")),1,FALSE))))
E18=IF(ISERROR(VLOOKUP($B18,INDIRECT(CONCATENATE($M$2,"_info")),2,FALSE)),"",VLOOKUP($B18,INDIRECT(CONCATENATE($M$2,"_info")),2,FALSE)*B19)
G18=...
Export from Excel to WordI have a 20 page Excel document that has a LOT of formating involved, it is
text not data. Is there a way that I get it into Word without having to redo
all the formatting? It is 11x17, landscape.
Yes:
Select the area you wish to copy.
While holding the SHIFT key pull-down:
Edit > Copy Picture...
In the Word document, just paste.
Because you have pasted a picture, the formatting will be preserved. Also
because its a picture, yo can re-size it as you choose.
--
Gary's Student
"kath0178" wrote:
> I have a 20 page Excel document that has a LOT of formating inv...
Reverse of export to databaseAve,
I would like to generate a Visio drawing starting from an Access
database which contains the results of an 'export to database' of an
existing drawing. I found import possibilities from Excel, csv, txt
files, but not from databases. I'm using Visio 2002 Professional.
Greetings,
Are you trying to import the data from the database tables or the database
schema?
If it is the database schema, run the Database modeling template (File \ New
\ Database \ Database model diagram)
If you want to get the data, try the "Link to Database" dialog (Tools \
Macros \ Visio Extras...
Export email addresses including aliasesHi
I have a medium organization with 5 different domains so each user has 5 to 10 email aliases. I can't find a way (an easy way) to export all email addresses into a script file so I can create accounts on our off-site anti-spam provider.
DOES ANYONE KNOW HOW TO EXPORT EMAIL ALIASES IN EXCHANGE 2000
Thank you, Shawn.
"Shawn" <slafferty@allcovered.com> wrote:
>I have a medium organization with 5 different domains so each user has 5 to 10 email aliases. I can't find a way (an easy way) to export all email addresses into a script file so I can create accounts on o...
how to write some xml into huge xml file into speceific location???Hello!
Is anyone can help me to figure out how to write some xml into huge xml file
into speceific location???
Say, i have a file about 139 Mb and i need to write some data (xml) into it,
but in speceific location (specified by XPath for example). i have tryed
used MSXML dom for it, but its eats memory like a twice bigger then my file.
Is any way to do that without that hurt?
thank you,
Xenia.
Xenia wrote:
> Is anyone can help me to figure out how to write some xml into huge xml file
> into speceific location???
>
> Say, i have a file about 139 Mb and i need to write some d...
ExportCan I add a control to my form that when clicked the form will be exported to
a pdf or mht file? I'm using InfoPath 2003.
Thanks,
Joel
I put this question in the wrong place. Sorry
"JoelS" wrote:
> Can I add a control to my form that when clicked the form will be exported to
> a pdf or mht file? I'm using InfoPath 2003.
>
> Thanks,
>
> Joel
...
Can I export my Publisher document into MS Word?Does anyone know how I can export my Publisher document
into MS Word?
Hi Matt (matthew_removethis_@mccallister.com),
in the Microsoft� newsgroups
you posted:
|| Does anyone know how I can export my Publisher document
|| into MS Word?
No you cannot. You can open one instance of Publisher and one instance of
Word and copy/paste between the two programs, or do a CTRL+Drag and Drop
between the two programs. Some formatting will be lost however.
--
Brian Kvalheim
Microsoft Office Publisher MVP
Official Publisher MVP Site:
http://www.kvalheim.org
This posting is provided "AS IS" wit...
Outlook export csv contacts screws up email addresses (why?)There must be a way to prevent Outlook from screwing up email addresses
upon import and subsequent export of a csv file into and out of the
contacts? But how?
Here's what happens consistently with Outlook 2003 on Windows XP.
I import this two-line csv test file into my Outlook contacts. Note this
test file contains an email address which is not in my company Exchange
server (apparently).
LASTNAME,FIRSTNAME,PHONE,EMAIL
Bar,Foo,123-456-7890,foo@bar.com
When I export these contacts, the result is a different format:
"LASTNAME","FIRSTNAME","PHONE","EM...
Add rows on worksheet by date?I've been asked to create a spreadsheet that will track vehicle miles
by route. The drivers will note the odometer when they start the
route and the odometer when they return, so we can log that across a
row:
Vehicle - Route - Odo Start - Odo End - Calc Route Miles
They also want miles by vehicel by day. Since a vehicle can travel
more than one route in a day, is there an easy way to do this? My
original thought was to have input through validation drop-downs to
choose teh vehicle and the route - now I'm thinking of using a Form,
and the Enter Data button will automatically sort by...
Morphed SKU Numbers on export to ExcelI am exporting an RMS Items report to Excel to send to my new on-line
shopping cart provider. One of the pieces of data needs to be the RMS SKU #.
I use a combination of 4 or 5 digit internally generated SKUs, plus the
typical bar code wanded numbers where items are manufacturer barcoded.
When the file opens in Excel, most of the manufacturer barcode SKUs are
morphed. Some look fine, but many are morphed with decimals and letters
included. The morphed ones do not appear that way in the RMS database. Any
ideas??
These look fine:
84692000135 Taylor's Vintage '03 Ruby Port
8...