Hi Patrick, [Office 2007 Mail Merge]
Okay Office 2007 has been changed considerably due to the tabs
instead of the menus.

With Office 2007 the sheets and ranges are both tables so is easier
in that regard. I've just updated there is now a new section.
http://www.mvps.org/dmcritchie/excel...htm#office2007
will need some finishing touches like what to save which would
probably be just before the last step where merge actually takes place.

Email me with suggestions.
--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"Bob I" ...
Don't have 2007, but it sounds like you haven't pointed it at your data
source.

Patrick wrote:
I've tried, and Word is driving me to use fields taken from name, addresses,
etc. in a small database. I need to link individual fields in the letter to
specific cells in an excel spreadsheet.

"Barb Reinhardt" wrote:
I've done it with 2003. I don't yet have 2007 so can't help you with that.

"Patrick" wrote:
Thanks, but this document is very outdated. I'm using 2003 at work and 2007
at home. The mail merge has changed since these directions were printed.

"Barb Reinhardt" wrote:
http://www.mvps.org/dmcritchie/excel/mailmerg.htm

"Patrick" wrote:
I need to produce a document (preferably in Word) that has fields that pull
data from an excel spreadsheet.

I'm producing a report in memo format that remains essentially the same
except for some data, such as number of people, some dollar amounts, etc.

Is there a way to have a running link in word, where I can change the name
of the file linked, and it pulls the data from the right cells, kind of like
a paste link in excel?