How to shift address listings from row list to columns?
I have a mailing list with name, address, city, state & zip with each item in individual rows like a list of labels and a few empty rows of space between each listing. How do I create/transfer this list into columns accross so I can sort by city or zip? Thank you!
If your data is nicely grouped,
with each group in 5 lines, viz:
then an earlier suggestion given
which worked might be worth a try:
Please reply in newsgroup
<at>yahoo<dot>com for email
--...stack fault error when browsing address book
I have a problem that occurs when browsing the address
book "Contacts" that results in the error message:
OUTLOOK has caused a stack fault in MSPST32.DLL
and the termination of Outlook
I've updated the Win98Se and the Office 2000, tried the
steps in the KB218853, and searched the newsgroup and KB
to no avail. Also tried the Inbox repair tool
(scanpst.exe) which found only minor problems and repaired
them. I can look at the entire "Contacts" folder in
Outlook without problems. This does not appear to be
related to any contact record.
...Import vCard file to Outlook #3
I have Office 2007/Outlook on Vista. I want to import a vCard file of
contacts which has been exported from jPilot on Linux. When I try it
imports the first contact, not the entire file of contacts. Questions:
-Can Office 2007/Outlook on Vista import vCard version 3.0 format,
or only the earlier version 2.1 format? (I can use either).
-Can Office 2007/Outlook on Vista import a file of multiple vCards?
Can it import a set of individual vCards in a folder? In any case, how
do I get a bunch of vCards into Outlook?
gus <email@example.com> wrote:
> I have Office 2007/Outlook ...Need help getting files from Exchange Server.
We have a computer that had an account on Outlook
attached to a Microsoft exchange server.
Apparently for the moment, this computer and the
server are inextricably tied together. Outlook cannot
even be started without logging into the server
because information store or whatever is missing.
How do you get the information out of the exchange
server to wean the computer from it?
tom <Spamblocker@ameritech.net> wrote:
> We have a computer that had an account on Outlook
> attached to a Microsoft exchange server.
> Apparently for the moment, this computer and the
> se...when i save a file that i have worked on, excel7 closes down work.
i have recently purchased office pro 2007.
Excel 2007, when i save a filethat i have worked on, excel closes down and
work is lost, done all updates, re installed from disc, please help i have
lost 2 hours of work this moring that i need for a report
a few questions:
1. what happens with save as?
2. what happens in safe mode? (hold shift key while starting excel)
3. do you have add-ins?
4. what operating system? x64?
"rob" <firstname.lastname@example.org> wrote in message
news:0483F09B-3289-42B4-8849-0C0A61380B11@mic...Just saved file, cannot be found. ?
Even Global search ?
Win 7 ...
if you saved it, it should be in the mru list? what version of excel are you
"Boswell" <Boswell@discussions.microsoft.com> wrote in message
> Even Global search ?
> Win 7 ...
> Whatz up?
one other question, how did you open it, outlook email? if that's the case,
search will never find it. it is probably here:
C:\Users\Your user name\AppData\Local\Microsoft\Windows\Temporary Intern...Outlook contacts #16
When I am creating a new email and I click on the "to" box - a list of my
contacts pops up. Many of the contacts are duplicated - the reason being
that one is for an e-mail address and the other is a fax number. If I try
to find out which one I have, by going to "properties" it opens the
contact's file giving me all of their info. How can I get only the e-mails
for my contacts in this list? And what if the contact has more than one
Thanks in advance...
Geoffrey Ungar <email@example.com> wrote:
> When I am creating a new email and I click...Excel 2003 file freezes laptop
I took a laptop away from the office and tried to open a large spreadsheet
on the local C: drive. Each time I tried the laptop froze and had to be
rebooted. When I connected back to the LAN at work, and opened the same
file on the local C: drive I had no problems.
What could cause this? If there is any corruption is there a way to
decompile or something as you would in Access?
...How to change .pst file location on hard drive(s)?
I want to move my .PST file c/w archives to a partition other than C:\. How
can I do this with Win Live Mail?
"Machinist60" <e_john_wilson.no.spam.@hotmail.com> wrote in message
> I want to move my .PST file c/w archives to a partition other than C:\.
> How can I do this with Win Live Mail?
> Thanks, John.
I didn't realize WLM utilized the .pst file. I had to convert my .pst file
data into the Windows Mail format and then import the data into WLM. Please
explain what you...Unattend configure Send/Receive Group / PRF file -Outlook XP
Have to rollout 4000 laptops with Offline Storage enabled. I want to
automatically configure outlook to:
- use OST file
- Synchronize when logging on and off
- Download and sync. the general address book
I have made a PRF file (using CIW) that creates OST file...so far so good...
But I can't unattend set the option to sync when logging on and off. It
seems this setting is stored in an SRS file in the users profile!!
Second item, default the first address book in the list is synchronised.
Is there a way to auto configure Outlook XP to sync OST fiel when logging on
and off, (ins...How to search against XML files in the file system?
Putting the search textbox on the page is the easy part. What's preferred
way to find terms in XML files located on the file system?
Like finding stuff saved in XML files some of the blogs use these days to
store their blog items? There can be lots and lots and lots of XML files on
the file system to search.
<%= Clinton Gallagher
NET csgallagher AT metromilwaukee.com
> Putting the search textbox on the page is the easy part. What's preferred
> way to find terms in XML files located ...OT: managing file fragmentation on external USB backup drive (SBS2003)
Just wondering how others are managing file fragmentation on their
external USB backup drives (SBS 2003)? I have two WD 500GB drives that i
rotate weekly (each backup is around 55GB currently) but periodically
the server will "freeze" during a backup (fans on, but no response at
all) and requires a hard reboot to get going again.
The first time it did it, i had no idea what caused it, but on
subsequent occurrences I narrowed it down to the external hard drive
itself - after the reboot, simply trying to access the drive via Windows
Explorer on the server caused the se...setting up multiple email accounts #2
I followed the rules for setting up the pop3 and smtp
accounts for multiple mail accounts, but when I access
outlook express the additiona account does not recognize
the password I've asked it to remember. HELP!
KCB <firstname.lastname@example.org> wrote:
> I followed the rules for setting up the pop3 and smtp
> accounts for multiple mail accounts, but when I access
> outlook express the additiona account does not recognize
> the password I've asked it to remember. HELP!
Ask in an Outlook Express newsgroup.
...Recovery excel file
Anybody knows if there is any free tools to recover a advanced excel
file (using macro, graphics, formulas, and several formats)????????
...Contact list not recognized as an address book in outlook email
I installed Outlook 2007 on my computer and imported my addresses from my
other computer's Outlook file with excel. The contact list shows all the
addresses but I can not access the contact list when I try to send an email.
The address book drop down menu does not show anything. I tried to do the
"properties" on the contact file, selected the tab "Outlook Address Book" and
I am not allowed to check the box to "Show this folder as an address book".
I am hoping someone can help me get this resolved. Thank you in advance
If you have Contacts in...How do I export, then import my address book(contacts)
I want to share my Outlook 2003 contacts and groups with my husband's Outlook
2003 I would like to export my contacts and groups to his computer. Then I
would like for him to be able to merge my contacts and groups with his
already existing contacts and groups. How can I accomplish this? I have a
friend who wants to do the same with Outlook 2002? Would the procedure be
the same for both versions?
Please give steps, I am not very computer literate.
Thank you so much.
Export your Contacts folder in PST format via File | Import and Export |
Export to a file ...
Then, copy them ...Open 2003 files with 2007
I just upgraded my Office 2003 with Office 2007 on an EP Pro machine. The
only snaffoo I find(so far..) is with Excel 2007. When I double-click on an
Excel 2003 file, Excel 2007 starts up just fine, BUT my file is not
displayed. At that point if I click the Restore button up at top-right, the
file appears when Excel is restored up or down, then all is well. Anyone
have any idea whats up with that and how to fix it???
Lots of people have complained that when they doubleclick on a file in windows
explorer, that the workbook doesn't seem to show up in xl20...copy rows to another file
I have following code,i need to copy desirde rows to new file (r.xls) on
This code is able to copy desired rows from active sheet to sheet2(same
file) based on values in column G.
Would you please guide me?
Dim arrParts() As String
Dim MyRange As Range, CopyRange As Range
Dim LastRow As Long
LastRow = Cells(Cells.Rows.Count, "G").End(xlUp).Row
Set MyRange = Range("G1:G" & LastRow)
response = InputBox("Enter rows to copy in the format nnn,nnn,nn")
arrParts = Split(response, ",")
For Each ...Appending XML to an existing XML file
Hey all, I've read a few articles about speed and XML processing - so I just
want to make sure that I'm using the right strategy for what I want to
I have an XML file that I'm appending to every time a user submits their
Right now I'm using XMLDocument (Load and Save) in conjuncture with
Is this the right approach or is there a faster approach?
PS Here is a simplified version of what I'm doing:
XmlDocument xdoc = new XmlDocument();
XmlNode node = xdoc.SelectSingleNode("...How do I export .dba calendar files from a Palm Treo to Outlook?
Chapura won't do it. Something about a problem with calendar files.
...File Naming for Picture Order
I want my photos within a folder to appear in a certain order and want them
in numberical order; however, when I put them in numerical order and get past
9 (into 2 digit numbers) the order gets all whacky.
> I want my photos within a folder to appear in a certain order and
> want them in numberical order; however, when I put them in numerical
> order and get past 9 (into 2 digit numbers) the order gets all whacky.
1, 2, 3,.....10, 11, 12...
0001, 0002, 0003,.....0010, 0011, 0012
If you are batch renumbering the f...stationary, templete, signatures with multiple accounts
I use Outlook 2002 to access three email accounts ( Work, Hotmail, and home
Obviuosly I can choose from which account I'm sending from at the time of
mesasge creation. What I am asking is, is it possible for when, let's say, I
choose to send from my work account, a certain stationary and/or template
and/or signature is used ----- and a different stationary and/or template
and/or signature is used when I send from my ISP, etc.......
Please advise, preferably be sending directly to email@example.com.,
or by replying to this post.
Thank you in advance !!
O...Outlook Express address bk. from Mac to Outlook PC ?? Help
I am trying to export the address bk from my Outlook Express (Mac OS 9.2) to a form that my Outlook PC (Windows XP) can read and use. Any thoughts on what procedure to follow. When I export from the Mac it just saves it as a "Simple text" file - no much good for what I want to do. Any thoughts???
...How to get the handle of a Help file belonging to other process.
In my application,I want to change the Index of a HTMLHELP
file which belongs to a dialog running in other exe.In order to do this
I need to find whether the Help file is open or not & get the handle of
that to use HH_DISPLAY_INDEX .Is there any way to do this??
Note: I dont want to use FindWindow() as it is giving rise to some
problems in my application..
Thanks in advance
...Another multiple criteria/column question
Ok, first post and pretty much a new user to Excel. I have two sheets
that I am working with, trying to recall data from one to the other
that meets criteria. In a nutshell:
Sheet 1 contains a column of unique values (col A), cols C,D, and E are
where I want to insert the formula to find data on Sheet 2.
Sheet 2 contains 4 columns, A contains multiple occurrences of each
value (from Sheet1, column A), each with its own timestamp in column
On Sheet1, in column C, I want to find a value on Sheet2 in column A
and return the timestamp in column D. I know I can use VLOOKUP for