Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2003 Mailmerge €“ Address fields
I am mailmerging a standard letter to an Excel data source and using the More
Items link in the wizard to insert the fields. I am keeping the Database Fields checked and do have the fields from my Excel spreadsheet available. What are the fields that are shown when I click the Address Fields button €“ are they Outlook fields? - they look very similar. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2003 Mailmerge - Address fields
I guess you are referring to the fields that make up the AddressBlock field.
Steer clear of it. You are better off to just insert the mergefields that YOU want in the configuration that YOU want. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Mary Ann" wrote in message ... I am mailmerging a standard letter to an Excel data source and using the More Items link in the wizard to insert the fields. I am keeping the Database Fields checked and do have the fields from my Excel spreadsheet available. What are the fields that are shown when I click the Address Fields button - are they Outlook fields? - they look very similar. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2003 Mailmerge - Address fields
They are standardised field names. To use them, you have to "map" them or
"match" them to the real names in the data source, which are the "Database Fields". Word uses a "\m" in a MERGEFIELD field to indicate that it is using an "Address Field". The theory is that... By using them, you can always use the same names in your mail merge main documents, no matter what the names are in the data sources you connect to. So for example, suppose you have one Excel file with columns Title, Surname and Job, and another one with essentially the same type of data but with columns called T,S and J, you could use the "Address Fields" Courtesy Title, Last Name, and Job Title in your Mail merge main documents (e.g. { MERGEFIELD "Courtesy Title" \m } etc.), and in one case map Courtesy Title to Title Last Name to Surname Job Title to Job and in the other case map Courtesy Title to T Last Name to S Job Title to J Word does some of the mapping automatically when you connect to a data source, because it recognises some variants (e.g. perhaps First Name, FirstName and First_Name). I quite like the theory, but in practice, a. doing the mapping is a pain. For example, I would want to be able to store a simple set of mappings in a file along with the data source b. I don't think I've ever encountered anyone actually using this approach, at least as it seems to have been intended. People who use the ADDRESSBLOCK and GREETINGLINE fields are likely to /have/ to do the mapping, because those fields rely on the same underlying notion, but in most cases they are likely to be using Outlook fields which Word mostly recognises automatically. Peter Jamieson "Mary Ann" wrote in message ... I am mailmerging a standard letter to an Excel data source and using the More Items link in the wizard to insert the fields. I am keeping the Database Fields checked and do have the fields from my Excel spreadsheet available. What are the fields that are shown when I click the Address Fields button - are they Outlook fields? - they look very similar. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2003 Mailmerge - Address fields
Thanks for your reply. I do use the option to insert my own fields but
wanted to understand what those Database fields were. Problem solved now. "Doug Robbins - Word MVP" wrote: I guess you are referring to the fields that make up the AddressBlock field. Steer clear of it. You are better off to just insert the mergefields that YOU want in the configuration that YOU want. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP "Mary Ann" wrote in message ... I am mailmerging a standard letter to an Excel data source and using the More Items link in the wizard to insert the fields. I am keeping the Database Fields checked and do have the fields from my Excel spreadsheet available. What are the fields that are shown when I click the Address Fields button - are they Outlook fields? - they look very similar. |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Word 2003 Mailmerge - Address fields
Thanks Peter. So that is the intended purpose! I feel more comfortable when
I understand, so thank you. "Peter Jamieson" wrote: They are standardised field names. To use them, you have to "map" them or "match" them to the real names in the data source, which are the "Database Fields". Word uses a "\m" in a MERGEFIELD field to indicate that it is using an "Address Field". The theory is that... By using them, you can always use the same names in your mail merge main documents, no matter what the names are in the data sources you connect to. So for example, suppose you have one Excel file with columns Title, Surname and Job, and another one with essentially the same type of data but with columns called T,S and J, you could use the "Address Fields" Courtesy Title, Last Name, and Job Title in your Mail merge main documents (e.g. { MERGEFIELD "Courtesy Title" \m } etc.), and in one case map Courtesy Title to Title Last Name to Surname Job Title to Job and in the other case map Courtesy Title to T Last Name to S Job Title to J Word does some of the mapping automatically when you connect to a data source, because it recognises some variants (e.g. perhaps First Name, FirstName and First_Name). I quite like the theory, but in practice, a. doing the mapping is a pain. For example, I would want to be able to store a simple set of mappings in a file along with the data source b. I don't think I've ever encountered anyone actually using this approach, at least as it seems to have been intended. People who use the ADDRESSBLOCK and GREETINGLINE fields are likely to /have/ to do the mapping, because those fields rely on the same underlying notion, but in most cases they are likely to be using Outlook fields which Word mostly recognises automatically. Peter Jamieson "Mary Ann" wrote in message ... I am mailmerging a standard letter to an Excel data source and using the More Items link in the wizard to insert the fields. I am keeping the Database Fields checked and do have the fields from my Excel spreadsheet available. What are the fields that are shown when I click the Address Fields button - are they Outlook fields? - they look very similar. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Order of fields in the mailmerge recipient list in Word 2003 | Mailmerge | |||
address bolded when mailmerge from Outlook to Word | Mailmerge | |||
Allow word 2003 to import address information from Address Book 6. | Mailmerge | |||
How can I change a regular word address mailing into a mailmerge d | Mailmerge | |||
Using MAILMERGE fields within HYPERLINK fields for Merge to Email | Mailmerge |