Contacts export display X400 not SMTP
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.
what version Exchange?
Susan Conkey [MVP]
"Mike W." <wallmr_snowpam@gmailDOTC0M> wrote in message
> Hi all,
> I'm not sure if this behavio...Excel 2003 Inserting current date
I wish to create a spreadsheet that whenever data is entered in a
row/column, the actual date is entered automatically in a date column. I do
not want the date to be overridden.
Right-click your sheet tab and "View Code".
Copy/paste this event code in that sheet module.
Enter anything in any cell in column A and B will get a static date.
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
'Col B time will not change if data in Col A is edited
On Error GoTo enditall
Application.EnableEvents = False
If Target.Cells.Column = 1 Then
n = Target.Row
...Export to XML exports single row only
What 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
I’ve done this numerous times in Excel 2003 with no problem. What happens??
...Access vs Excel
I wanted to get the opinion of both the excel and access group on this
We currently have an ERP but is lacking in some aspects. In order to get
around the shortcomings, I have an user that is very proficient with excel.
He has made spreadsheets that access the information out of our ERP and
mimics some of it's functions.
He is using excel to store information and has created interfaces for users
to enter in data.
My question is, should we continue using excel to do this. We have hundreds
of excel files that get created with information everywhere. OR should we
start using acc...How to do a dynamic plot in Excel via VBA?
Hi I want to write a code in VBA in which a dynamic set of rows ( the
number of columns is fixed to 4) in excel are to be read and a plot
type: " xlXYScatterSmooth" Could someone help me figure out how to
write this one? thanks
How is the number of rows specified?
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
"Wal" <Walid.Ramady@gmail.com> wrote in message
> Hi I want to write a code in VBA in which a dynamic set of rows ( the
> number...Excel graph, don't show 0
I'm creating an excel scatter graph (excel 97) based on data in an
The data is as follows:
jan feb mar apr may ...
(Y Axis)Output 6000 5855 4881 0 5000
(X Axis) M2 55 58 61 0 50
I've created a range to define the source data:
A1 = the current month, so for example if a1 = 5, it'll take 5 columns
to the right (up until may)
Now, all this works fine except for the 0 values in april. These drop
my chart all the way out of the picture, and I'd like to simply exclude
these valu...Quick create sequence/order/display...
Is there a way to change the order that fields are displayed when performing
a Quick Create on a contact?
It looks like right now when a contact is created in Quick Create it
displays the required and business recommended fields in a single column
displaying these items from the standard/full create new contact page in a
manner going from left to right then down. The layout in the
create|new|contact form is the way the customer likes it, but if you open
the Quick Create you get a list like: First Name:Phone number:Last
Name:City:Address:etc... As you can see, a very awkward order.
Is ther...Excel to Access
Does anyone know how to take an Excel spreadsheet and
merge it into an existing Access database?
...Export / Import Security
Ok, 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.
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
Mohammad R. Daoud
MCP, MCBM...lost Excel data!
I've just deleted some important data from an Excel sheet
having moved it to another workbook. Unfortunately I
closed the new workbook without saving and I can't find
the data! I've not got a backup of the old workbook and
the data is not on the clipboard. Is there any way of
AFAIK, NO. We all gotta learn sometime (to make backups)
"MrBen" <firstname.lastname@example.org> wrote in message
> I've just deleted some importa...Exporting Sent Email Addresses from Entourage
Operating System: Mac OS X 10.4 (Tiger)
Processor: Power PC
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 email@example.comR9absDaxw,
"Quinlisk@officeformac.com" <Quinlisk@officeformac.com> wrote:
> I'm trying to export email addresses from an emplo...problem with scatter diagram excel 2007
Have 2 data columns with 800 data points . I highlight the data and select
the xy scatter diagram from the chart options. The graph that is produced
plots the y values against the number of data points and not the x values in
the column. However when I click on the "select data" option and "edit" the
series that was created, the data ranges for the x and y axes are the correct
Help will be appreciated
Isn’t that what it’s supposed to do?
I have just put up a scatter chart at:-
It’s item...purchase requisition error: you are not set up in approval hierarc
We are on Great Plains 10. All of a sudden today, all users are getting this
error when they create a new requisition.
I validated that the approval hierarchy is defined with all employees. The
company record in Business Portal has the approval hierarchy defined on it.
I am getting this error across all companies in Business Portal. Kindly help.
Thank you for using Newsgroups!
I understand you ahve some users that are receiving the message, "You are
not setup in the approval hierarchy..."
I have some things for you to check to make sure the system is set up
correct...Fonts get size 1 and can't be changed after a procedure
I have been using code to loop for each chtobj in a worksheet to set font
size right etc.
Sometimes an error occur and the size become 1 pt. I can live with that once
or so, but I can't change the FONT BACK neither with code nor from excel
chart GUI. No code are running in background during this of cource, I try
even to change the font from Excel GUI with macro switched off. It can only
be solved with building a new chartobject...
Have any of you got this error, any knowing why it occure and what I can do
I thougt it was because some of the charts had no values or s...Excel XML
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....Excel 2002, now 2007
I was previously using Excel 2002 and decided to buy Home and Student
non-commercial 2007. I am having problems converting my 2002 files to 2007
and also do not seem to be able to upload the files thru 2007. I'm thinking
because it is non-commercial, Excel 2007 non-c does not want you to upload to
a website. Okay, can I purchase an upgrade of just Excel 2007 so that I can
convert files and upload to my website? If I could I would go back to using
my 2002 version I tried loading it again but the computer says it does not
find a MS product to upgrade...
...Exporting email in Outlook Express
I 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 <firstname.lastname@example.org> wrote:
> I am unable to export all emails in Outlook Express.
Ask in an Outlook Express newsgroup.
3290 Patterson Ave. SE, MS 1B3
Grand Rapid...Big Endian Byte Ordering
I have a question about big-endian byte ordering.
I know that with, for example, a WORD value, big endian byte ordering puts
the two bytes in the reverse order that little endian does, which is used by
What I don't know is what happens in the case of structures. For example, I
know each member in the structure has its bytes reversed. But are all bytes
of the structure reversed?
I'm trying to figure out how to convert a structure data type fo big endian
and I don't know if I can simply reverse all the bytes, or if I need to do
something more complicated like jus...Getting this message when i startup excel 2003
Getting this message when i startup Excel 2003,
C:\Program Files\Adobe\Acrobat 5.0\pdfmakerA.xla could not be found, i have
Acrobat 6 on my computer,
i have tried the repair and it still comes up, i have unistalled from add
and remove, then reinstalled office 2003 but it still comes up when i start
Go to Tools-->Add-ins, and uncheck it.
"Brian" <Brian@discussions.microsoft.com> wrote in message
> Getting this message whe...Missing Report Manager help file
I run Windows XP home and Office XP Professional. Sometime last year I
installed Report Manager add-in for Excel. In March 2005 I had to do a
reinstall. Since then, when I click on View>Report>Manager>help I get a
message stating that the XLMAIN8.HLP file cannot be found. The utility
is checked in the Add-On dialog box. As I still have the download in
the My Downloads folder I have even tried reinstalling the utility
again but still the help file remains lost somewhere. Can someone offer
some advice on what to do next? Where could the file have gone? How can
I get it back...Export Image Package
I 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?
...Excel 2000 Security patch crashes Excel
I recently upgraded my computer, although I am still using Excel 2000.
As part of the upgrade, I decided to be good and updated all the
available service patches for Excel 2000.
I later tried opening a file that I have created and work with
extensively - and Excel crashed. Something that never happened before.
I tried opening the file on a different computer - and it worked just
So I began debugging to find what the problem was - I stripped out all
the VBA, and then I stripped out the worksheets one-by-one, until I
came upon the root of the problem. I had a picture inserted, with a
hyper...Problem with Excel 2007
Hi Everyone, It is my first time working on Excel 2007. I was working on a
project which I started on Excel 2003, I opened another project for reference
and when I returned to the first project all sheets disappeared. The only
accessible buttons on the toolbar are the Macro buttons. All macros are
still there and sheet names in the VBA are still there. Did I loose my work?
Thanks to all
Hi Everyone, It is my first time working on Excel 2007. I was working
> project which I started on Excel 2003, I opened another project for
referen...How to create "frames" in Excel 2003?
Is there a way to create frames in Excel like one can do for webpages?
For example if I split my sheet vertically, I want a frame on the left
side which has "links" that if I click them change the sheet I'm
viewing on the right side.