I want to print a 26 page 5.5 X8.5 booklet
I want to print a a 5.5 8.5 booklet in publisher. I'm using 8 X 10 paper
and printing in the landscape mode, but I'm having a difficult time getting
the page order right when I print the book out. Can anyone help?
calpoet <email@example.com> was very recently heard to
> I want to print a a 5.5 8.5 booklet in publisher. I'm using 8 X 10
> paper and printing in the landscape mode, but I'm having a difficult
> time getting the page order right when I print the book out. Can
> anyone help?
How exactly do you plan on getti...Printing LOTS of emails
I have to print a lot of emails - possibly several thousand.
I have a macro that sends them to the printer, but is there a way I
can read the contents and write them to a text file? I'd like them to
look as much as possible like the actual printed copies do.
It seems I MIGHT be able to open a text file, then write out the
relevant fields, like:
Open OutMail for output as 1
for each MailItem
a$ = mailitem.field1
if len(a$)>0 then print #1,a$
if len(a$)>0 then print #1,a$
Print #1, "End of this mailitem"
Will this...A program is trying to automatically send e-mail on your behalf.
I tried posting this in microsoft.public.outlook.general, but no
Does anybody know how to turn the "A program is trying to
automatically send e-mail on your behalf." prompte off?
It pops when one of my MS Access apps is emailing one of it's reports
It happens on the Citrix server that one of my MS Apps is running on,
but it does not happen when the app is running on my own PC.
Consequently I'm hoping for some user-configurable setting that
Is there any way to create a template where a contact is
automatically CC in the email. So I dont forget to cc them
every time I send an email.
...Money 2006 constantly faults with automatic updates
Whenever I use the Internet automatic updates, money faults out and wants to
send a report to Microsoft. Also my account list shows most accounts with a
status of 'Update In Progress'
I've done a complete reinstall after removing it and power cycling my
machine. I thought it may have been something with removing 2004 and
installing 2006, but got same problem
Has anyone else been having this problem? I really just want to go back to
What's the error message?
Glyn Simpson, Microsoft MVP - Money
Check http://money.mvps.org/faq f...selecting qty to print via textbox entry
I've been searching for this, but cannot find it.
Simply, I have a userform to generate label printing. User enters the
info, then in textbox4 will give the quantity to print.
All I need is the script that will change the Number of Copies based
on the entry of Textbox4 when the labels are printed.
I'm not sure what you are wanting to print. I assume a sheet. If it's not a
sheet, I would recommend reading about the PrintOut method in the VBA help
section. It would help if you post the code you are using and give specifics
of your application. ...Unable to Click on Links - Puplisher Email
When I create a document in Publisher and send it via Publisher's
email function, most people can click on the links in the document.
However, I have a friend who uses Outlook Web Access (OWA) to get her
email and although she can see my document, none of the links in the
document work for her.
Would appreciate if you have any ideas for me on to resolve this
Michael J. Titera
...Q: Print Preview
Can anybody show me some example code on how to call a print preview from an
SDI application in a dialog. That is, I have an SDI project which has a
dialog called via the toolbar. The is a button on the dialog which, when
pressed, should show the print preview.
Many thanks in advance
The view class has several functions to do this.
Your default AppWizard MFC framework for SDI apps will already bring up the
print preview and all, except it will be blank.
The OnPaint or Draw function you override to do your drawing of your view,
will contain a CDC, which has a member function IsPr...Links in a spreadsheet
I have a spreadsheet with about 10 worksheets. One of the worksheets ha
a link to another excel spreadsheet, however i know how to identify th
location of the spreadsheet, but i don't know where the link is- as i
which cell and how to break the link. Please can anyone help.
Message posted from http://www.ExcelForum.com
try Bill Manvilles Link Finder:
> I have a spreadsheet with about 10 worksheets. One of the worksheets
> has a link to another excel spreadsheet, however i know how to
> iden...Automatic axis format
I'm need to make a automatic axis format within excel.
The number of rows is depending of a imported file.
No problem to get the max. number of rows.
But to put this number into the chart ( category axis) is more problematic.
I try VB but my knowledge is at dummy level !
Waiting for your reply.............
Have a look at Jon's examples of dynamic charts.
> I'm need to make a automatic axis format within excel.
> The number of rows is depending of a imported file.
> No problem to g...Edit document date on a posted sales document
Our client would like the ability to edit a posted sales documents document
date. They indicated they would like security available to the option so that
only specified users could change the date.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft...I open the MDB, the form runs automatically
I have an MDB file with 20 files and 7 forms in it.
When I open it up, the form runs immediately an access goes into some
sort of protected mode. I can't view the tables, queries etc. I can
see the code by pressing Alt F11 but not the data.
I created a blank db and imported the mdb so I could see the tables.
But how do I open the original without it running the code?
When I look at the code. I don't see anything that sets properties or
invokes the code automatically.
There are no macros in this, just the forms and associated code with
...Automatic updates, automatically disabling itself
Automatic updates, automatically disabling itself.
2nd day now onecare popped up to tell me the updates turned themselves =
I'm thinking what malware would want to turn the updates off ?
Any idea what's going on here ? Did I AUTOMATICALLY install an update =
caused this ?
<firstname.lastname@example.org> wrote in message
> Automatic updates, automatically disabling itself.
> 2nd day now onecare popped up to tell me the updates turned themselves
Drop OneCare and install Microsoft Sec...can't change print styles
In outlook 2003 when I try to change how a calendar prints, I click
file-page setup-daily style - I get an error "unable to display dialog
box". Any ideas as to how I can fix this? It happens with all the
headings under page setup.
...printing excel sheets duplex, make margin stay on one edge
I wish to printa large nummber of excel sheets in duplex (printed on
both sides, portrait) and then bind them on one side. I cannot find
the method to make the margin stay on one edge so that I can bind it.
As there is a lot of data on each page I wish to use the maximum
printing width and have the margin only on the side that is bound. Am
using MS Excel 2000 and a HP laserjet Thanks Jim
...How do I get an automatic equal sign to begin the formula bar?
How do I get an automatic equal sign to appear in the formula bar in Excel
for Microsoft 2003? This happened for me in the 2000 version and I could
just click on it with my mouse pointer, but now all that appears is the
function sign with no equal sign after it. It makes my job a lot more time
consuming to have to type in the equal sign while building formulas. Please
The = icon disappeared in newer versions of excel (xl2002???).
You can add an = icon
Tools|customize|commands tab|Insert category
(Scroll down the list until you find the = icon)
And drag it to your fav...My worksheet automatically adds a fill color when I enter text.
When I type text in a blank cell, the cell automatically is highlightes with
the bright yellow fill. There is no conditional formatting on this workbook.
Check your VBA editor.
You might have an Event Macro which does what, usually, a CF does.
Try to Increase the Macro Security to its maximum level in order to
eliminate the Event Macro from running...
You may, also consider to "rem" all the Macro commands by adding a Preceding
apostrophe to each command.
> When I type text in a blank cell, the cell automatically is highlightes with
> the bright yello...Help with printing one name on a report
On my Form that has No Record Source I have a Combo Box [cmbHorsePlanner]
that has a row source
SELECT qryHorseNameActive.HorseID, qryHorseNameActive.Name FROM
And next to that Combo Box I have a Print control that prints my form that I
only want the one name that I select from my Combo Box
My Report is rptHorsePlanner, I suppose I will need a requery or Dirty so I
can change selections to print a Report!
Thanks for any Help...........Bob
What is the Record Source of the report. Assuming your report is based
on a query, then I think all you will need to do i...Having numbers automatically appear bold
Had such great advise last time, thought I'd try again.
I have a large range of cells where I will be inputing sales figures i
the form of currency revenue. The range is about G-I and 1-400. Th
sales data will be a comparisson of YTD 2001 - 2004 revenue results.
What I hope to do is have any figure that is above $30,000 appea
automatically in bold so as to stand out as a good client. I gues
there is something in the IF function to do this but I'm stumped.
Thanks again in advance.
Message posted from http://www.ExcelForum.com
select the range you wa...How to create a new document by clicking open?
**** Post for FREE via your newsreader at post.usenet.com ****
I'm using VC++ 6 and my problem is that I have a program (MDI) that displays
images whenever a user clicks on the open button (on toolbar or menu).
Everything works fine, until the user closes the MDI child window. The way
my program works is that he now needs to click on 'File > New' to open a
blank window, then to click on 'File > Open' to open the image in the newly
created window. The user cannot open an image directly with the 'open'
button if a blank window is not already created.
How ca...Is it possible to automatically move data entered in columns into rows?
Is it possible to automatically move data entered in columns into rows?
It seems like a simple thing to do but I can't find a function anywhere.
If you enter something in ONE cell it is automatically in a row and a
column. So, perhaps a bit more explanation is in order.
"Richard Thorneycroft" <email@example.com> wrote in message
> Is it possible to automatically move data entered in columns into rows?
What causes the left margin to be "chopped off" when
printing emails from Outlook Express? How can I fix it?
"Teddi" <firstname.lastname@example.org> wrote in message
> What causes the left margin to be "chopped off" when
> printing emails from Outlook Express? How can I fix it?
Why do you need to print emails in the first place?
This newsgroup is for support of Outlook
97/98/2000/2002/2003 from the Office suite of products. Outlook
Express is actually a separate program despite the similar nam...How to set DEFAULT print options in Excel to print gridlines?
I would like to set the default page setup to print gridlines so I don't have
to go tell it to print the gridlines every time I do a new document. Any way
to do that?
Create a template called Book.xlt with the default settings you
desire. Store this file in the XLStart folder (typically
C:\Program Files\Microsoft Office\Office\XLStart ). This template
will be used to create any new workbook.
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"LKR" <LKR@discussions.microsoft.com> wrote in message
news:B644E...Determine if a linked cell contains data
Using vba I'd like to change the formatting/colours on a particular cell
if the cell contains text.
So for example:
If Application.WorksheetFunction.IsText(Cells(i, ColNum)) Then
Cells(i, ColNum).Font.Bold = True
Cells(i, ColNum).Interior.ColorIndex = 40
This works fine for cells which do contain text but not for cells which
contain 'linked text'. I have some cells which are linked from a 2nd
sheet and in the 2nd sheet they contain text.
The code above does not work because there the cell contains ='Sheet2'!B93
How can I get ...CE6: How to Disable SIP popup automatically
I know SIP popup can be disabled by the following registry setting in CE5:
But It doesn't work in CE6.
How to disable SIP auto-Popup in CE6?
The SIP Auto Deploy in CE is due to Windows Controls invoke SHSipPreference
(exported by AYGSHELL.DLL).
So the easiest way is to avoid including AGYSHELL (SYSGEN_AYGSHELL)
But if excluding AYGSHELL is not an option, you may need to modify the
SHSipPreference (PRIVATE\SHELL\SHELLPSL\HAVEAYGSHELL\shellpsl.cpp) to supress