E-mail viewing pane alignment
How can I make a email document that I have designed display in the email
viewing pane in the center? Every document that I have created and emailed
is aligned on the left in the viewing pane. I've received many emails that
are aligned center and would like to know if publisher 2007 is capable of
doing this or do I have to manually enter the html code to make it.
...trying this out
This is a test posting.
On Tue, 13 Nov 2007 16:06:51 +0800, "hmmmm" <firstname.lastname@example.org> wrote:
>This is a test posting.
Please use microsoft.public.test or microsoft.public.test.here for your
testing. This is a working newsgroup. If you have questions about an Access
database, please post them.
John W. Vinson [MVP]
...I am trying to round up to the nearest 25 cents
I am trying to round a money value to the nearsest 25 cents and it keeps
rounding to the nearest dollar HELP
In article <2DB8F007-1E27-4A48-923B-C7D4D0238B5E@microsoft.com>,
sypher <email@example.com> wrote:
> I am trying to round a money value to the nearsest 25 cents and it keeps
> rounding to the nearest dollar HELP
"sypher" <firstname.lastname@example.org> wrote in message
> I am trying to round a mone...Text wrap in merged cells
Is there a way to get text to wrap in cells that have been
merged. Example: A2:C2 are merged cells to get the width
needed. Text is placed in A2 that is greater length than
the merged cells. I would like the text to wrap but can
not seem to get that to happen if cells have been merged.
If the merged cells are A1:C1 and your text is longer than the merged cells,
then try merging cells A1:C2 and also ticking the wrap cells, and the unseen text will apper on row 2.
"Chuck Dorn" <email@example.com> wrote in message news:1df501c3e041$07386ba0$a50128...Trying to clear up Received but not invoiced report
I am trying to clean up the received not invoiced items. The problem
began with entering a purchase order and then not matching the invoice
to the items received agaisnt the purchase order. SO we thought that
doing a returned transaction entery would solve the problem. The only
thing is now the return shows up on our Received/ Not invoiced report.
And the report is becoming a huge mess and difficult to use. What is
the best way to clear up items that have been received but were not
matched and already paid through the invoice entery?
There is a knowledgebase article on this very thing av...Text in column causing SUMPRODUCT error
Greegings. I have a SUMPRODUCT formula that is having errors when one of the
columns has text instead of a NULL or a number. If I delete the text cells
in that column it works as desired. I'll give a simple example. Suppose I
have the following in A1:B6....
And I need this...
It errors out until I delete the "abc" in cell B3, then it works as desired.
I tried to replace the "abc" with a 0 by trying this...
And it works for that pa...locking a text box in a subform
I've got a form that looks like this:
I'm trying to code an event in a listbox in SUBFORM1 that locks a
textbox in SUBFORM2 if the user picks a certain item from the list.
However, I can't seem to get the code right in order to do it. I
If whatever Then
Forms!subfrm1.subfrm2!Listboxname.Locked = True
However it keeps telling me it can't find subfrm1.
On Aug 22, 8:55 am, jjmcl...@lakeheadu.ca wrote:
> Hi there,
> I've got a form that looks like this:...send/receive (2nd try)
New computer. Microsoft XP Home. Microsoft Office XP
Small Business 2002. Earthlink dial-up account. Two e-
mail accounts. After opening Outlook, 1st send/receive
(option 3, all accounts) usually prompts for both
passwords, downloads messages, all good. Next time,
though, no prompt for account 2, error cannot connect to
server, account 1 usually gets messages. Every five
minute send/receive option eventually degenerates to
cannot connect to server errors for both accounts.
Meanwhile internet browsing slows to a crawl. Any ideas?
...New History Item, Mail Message sends all messages as Rich Text Format
We are using Business Contact Manager 2007 with Outlook 2007. We are
not using Exchange server as a backend, just plain old pop3/smtp mail
servers. Problem we are having is when we open up an account, Click
on New History Item, Mail Message, and if we send an attachment with
that, the person that receives the message gets it in Rich Text
If we right click on the Email address itself and click on Send
Mail. The message will be sent out fine.
Right click on the message and looking at the properties of the email
address has the internet format listed as "Let Outlook decide the ...supressing the message box
I have an excel macro which has some msgboxs with relevant messages
according to some business rules. I want to display these conditionaly
only when the function is invoked by clicking on a button. I dont want
these msgs to appear when the macro is run from a .vbs file. Is there
any way to accomplish this?
Pls let me know - ill be greatly benifited by it.
Is there a way of setting a variable to handle this? (Perhaps in
worksheet cell) eg:-
Dim ShowMessage As Boolean
ShowMessage = True
If ShowMessage = True T...OnCtlColor, static text and read-only edit controls
I want to do something really simple (!) which is to change the
background color of a dialog. I've added OnCtlColor() which works -
except- it doesn't change the background color for static text
controls or for read-only edit controls.
So, for the static text I subclassed CStatic and made the text a
control variable and that works, but is that the only way? I ask
because I've got nearly 50 static text boxes and I'm lazy enough to
want to avoid creating 50 IDs and 50 variables if I can help it.
Regarding the read-only edit controls, I'm not sure what to do there.
I ...How do I cancel a msg Outlook keeps trying to send unsuccessfully?
How do I cancel an "in process" email Outlook keeps trying to send
unsuccessfully due to a huge email message I tried to send with way too many
attachments? It's stuck in "send" mode, and as a result, I can't send any
emails because Outlook cannot get past trying to send this message. How do I
cancel a pending outbox transmission while it's trying to send? I've tried
everything I can think of to no avail. Please help!
Angelczech wrote on Fri, 12 March 2010 07:32
> How do I cancel an "in process" email Outlook keeps trying to send
...Error: Can't Shift Objects off Sheet
I have created about 13 outline groups in columns. When I try to hide the
details on all of them, two of them hiccup and I get the "Can't shift objects
off sheet" for these two. I have cleared all the outlines and reentered them
and am still getting the error. Any ideas?
maybe this'll help:
XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
> I have created about 13 outline groups in columns. When I try to hide the
> details on all of t...Text fields in report writer
I have a modified report dictionary, when I go into a report layout and enter
a text field, when I tab off the field what I wrote is converted to something
totally different. Has anyone seen this before? Reports that I have been
using for months suddenly the text fields print something totally different.
????? Any suggestions would be helpful. Thank you!
We use a shared dictionary located on our server, and I find text fields do
not "travel" well - ie. I often lose info if I export a report out of the
dictionary to work on it.
What I do is make a copy of the enti...shift bid scheduling
I posted this question last week but now I can't find it so forgive me if
you have seen it. I work for a police department and am trying to figure out
a cleaner way to schedule our shifts. Basically we have 6 shifts two days,
afternoons and graves. The year is split into three sections. Each officer is
given their preference on what shift they want to work for each of the
sections based on seniority. there are a couple of stipulations. Each officer
can't work the same shift two sections in a row, SWAT personel need to be
distributed evenly between the shifts. ...Getting Tab Text
I have a Tab Control with Tabs.
I'm trying to get the Tab Text.
I can get the tab and set the text no problem.
But, when I try to read the text, pszText is alway's a <Bad Ptr>
If I immediately get the Item after I set the Item, It shows the Text.
//Initially setting Tab Text.
tcItem.mask = TCIF_TEXT;
tcItem.pszText = String.GetBuffer();
String.ReleaseBuffer(); //I don't think this matters. It fails both with
//Trying to get Tab Text
tcItem.mask = TCI...When grouping, what causes the error "Cannot shift objects off the sheet"
I am from the MS Excel support department at http://www.enterpriseprojectconsulting.com and we would be happy to assist you in resolving your issue
Enterprise Project Consultin
Shifting off the sheet refers to moving beyond the
boundaries of the spreadsheet. You may be using a macro to
Since grouping involves hiding columns, the following MSKB article may help:
XL: "Cannot Shift Objects Off Sheet" Error Hiding Columns
Also, Dave Peterson posted this a...Comment boxes #3
As far as I can tell, this cannot be done, but I figured it couldn't hurt to
ask...Can a comment box be "assigned" to more than one cell?
Michael J. Malinsky
"I am a bear of very little brain, and long
words bother me." -- AA Milne, Winne the Pooh
I didn't follow your question. Can you provide an example
----- Michael Malinsky wrote: ----
As far as I can tell, this cannot be done, but I figured it couldn't hurt t
ask...Can a comment box be "assigned" to more than one cell
...Text Box Calculation Formula
I have a text box (SpreadCred) that needs to be calculated/populated by a
combination of factors.
1. SpreadCred should populate off of the text box - InsideSpread.
2. The value in SpreadCred can not be greater than text box - RightMain nor
text box - LeftMain. If it is bigger than either number, it will max out at
the larger of the two.
Thanks for your time.
How this is done depends a little on whether the value will respond to user
input or to previously-entered data.
This could be done with a nested IIf, but is really a ...trying to insert a 0 in front of zipcode
Hello, I do not use excel at all so i have no clue!
I have a list of daycares that i want to create mailing labels with...about
700 of them but the problem is my zipcode column there needs to be a zero in
front of all 700 zipcodes how to i insert a zero in front of them without
having to type it into each box? the other question is can i print labels
directly from excel or do i have to go thru ms word?
One of these
1) format the cells with custom format 00000
2) format the cells with Special / Zip Codes
3) format the cells as Text
4) begin all zip codes with an sin...error message when trying to install WMP 10 or 11
My operating system is Windows XP Home Edition 2002. I'm trying to download
either WMP 10 or 11 and I get a message saying it was not possible to
complete setup, see webhelp for more assistance, however there is no
additional information when I click Web help. the Error message is 8007F0DA.
Can anyone help me? Thanks.
On Tue, 30 Mar 2010 07:54:01 -0700, Nate
>My operating system is Windows XP Home Edition 2002. I'm trying to download
>either WMP 10 or 11 and I get a message saying it was not possible to
&g...Combo Box Losing Settings
I have a combo box on a chart, the input range for which
is controlled by a VBA macro using ListFillRange and a
Whilst the book is open all is fine, but whenever I save
and close it the combo box loses its settings and when
the book is re-opened it returns a blank box with no
Currently using XP and I'm sure I didn't encounter the
same issue in 2000.
...Try or TRY
Will there be any opitmization or ... when we use INT or TRY macros instead
of int or try ? Which one is better to be used?
"JSmith" <firstname.lastname@example.org> wrote in message
> Will there be any opitmization or ... when we use INT or TRY macros
> of int or try ? Which one is better to be used?
Jeff Partch [VC++ MVP]
FYI, TRY ...Plain text message = sideways vertically printing
When I receive an email internally that is in plain text and then
print it, the email contents are printed sideways and vertically
(think the matrix). The odd thing is, the email header is printing
fine. This only occurs when the message is plain text. Printer is a
network HP 8150 which others print to and have no problems. Outlook
removed and reinstalled and user's outlook profile deleted and
--------------------------------- --- -- -
Posted with NewsLeecher v3.5 Beta 8
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -
...transform text field to a formulated SQL sentence
i'm trying to build a table that will consist of SQL sentences that
will a generic use for a query,
is it posible to transfor the text field to SQL sentence without
using VBA or ADO object?