How do you get the number format from an Excel data source to translate into
a Word mail merge document in XP?   It's taking the raw data (i.e., 9 decimal
places for a # from a formula instead the formatted 2)

Is there a way I can use an IF statement to tell the length of a
particular merge field?  I'm thinking of something like
LEN(mergefield).  Does such a thing exist in Word?  I can't even think
that a macro would help me...

Word 2000 & Excel on XP:   Excel Xmas card list to Word label mail merge. The
result is that the zip field jumps up in front of the First_Name field and
the Last_Name field disappears.
30071 Joe

Is there a way to insert ClipArt on each Label during a merge without
copying and pasting into each label?
Thanks

I have created a form template document that has both checkbox and text form
fields.  When I merge this document the check boxes come across, but the text
fields disappear.  Does anyone know if this is normal and if it is, is there
a fix so I can get my text fields back?

I am trying to print 6,000 personalised documents to a HP8150 laser printer.
If record 1 is male then print from tray2
if record 2 is female then print from tray 3 and so on.
Unfortunately, I need to print the whole 6,000.  I cannot split the job into

I am trying to create a directory merge and have some questions:
1.  Is there any way to have merge fields a header?  I am merging from a db which is managing the export/merge operation and handing the desired fields to Word (Word 2002).  I have put the fields in a header, but ...

Hi I am using windows XP And Office XP. I have a document created in
Microsoft Word called Monthly News.doc . It is obviously a monthly newsletter
for my company. Each month I send it out as a mail merge to 250 people on my
mailing list. I have a macro called Send_news that ...

Has anyone experienced quesion marks appearing in a merged document to
email? I'm using the merge in Word 2000 with a vb script.
Thanks,
Mike Elder.

I've done many mail merges from excel to word.  All of a sudden when I try to
open data source it tells me that it can't establish a DDE connection to
excel.  Anyone know what that means and how to fix?

What are steps to bring up an excel spreadsheet in "Browse"? al

Date appears OK in Access table ( 15 Jun 2005)but appears incorrectly in word
doc. (6/15/2005) Regional settings are OK Help please!

I have written a VB app that creates images according to their part# (ie
1.jpg, 2.jpg, 3.jpg ...) and stores all of them in a temp folder.
The app then makes a DataDoc.doc (with boring things like PartName, Material
blah blah) and includes the image-path-name, by using ...

I have created a form which I am going to mail out to members of a group. I
am merging from a member database to fill out the form as much as I can.
This is for renewing membership into the club. I have a field called
family/single in my database which has an "s" or  a "f" in it. On ...

I am trying to duplicate the results found in the example given in MS
Knowledge Base Article 294686, and can't. I have created an Excel data file
exactly as shown in example, and created the Word document using the
instructions supplied. I have copied the commands listed under ...