I've created a custom label for printing addresses from a
database.  The only problem is that it will only accept 4
labels vertically.  The labels are 1.5" x 3.9", two
columns to a page, and there is plenty of room on the

can you help me with this formula?:
if either CELL 1, CELL 2 or CELL 3 is NOT blank, OR if
CELL 4 is not equal to 'Service Plan', enter "ok to
proceed", otherwise don't enter anything.

People,
I have a couple of templates in which usually the value of a field is
pulled in automatically. Now the organisation wants to have the
situation whereby if the value in a specific field is blank, the value

WOW, that's great help, I have two more scenarios that
relate:
1) Just like your response { IF "{ MERGEFIELD cell1 }{
MERGEFIELD cell2 }{ MERGEFIELD cell3 }" = "" "" "888" }

I have completed a factory inspection and recorded issue
details in an excel spreadsheet. A Word document then
merges the issue details into formatted reports.
In addition to the details of each issue there is a photo

Can i use more than 1 database to format my mailmerge?

I'm doing a mail merge from an excel document.  The
preview merge looks fine, but when it goes to final merge,
only every other record is included in the report.  Anyone
know how to fix this?

I have set up four tables per page in a Word Document. I am trying to merge 70 records from Excel into the tables. Instead of getting records 1 - 4 on page one and 5 -8 on page 2 etc... I am getting one record in all four tables on each page, basically I end up with 70 pages. ...

I am merging sheets of labels in Word with an Exel file,
but the blank labels that have no records are retaining the
words "Field Museum of Natural History" which is in the
main label merge document.  I have tried placing this line

We're trying to merge in currency fields from excel, the cells are set up to
display $0,000.00  when actually the value could be $0,000.00000000  as seen
in the formula bar.  When merged into word that's what we get 0,000.0000000
when we only want $0,000.00.  Help says that the data ...

I have a long document where the same data has to be
retyped throughout in different places. I thought i would
be able to use form fields and bookmarks to copy the entry
the first time i enter it to all the other fields.

I would like to limit the no of pages or no of records in
a mail merge process, perhaps using Macro. Any idea how
to do it?
Thanks for your help.

I am attempting to use mail merge to create mailing labels
(data taken from an Excel spreadsheet).  There should be
214 total labels created. Instead of creating the first 14
labels on page one and then starting page two with label

I am trying to merge a password into a hyperlink.  The merge seems to accept the url but the merged field is not hot.  
The merged field appears in the Word version of the docoment, but does not show in the hypertext.
Any ideas?

I am doing a mail merge using excel and word. Some values
in the excel document look like this: 4000.03999999999.
Even though it might round in excel to 4000.04, when i do
the mail merge in word, it still looks like