Simple Mail Merge Question

M

Melanie

I have a letter that I want to merge with an excel
spreadsheet. When I open the letter in word, Mail Merge
is not an option to me. Why is that?

thanks for any help,
-Melanie
 
G

Graham Mayor

In order to use a letter as a merge source document, yhou will need to tell
Word that it is a merge letter and attach a data file to it. Up to Word
2000, this was relatively simple, using the merge wizard; with Word 2002
things became a little more complex - although the following link uses
labels as a start point, the essential premise is the same for all merge
types. You may find it helpful to use the suggested merge toolbar to assign
the document type and add the data file - see
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm


--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Mail Merge Directory Conditional Page Break 0
Merging from an Excel file with graphics 1
Paste / Hyperlink multiple Excel Spreadsheets to a Mail Merge Excel Source Document 0
Grouping {MERGEFIELD} into 2 or 3 Columns 0
ASK Field Formatting 1
Anchor issue with inserting a shape for letterhead 1
Insert name and adress from a list in a word document 1
Windows 2016- Unable to do mail merge with my secondary email accounts 1

Top