Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Some fields show with their field names, others with F11, F12 etc
I am at the 'insert mail merge' step in Word 2003. I have my fields in the
top row of my XL 2003 sheet. Some of the fields are text, others are dates, others are blank. I just need the text fields to show in the list (after pressing the 'insert mail merge' button. The first few show okay but the rest show as F11, F12, making it hard to remember what that field was. |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Some fields show with their field names, others with F11, F12 etc
Please read my spiel on a "good" data source file:
Data Source Files For a mail merge, you need a data source file that contains a record on each item. For instance, a record might be one person's name and mailing address, or a part number with its dimensions and price. This data file can be in one of many different formats. It may already be in a Word table, an Excel file, an Access database table or query, a comma-separated file (CSV file), or other file. The data may already exist in your Outlook address book or Contacts folder. You do not need to use all of the information in your data file to perform the mail merge. You may have an employee list that contains addresses, but also contains social security numbers and salaries. Your data file can be left intact and information that isn't used can be ignored. You can continue to use your data source files for other purposes; using it to perform a mail merge in no way affects your existing file. The data source file must be formatted so that the column headings (also called labels or field names) are the first line or row in the file, and the first record is the second line or row in the file. Once you are certain that your data source file meets this criteria, you can continue with the mail merge. **************************** Hope it helps! Anne Troy www.OfficeArticles.com **************************** "Steve" wrote in message ... I am at the 'insert mail merge' step in Word 2003. I have my fields in the top row of my XL 2003 sheet. Some of the fields are text, others are dates, others are blank. I just need the text fields to show in the list (after pressing the 'insert mail merge' button. The first few show okay but the rest show as F11, F12, making it hard to remember what that field was. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
One field into many fields ? | Excel Worksheet Functions | |||
pivot field of fields | Excel Worksheet Functions | |||
How to combine dat from 4 fields into one field | Excel Worksheet Functions | |||
How to pull names and fields | Excel Discussion (Misc queries) | |||
Extract Portion of field into other fields | Excel Worksheet Functions |