Autofit row height in merged cellsI am producing reports that include comments, some lengthy.
I need several columns for most of the report, so I need
to merge cells for the comments to appear right on the
printed report.
Is there a way to get the row height automatically auto
fit?
I know this works with unmerged cells set alignment to
wrap text and row height to autofit, but once I merge
cells it stops working. Any help?
Also, is there a way make autofit work if the cell is a
formula that points to text?
My apologies to the group. After searching I see someone
else asked this question 11 days ago and was pointed t...
SQL deadlock problemI am currently having a big issue with sql deadlocking on the
PrincipalObjectAccess table.
The last few months I have been working on a synchronization process using a
Biztalk orchestration. The sync uses the crm webservices to create and update
account and contact records in CRM. But now deployment to the production
environment gives me some problems. It seems that when trying to update
account records (which is one of the first actions in the sync process) the
webservice gives me Generic SQL errors and SQL timeouts. After extensive
profiling and tracing in SQL I found that there are...
docmd.transfertext problemHi,
I am using access 97 and tried to import a csv file to the mdb table. I run
a code as following:
DoCmd.TransferText acImportDelim, "Specification4", "input",
DEFAULT_PATH & "online.txt", 1
In online.txt, there is a field which is 10 digit number and I specified it
as a double datatype in the specification4. After the import, I found out
that the 10 digit number data in the field get empty in the destined table
while other fields are all right. Therefore I import manually using
specification4 instead of running code. This time the 1...
Can I send a recurring e-mail automatically each weekI want to send a e-mail with the same verbiage to the same person once a week
and make it a recurrence with no end date. Can I set this up once in Outlook
so it is scheduled automatically?
--
Microsoft Office 2003 Version
Students and Teachers Edition
Windows Vista Home Premium
Thank-you
Happy new Year!!
Carl R
...
Exchange update problemI have tried to upgrade exch2k3 sp1 to sp2, but the update fails with "the
file pcproxy.dll is in use, and setup cannot identify the app or srvc. setup
cannot continue"
Any clues/ideas/suggestions? Please.
--
-----------------------------------------------------------------------------------------------------------------------
This message has been checked for all known viruses.
The information contained in this e-mail and any attachments is confidential
and may be the subject of legal, professional or other privilege. It is
intended for the named addressee only and may not ...
multiple Domain name delivery problemhi, I currently have Exchange Server 2003 Build 7638:2 SP2,. We have multiple
domain names being delivered to the exchange store. I have nothad any
problems, but i currently have one user that is not receiving emails with
attachments from one certain "internet" sender to one of her email addresses,
but the other address works fine & if they send emails without attachments,
everything works fine from either address. I have had the user send them
message with attachments to me & the user with the problem & i get the
message, but not the other user! I even use message...
Recieve Mail Before SendingHow do I set up Outlook 2003 to recieve mail before sending
Set your send/receive group settings to receive and not send. Or are you
talking about setting authentication?
--�
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
After searching google.groups.com and finding no answer:
Keith <anonymous@discussions.microsoft.com> asked:
| How do I set up Outlook 2003 to recieve mail before sending
...
[Exchange 2003] Mail enabled public folder and sender addressI have a Windows 2003 domain with a native mode Exchange 2003 organization;
there are some mail enabled public folders.
When a user replies to a message in a public folder, the outgoing mail's
sender address is the user's one; I want it to be the public folder's one,
or at least I'd like the "reply-to" address to be set to the public
folder's.
How can I accomplish this?
Thanks
Massimo
You would need to grant the user permissions to be able to Send As the
public folder. By default, when you reply to a message that is in a PF, the
PF is not composing the ...
Strange Access Denied Problem with Windows 7I got a new computer about six months ago that came with Windows Vista
Home Premium 64bit. Before that I had done all of my .NET development
either on an XP Pro VM or my former XP Pro computer at home. Shortly
after getting my new computer at home, I also got a license for VMWare
to be able to test my software on multiple platforms and
configurations.
I had wrote an application originally in VB.NET that was a simple
backup utility. It supports mutiple backup configurations. Any given
copnfiguration would define a backup which would be a list of files to
backup, a list of folders to ...
printing multi page newsletters with publisher 2000Created a new newsletter in publisher 2000, tried to print it on my Epson
Photo R1800 printer which supports up to 13x19 sheet paper and 13"x***' in
roll format and could not select a format to print pages 1 and 4 on one side
and then 2 and 3 on the other. Downloaded an instruction sheet from
Microsoft on printing "two 8.5-by11-inch pages per 11-by-17-inch sheet of
paper" It says on "file" click "print", choose a printer that can print on
11x17, then click "Book Printing Option" at the bottom of the dialog box.
Problem is this "Bo...
Mail lMergeSorry folks. I asked a question and went to the hospital for a while and
the question expired.
I have an address list in excel 2007 and am using word 2007. In my address
list I have a code column which should allow the selection of addresses to
put on labels. I used to have a query section what allows for that but I
cannot find query any more. can anyone help me?
charles
Questions here never expire, though it may become difficult to find the
answer. The previous post received one reply, from Doug Robbins, as follows:
See the article "Mailmerge Labels with Word ...
How can I change 'Normal' Style for Word e-mails to 'Normal (Web)'?Hi, I'm using Word as my e-mail editor in Outlook 2003 and want to change
the default Style for e-mails from 'Normal' to 'Normal (Web)'.
The problem is that new e-mails and replies in HTML format use the 'Normal'
Microsoft Word 'Style', and this has no gap after paragraphs. The upshot of
this is that when sending an e-mail, I have to press return twice to create
a gap, but when the recipient views this, their software shows it as four
gaps (the extra carriage return I typed + their correctly viewed HTML
carriage return after each line).
E.g. I type this:
...
How To Copy MS Word mailing labels into ExcelI have a word doc that I want to put into Excel. I want to add some
more fields to the names and addresses. Is this simple or do I have to
learn how to program?
Michael Rodriguez
City of Grand Prairie
Michael, have you tried to copy and paste the data into excel?
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **
"Michael Rodriguez" <mrodrigu@gptx.org> wrote in messa...
Can you only merge up to a certain number of cellsI am working on microsoft excel 2003, I have a sheet that I merged cells
starting with line 8 through 43...when I type my information in the merged
area I can see all that I am typing...say it goes up to line 30 once I hit
the enter key I can only see up to line 20. Even when I print it out it only
prints up to line 20...I have checked to make sure there are not locked cells
etc. I cannot figure out at all why this is happening...is there only up to
a certain number of cells you can merge?
From "Excel Specifications and Limits"
Length of cell contents (text) ...
Mails not appearing in Inbox although on Server and viewable by colleagueHi all,
I have searched the archives and found a few more or less related
topics to my problem, but unfortunately none of them helped.
Here's my problem:
I know that I recieve several mails at a specific time each day. Those
mails are sent to a colleague of mine and myself but only he recieves
them.
My admins looked on the Exchange Server and all say, that they can
definetely see these emails in the server logs and that the server
delivered them to the right mailbox.
If my colleague looks into my mailbox before(!!) I open Outlook, he
sees these mails as unread in my inbox. As soon as I op...
Border problemsNot sure why all of a sudden all my borders in my tables created with
Publisher can only be white. No other color will show when selected. Opening
a pub file done on another computer where the borders show color, shows white
only. I have attempted to do a repair on publisher, which gave no help.
Have attempted to uninstalled and reinstall Publisher without clearing the
problem. Anyone have any ideas or suggestions?
Look in the Accessibility Options in the control panel, display tab, disable
"use high contrast."
If that doesn't solve the issue, read the third FAQ here....
How do I merge cells with multiple data values?I've tried highlighting the two cells which are in the same row. It
suggested that I format and align. Both of which I've tried. I keep getting
the same error message, "The selection contains multiple data values. Merging
into one cell will keep the upper-most data only." I need to make the cells
one with all my information. Is this possible?
Not knowing what you want to do, let me make a suggestion. Put all your
data into the first cell and leave the second cell empty. Select both
cells. Click on Format - Cells - Alignment tab. In the "Horizontal" b...
why are links to websites (inserted in publisher documents) disab.why are links to websites and e-mailadresses (inserted in publisher
documents) still working in emailpreview but disabled in webpage preview?
...
Excel ProblemI have a 23.8 meg excel 2000 spreadsheet set for manual calculation saved to
my local hard drive. Every time I try to open it, it takes forver and
sometimes never opens but I do not get any error messages, let me just tell
you that I am running a P4, 1 GB memory, Office 2K with SP3, and nothing else
running when I try to open it. As I said it is set for manual calculation,
and it is cleared to not auto calculate when opening or closing. Any idea's
as to why this is happening?
--
Todd
I don't know why you're having this problem but I would like to point
something out for w...
White PrintingHow do I print white text onto black paper? The text just comes out blank
when printed. I am using a black background on screen to see what it looks
like, then deleting that so I can print in white.
On Mon, 12 May 2008 18:46:03 -0700, PJ1980
<PJ1980@discussions.microsoft.com> wrote:
>How do I print white text onto black paper? The text just comes out blank
>when printed. I am using a black background on screen to see what it looks
>like, then deleting that so I can print in white.
Interesting.
Does your printer have a WHITE ink cartridge?
NO?
You can't do it.
Ther...
SOAP ExceptionHi,
In my C# code, I have defined a Map object which is sent as part of a
request to a web service, here's an extract of the part of the code:
-
Map map = new Map();
map.item = new mapItem[4]
{
new mapItem(),
new mapItem(),
new mapItem(),
new mapItem()
};
.................
But when I submit the request containing the Map object, the compiler
throws an error with the following message:-
org.xml.sax.SAXException: No deserializer for {http://xml.apache.org/
xml-soap}...
Outlook 2002 XP SP 3 Archive problemHi there
I am trying to get my newly configured outlook to archive my folders.
I have ust configured it to download two POP email accounts and that
works fine. I have set up a set of folders below my outlook (Personal
Folders / pst) inbox node and placed the relevant emails in the
corresponding folders. I have gone into tools -> options -> other ->
and pressed the "AutoArchive..." button -> and set the "clean out
folders older than" selection boxes to "3" and "Months" and pressed
the "apply these setting to all folders" button.
I ...
Merge- top to bottom not left to rightI ahve a list of over 300 names that i am tryiing merge onto a ticket
format that carries 8 tickets to a page. Problem is when I try and
merge I get all the same name on the 8 tickets each page 300 times. I
want to have each name only once --or 8 names per page. If I merge and
change the format by taking and changing each of the 8 tickets ( name1,
name2, name3 etc.) That turns into me ahveing to change up all my names
by moving them from top to bottom and going left toright.
If I could just merge them eight at a time in each column that would be
great.
Since you say your list contains over 3...
How do I copy data in single cell format to a merged cell formatI need to copy a list of data in single cell format into a spreadsheet where
those same columns are merged cells (with four cells merged into one).
I have several hundred lines of data so some way of copy & paste (other than
each cell individually) would be appreciated.
Thanks
Paul
Hi Paul
What I would do is copy format of sheet with merge cells to blank sheet then
copy single cell data to sheet with merge cells select single cell to paste
you lose formatting so after just copy format from blank sheet created earlier
I find this easiest way
Hope this helps
Tina
"Paul" w...
HELP in printing A3 size newsletter-magazine which has a centerfold.hi! i want to print a newsletter magazine in A3 size. so that means, the
newsletter must have a paper size of H:17" and L:11". When i set the paper
size in mspublisher to A3 portrait, the centerfold expands to h:22"....
which consists of two A3 size papers.... how can i correct this so that
each page will print like two short bond papers combined in the middle?
also, how can i set mspublisher to print without borders? in my printer
setup, there is a borderless settings. problem is, if i select that, some of
the layout will be cropped out in the borderline.... so it look...