Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Layout for Spreadsheet - Several Records into one for Mail Merge
Hi,
How can i design a layout for a spreadsheet so i can use a mail merge in word using one employer name and several employees undertaking courses at that firm. Example:- Jackson Engineering Joe Bloggs - Health Care Ann Bloggs - Customer Services The spreadsheet is exported from Access 2003. My Current lay out is Surname, First Name, Course, Employer Hope someone can understand what i mean and hopefully help. |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Layout for Spreadsheet - Several Records into one for Mail Merge
Sounds like you are probably trying to perform a "multiple items per
condition (=key field)" mailmerge which Word does not really have the ability to do: See the "Group Multiple items for a single condition" item on fellow MVP Cindy Meister's website at http://homepage.swissonline.ch/cindy...faq1.htm#DBPic Or take a look at the following Knowledge Base Article http://support.microsoft.com/default...b;en-us;211303 http://www.knowhow.com/Guides/Compou...poundMerge.htm -- 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 "Stella" wrote in message ... Hi, How can i design a layout for a spreadsheet so i can use a mail merge in word using one employer name and several employees undertaking courses at that firm. Example:- Jackson Engineering Joe Bloggs - Health Care Ann Bloggs - Customer Services The spreadsheet is exported from Access 2003. My Current lay out is Surname, First Name, Course, Employer Hope someone can understand what i mean and hopefully help. |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Layout for Spreadsheet - Several Records into one for Mail Mer
Thanks so much Doug, that sorted all my problems
"Doug Robbins - Word MVP" wrote: Sounds like you are probably trying to perform a "multiple items per condition (=key field)" mailmerge which Word does not really have the ability to do: See the "Group Multiple items for a single condition" item on fellow MVP Cindy Meister's website at http://homepage.swissonline.ch/cindy...faq1.htm#DBPic Or take a look at the following Knowledge Base Article http://support.microsoft.com/default...b;en-us;211303 http://www.knowhow.com/Guides/Compou...poundMerge.htm -- 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 "Stella" wrote in message ... Hi, How can i design a layout for a spreadsheet so i can use a mail merge in word using one employer name and several employees undertaking courses at that firm. Example:- Jackson Engineering Joe Bloggs - Health Care Ann Bloggs - Customer Services The spreadsheet is exported from Access 2003. My Current lay out is Surname, First Name, Course, Employer Hope someone can understand what i mean and hopefully help. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge from two different tables, multiple records in sub tabl | Mailmerge | |||
mail merge with word 2003 | New Users | |||
Merge not picking up all records | Mailmerge | |||
Envelope Mail Merge from .xls all records rather than selection | Mailmerge | |||
all merge records do not transfer | Mailmerge |