Printing a brochure on letter size paper
Does anyone know how to convert a brochure to letter size paper and have it
automatically fill the sheet rather than leave space around the outside of
I am trying to flip the document to a pdf using "pdf creator" and the
brochure appears as it would be printed on the paper with all the pages out
Thanks for any assistance you can provide.
Are you wanting to print to the edge of the stock? This will depend on your
printer's margin limitations. This article will help you determine your
http://ed.mvps.org/Static.a...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...scrollbar color
Is there any way to change the background color of the vertical and horizontal scrollbars in excel?
You can change the color of the scrollbars as long as you do not mean
separate parts like the scroller. Such changes will affect the color of
the worksheet tabs and background on menus as well, and it will
affect your entire system. Before making any such changes to your
Control Panel, Display Settings, would suggest you backup your
current settings within Display so you can fall back to them easily
because it can be hard to tell what you actually changed....Border Color
I have an excel sheet containing several borders with
varying line styles. The color of these is automatic
(black). I wish to change to 50% grey. The
format/cell/border menu does not appear to allow
wholesale change of color. Changing them individually is
not an option, since it would take a long time. Please
Here is some code to do it.
Select all your cells, then run this code
.Borders(xlEdgeLeft).ColorIndex = 48
.Borders(xlEdgeTop).ColorIndex = 48
.Borders(xlEdgeBottom).ColorIndex = 48
.Borders(xlEdgeRight).ColorI...Printing Problem with name tags converted to a new Publisher Docum
Mary Sauer, you were so helpful when you explained the Publisher "bug" to me
back when I was first testing the process of creating these name tags. Now
our seminar is next week and I've done the mail merge (which although looks
in "print preview" like there are 6 name tags with all the same name on each
page, actually print with 6 tags per page with a different name on each tag
like they are supposed to).
It's time for me to email this document to the person who is printing the
tags. I did the mail merge and instead of "printing" I converted it t...printing/changing margins
Operating System: Mac OS X 10.6 (Snow Leopard)
After setting the margins in page setup, the print preview shows it all to be there, but when printed, it is cut off at the bottom, thus leaving a larger margin than set.
Make sure that you have Office (12.2.3), OS X (10.6.2) *and* your printer
driver fully updated � check the mfr's web site. It wouldn't hurt to run
Disk Utility - Repair Disk Permissions after applying any updates.
If you continue to experience the problem you'll need to reply with a more
detailed description of the document's structure, t...View Excel Cells in Color
When a fill with a color an excel cell, the screen didnt show me the color
ive apply to cell. I have to click the preliminary presentation icon to see
the color i ve applyed. Is this an excell error? Why should i do to fix it?
The first thing I'd suggest is posting your question in the Excel newsgroup
instead of Publisher.
MVP Microsoft [Publisher]
"andres torres via OfficeKB.com" <forum@nospam.OfficeKB.com> wrote in
> When a fill with a color an excel cell, the screen didnt show me th...Please fix "You replied ..." issue when replying to received messa
In Outlook versions 2000-2007, when I start a reply to a message in Outlook,
as soon as the message is saved to Drafts the notice, "You replied on ..."
appears in the message I received. If I subsequently change my mind, or save
it in Drafts for a period of time, the "You replied ..." still stays as it
was when first saved. Thus, Outlook is inaccurately saying that I replied
when in fact I did not.
I read an MVP's reply from July 2005 saying this is not a bug. I don't
understand how a software application saving and stating inaccurate
information...Payables Check Printing Issues
A GP 9.0 client of ours is reporting the following two issues:
(1) History is printing on the payables check stubs despite the fact that
the Select Payables Checks window’s “Print Previously Applied Documents”
checkbox is unchecked and
(2) Multiple checks for each vendor are printing as “combined” even
though the “One Check Per” selection in Select Payables Checks is selected as
Regular SQL maintenance on the company database is running consistently
every week without error, according to the Windows App Event Viewer.
Have you...2007 Deluxe Share Price Issue
I manually enter all share transactions into Money, i.e. number bought,
purchase price and commission etc. I just went to update my shares, and
found that for one of my stocks the purchase price and number of shares
bought have changed for my historical transactions. The total cash value of
the transactions have remained the same, but the purchase price has dropped
and the number of shares increased. All transactions have change by the same
I noticed this because the number of shares for one of my stocks in MSMoney
is now different from the number that I actually hold, when they...Loan payment category issue
In Money2006 (UK), the mortgage loan payment has been categorised as a
payslip (with the principle and interest listed under wages - deductables
fields are blank). The total amount paid to the loan is listed correctly in
the total and the payment is correctly linked to the mortgage account.
However, the bill payment seems to be reverse - under the bill payment, it is
recorded as a negative deposit into the linked current account.
If I try and edit the bill series so the category is assigned as a loan
payment, M2006 asks if I really want to change this to a loan payment and ...AR & AP ATB print
Great Plains 9.0 - the ATB's for AP & AR - would prefer the option of
printing as portrait; not bolded; and be able to customize the colums. These
are double the paper from 6.0 (we just recently ufgraded). I find these hard
to read (print is small and the report is busy with all the lines and bold
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 suggestio...custom color palette does not get transferred with the workbook. Excel 2003
Scenario:We use a custom color palette with predefined company colors,
and excel 2003. Default workbook has also been modified to replicate
colors to new workbooks - located at %userprofile%\Application
NOw the problem: When users create a workbook based in the default and
email it to outside users who does not have the custom color palette
defined as default, the colors change - custom palette disappears and
workbook shows excel default colors,sometimes making the document very
difficult to read.
Also, if we email the document back to the origina...Report Taking a Long Time to Print
I have a main report with 2 subreports in it. One of the subreports seems to
be holding up the report when it comes to running and printing. When I run
the query and/or report for the problem subreport it returns data within 1
minute. When I run the main report, it takes anywhere up to 5 minutes to run
and about 12 minutes to print. When this subreport is removed from the main
report, running and printing is under 1 minute, so I know this subreport is
I had seen a post similar to this question and I tried the suggestions
(removing page breaks, turning force new page ...how can I print an invoice from outlook ?
Is there any way I can set up my 'orders' in outlook so that they can print
out as an Invoice or packing slip? I run a small business and don't have an
accounting programme at the moment. I have to manually type all the invoices
from the orders I receive. I know there must be an easier way - any help
gratefully received !
Or anyone recommend a small business programme which I could use?
"Bridget" <Bridget@discussions.microsoft.com> wrote in message
> Is there any way I can set u...SSN printed with extra dashes 1 time
I have a database storing soc sec numbers and names. The soc sec numbers are
entered on a form with a picture clause of 000\-00\-0000;0;_
I have a report (complicated format) that grabs information from the form
and prints out the Soc Sec Number. It has a picture clause of @@@-@@-@@@@
For one client and one client only, the SSN prints out 111-2-3--5555
All others print out 111-23-5555
Does anyone know why this happens. Win XP SP2 and Access 2003 system running
Thanks in advance
It is very probable that the SSN that has the problem already has the dashes
in it or is ot...linking colored cell
I have a worksheet(A) with data linked to a second one(B); when I forma
any (A) cell with a selected color, I would like to transmit the ne
cell color to the linked one in (B); suggestions will be welcome
Gerbatin's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1523
View this thread: http://www.excelforum.com/showthread.php?threadid=26867
Cannot be done unless Condtional Formatting is used on both cells to produce
OR VBA code.
Gord Dibben Excel MVP
On Tue, 12 Oct 2...How would I hire someone to help w Outlook issues remotely?
I have a lot of little bugs with Outlook 2007 and Windows XP and do not seem
to be able to find help. I have asked questions multiple times on this forum
with no help. Is there a way an individual can hire another individual to
come on my computer remotely and help with my little issues? ...or should I
just call someone like geek squad to send someone over?
please copy my email as I never seem to find responses on this forum and
when I login it says I have no responses. (I have also checked notify of
Your questions in this group, in Januar...[ANN] Entourage Calendar issues on Snow Leopard
Entourage Calendar issues on Snow Leopard (The Entourage Help Blog)
Snow Leopard has introduced new sync issues with Entourage Calendar events.
Let us know if these options help or if you have found a solution that you
would like to share.
Entourage-to-iCal time zone synchronization problems
Snow Leopard users are experiencing compatibility problem between iCal and
Entourage. When syncing with iCal the calendar times will change to be off
by a number of hours (depending on the time zone) from when they were
Entourage and ICal Calendar don't sync anymore after upgrade...Landscape Printing #3
Yes. We have the latest drivers. I installed this printer
3 weeks ago, and downloaded drivers from hp.com. It is
network printer installed on W2K server and shared. Used
by 15 users all running XP Pro. This problem is only with
2 workstations, but they are same hardware+installed in
same way and same time like all workstations. What else
can be wrong?
Hello, I have a bit of an issue.
I have 1 server on my network, running Windows 2003 and
Exchange 2003, which means it is a DC, DNS, DHCP, IIS,
SMTP, SQL, File, Print etc server. I am running all the
latest patches and service packs. The server has 1 IP
Address and 1 NIC. Exchange and OWA function as normal, I
am not using SSL.
When I try to connect to http://servername/oma I get the
following error, I have looked high and low and have come
up with nothing.
By the way I have already tried:
Microsoft Knowledge Base Article - 817311
Microsoft Knowledge Base Article - 818486
Erro...Outlook Attachment Issue
HI ALL Expert
I was not able to copy attachments to another new messages in outlook 2003,
would you please show me how to fix it. Thanks!
__________ Information from ESET NOD32 Antivirus, version of virus signature database 4259 (20090719) __________
The message was checked by ESET NOD32 Antivirus.
Any error messages?
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Outlook Tips by email:
EMO - a weekly...Using 'Print Preview' before Printing in IE 8
I am using Win XP Prof and IE 8.
I have a hotmail message that is actually a 'chain' of emails back and forth
so it is obviously more than one page but when I go into 'File, Print
Preview,' it only shows 'one page' with a footer on the bottom with the rest
of the emails 'cut off.' I only want to print one part of the email.
Why doesn't print preview show the 'entire' email with the correct number of
pages that I can 'page up' and 'page down' on.
I would like to be able to 'page down' to the page I...Publisher will not print multiple copies, other apps do? Help!
I have tried everything I know how to do. Publisher will not print multiple
copies, but other applications will.
What version Publisher? Doe the print fail in all Publisher projects? Have you looked
into an upgraded driver?
Will Publisher print multiple copies if you change the number in the printer folder?
Mary Sauer MSFT MVP
"sidewinder" <email@example.com> wrote in message
>I have tried everything I know h...Allow changing printer destination after you print to screen
Ehen printing a report, you cannot change the destination of the report after
you have seleccted to print. it would be great to be able to direct the
document to a specific printer with a dialog box.
I couldn't agree more! It is irritating that the printer
can not be changed once it prints to the screen.
Joe @ Aero Air
>Ehen printing a report, you cannot change the
destination of the report after
>you have seleccted to print. it would be great to be
able to direct the
>document to a specific printer with a dialog box.