I need to reference (via a Word field) data in a cell in
an Excel worksheet. I've tried the {Link} field but this
pulls in the entire sheet. I just need the text from one
of the cells. Any ideas?

 I'm using Word 2000 and have a question about the logistics of Mail Merge.
I have a Form Letter generated in word and have specified the source of the
data to a tab-delimited text file. Now whenever I generate the mail merge
document, Word picks up data from the previously ...

is there a way of running a macro from inside a merge? I
know there's the MacroButton field, but that only seems
to work as a double-click event. Also, is there a way of
moving to a particular part of a document from inside a

I'm try to mail merge a document to fax but the option is
not available, i've tried different fax applications
(MightyFax, SmartFax, WinFax) but none seem to solve the
problem.  Suggestions?

Help! Only one thing is standing between me and data merge Nirvana:
the ability to merge directly into formatted text boxes. I've got text
boxes overlaid on a background graphic in a non-linear layout (former
graphic designer ;), and I need to merge my data into them. Problem

I was looking for some tips and your site is great. I
found many tips and excellent
tutorials/FAQs that helped me during my development. But I
need to hide the

Its been 3.5 years since my last ASP VB mail merge of Word with an Access document
Set wdDoc = wdApp.Documents.Open("C:\InetPub\Test\_docs\MyFile.doc"
wdDoc.MailMerge.MainDocumentType = wdFormLetter
wdDoc.MailMerge.OpenDataSource ,,,,,,,,,,,"DSN=MyTest","SELECT * FROM MyTable

Hi, OK, first I would like to extend thanks to Charles for
the help with my previous dilemna.  Now I am running into
another issue.  I want to do "custom envelopes" where they
will appear like business envelopes you would have done at

I have created a .txt file from another program. I can
open that file with Word; however, when I use mail merge
and click to open that file, the message says it can't
open. No other explanation. The first record in that file

I have written a letter in Word and would like to use
data from Excel, but not to include the decimal places in
the letter. In the Excel field there are decimal places,
but I do not want this to occur in our letter.

I'm having myriad problems with mail merge since I
upgraded to Office XP. My OS is Windows XP.
I have an inventory database in Acces that used to merge
easily and correctly with my Word files for labels,

I am doing a mailmerge with an Access table as the data
source (only 3 fields, however!). The document uses each
field twice. When I preview, I see all 123 records; when I
print or merge to a new document, I only get every other

I have a mail merge document with the number field of an address in it.  
Unfortunately I think the field is being imported as text and the number
has leading zeros sometimes.  I think this because when I try to use the \#  
formatting switch it has no effect.

I have a numeric field defined as text. Acres, such as
45.7.
when printing the field using mailmerge the field will
print as 45.7 or 45.699999999999* or 45.6000000000000*.

I have some clients who have recently upgraded from Word
97 to Word 2003. They have a number of mail merge
documents originally created in Word 97.
The merging data is contained in a seperate Word document