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.
...format changes when copying from one cell to another
I'm sure this is simple, but it is not clear to me...
I am copying the contents of a group of cells that exist on one worksheet to
another. In Sheet2, I tell cell A1 that it should equal Sheet1's A1 value.
That works fine. But if the cell is blank on Sheet1, it comes up as "0" on
Sheet2. I figured it was probably assuming numeric formatting, but when I
right-click > format cell on both Sheet1 and Sheet2, both show up as
"general", so why would Sheet2 take a blank value and populate it with "0"
I gather than you are putting a formula in one...Controlling printed records when report bound to multiple tables
I created a report that uses the control from a form to generate a report
based on that record's primary key. This form also has a subform which has
relationships tied to the primary key for record identification and is linked
to the main table. When preview the report the data from the subform either
does not show up in the preview when using the filter
[control]=[form]![control].[value] or makes multiple copies of the report
equal to the number of entries in the subform's table.
Is there any way around this? I have tried queries but have not found a way
to use a f...downloading Avery labels templates
Operating System: Mac OS X 10.5 (Leopard)
I am panicking! I do volunteer work for an organization which includes sending out mailings to over 200 people. I usually print mailing labels from Avery label templates. Although I have done it in the past, I am no longer able to download Avery labels from their website. Does anyone else have this problem? Is there a way around it?
Downloading anything from anywhere other than a Microsoft site really isn't
an Office issue, so I'm afraid you're not likely to find an answer or a
solution here... Es...Receive mails from one adr. to several computers
I have a problem receiving mails from one adr. to 5
computers in a network. One of the computers get's all
the mails. They should all receive the mails.
All the machines run's win Xp and office Xp.
Outlook on all computers are set to store the mails on
the server, even though they have been received on a
computer. When I check my WebMail, the messages are still
...Permissions is not allowing me to use my print preview.
Help! Don't understand My Permission in Excel. Even though I unrestrict, it
still doesn't allow me to Preview my documents. How do I reset?
...Developing a robust database at one co. then using it at another c
Are there any legal implications of using the type of database listed above
to perform similar functions for another company? The 2 company's are in 2
totally different industries and the new database will have to be modified to
fit the requirements for the industry it is in. The database was developed at
the old company.
there is no such thing as a robust Jet database.
Move to SQL Server if you want to build a solution that will work for
the next decade.
Jet is and always has been depecrated
On Apr 7, 12:14=A0pm, BoaMan10 <BoaMa...@discussions.microsoft.com>
w...Can I make Undo remove more than a character at a time?
In Word 2007, after typing new or replacement text, Undo (whether by the
button in the Quick Access bar, Ctrl-Z, or Alt-Backspace) always just
removes 1 character at a time, which I find too slow for reverting text.
Is there a way to change this so Undo removes a word or other larger block
at a time instead of a character at a time? That's how it works in the
Outlook 2007 e-mail editor and I swear that's how it always worked in
previous versions of Word, unless I paused for a long time between each
character I typed.
Am I right that this is new behavior in Word 2007?
...Slow Response time after server move to AD
I've recently moved my Windows 2003 Server running GP 8.0 from a stand alone
server on a Novell network to a member server in Active Directory. The
response time from client computers has slowed drastically. It also ocurred
when the clients were part of Active Directory and the sevrer was still a
stand alone (workgroup).
Does anyone have any thoughts on what might be slowing the response time of
GP, primarily on customer screens.
...Printing in excel always comes out in bold even tho bold not on
When I print in excel my work always comes out in bold even though the bold
is not switched on. Any suggestions??
It could be a printer setting. Does it print in bold from other
"Scarlett50" <Scarlett50@discussions.microsoft.com> wrote in message
> When I print in excel my work always comes out in bold even though the
> is not switched on. Any suggestions??
No only when I have to type a report in excel - the actual report is ok on
other computers! but...Problems with reading date/time format from SQL server
I made a pivot table. I get data from external source - SQL server. On
of the columns is date/time type. For some reason unknown to me, Exce
doesn't read this dates correctly. Instead of dots between months an
days it puts little squares .. ?!? I opened the same file on m
coworkers comp. and it works just fine.
If anyone has already encountered this and knows how to fix it ..
Message posted from http://www.ExcelForum.com
There may be some difficulties getting external data properly into
Excel. If not done correctly you cannot use the data in formulae e....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 ...worksheet labels based on cell results
How can I build a macro to use the contents of several cells in a column to
label a corresponding number of worksheets with their contents. Ideally this
would also build links to the tabs so that a user could click on a specific
cell (in that column) and be redirected to the corresponding worksheet
for labeling the tab try something like
For the second question try using a Hyperlink (Insert - Hyperlink)
> How can I build a macro to use the contents of ...Printing in reverse order
I have printed out nearly 500 letters to be mailed out using mailmerge and
publisher. I would like to not run them through the printer again and print
address info on the reverse side so they can be run through a folding
machine and mailed out. PROBLEM: the list and the pages are in reverse order
and since I merged personal info on one side, the address side must
correspond. Can publisher print out in reverse? I have tried copies from
500 - 1 but it still print from 1 - 500. The original list was not sorted in
any manner, it was exported from a database. Suggestions please...
R...time formula question
This formula works great if the ending time is before 0:00.
$C$9:$C$11 is my starting time i.e. 20:00
$E$9:$E$11 is my ending time i.e. 04:30
How can I get this to work if A21 = 20:15?
"David" <dfizer@r...time line in chart
How do I put a vertical line in a chart in excel at a given point? i.e.
I know this is too elementary, but go from here:
You have a scatter chart from A1:B6
(X A1:A6; Y B1:B6)
A 2nd source series is A8:B9
(X A8:A9; Y B8:B9)
giving you the a vertical line at X=13.
"jon" <firstname.lastname@example.org> wrote:
>How do I put a vertical line in a chart in excel at a given point? i.e.
----== Posted via Pronews.Com - Unlimited-Unrestricted-Secure Usenet News==----
http://www.prone...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???
I'm attempting to print a calendar and I keep getting the message, "Cannot
load the printer driver." I have no idea what that means other than I'm
unable to print my calendar. Anyone have any ideas? I get the same message
whenever I try to print a card I've created. HELP!
The computer has been chucked out the picture window and the birds are
nesting in it. *sigh*
> I'm attempting to print a calendar and I keep getting the message,
> "Cannot load the printer driver." I have no idea what that means
> other than I'm una...Default reminder time on tasks
Does anybody know if there is anyway to change the
default reminder on the tasks window when it comes up to
remind?? It currently is at 5 minutes and I have some
users who'd like that to be a little longer because after
they tell each task to remind them in an hour, once the
hour is up it defaults back to 5 minutes.
Any help would be greatly appreciated!!
Sorry, but the default snooze time value is hard-coded and cannot be
MVP - Outlook
*** Replies sent to my e-mail address will probably not be answered --
please reply only to the newsgroup to preser...Address Auto Complete
A user of mine is looking for a way to get rid of the
address auto complete in his TO: field. Any suggestions?
email@example.com ha scritto:
> A user of mine is looking for a way to get rid of the
> address auto complete in his TO: field. Any suggestions?
What is the problem? You want only to disable it? Which version of Outlook
do you use?
Microsoft MVP - Office Systems - Outlook
We are running Outlook 2002. He wants to disable the
feature that automatically suggests an email address from
his Contacts list. Ex. when he t...multiple balances on one printout
I want to print all the months on one sheet. with a total, is this
possible and if so how do I do so.
...Recipient Address Popup
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: imap
How can I disable the popup for entering to, bc, bcc fields? I would rather just have the fields there in the new email window without any popup.
...How to merge columns and rows into one cell besides using Merge and Center Icon?
I had posted this question before, but I couldn�t find this thread in
any of the pages up till page 17. So I�m posting again.
I want to merge all rows and columns starting from A1 to J2, with no
lines in between into one cell. My text data value are in D1 and D2
respectively. Using Merge and Center Icon will only retain the
upper-left most data, resulting the data in D2 to be deleted. So how to
merge all rows and columns into one cell and yet prevent the data in D2
to be deleted?
Any help will be greatly appreciated.
~~ Message posted from h...