Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Directory mail merge
Hi,
I'm trying to prepare a mailmerge that is a letter with part of the letter listing several rows of data to the recipient. The recipient information is in the data file 5 times as there are then 5 pieces of data that need listing in part of the letter before the letter is then finished. There is some other information in the data file that needs to go in the letter but that is supplied 5 times and is identical. Hope that made sense? Can anyone help as i'm getting 5 letters out each with one piece of the unique data as aposed to a list. Many thanks Simon |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Directory mail merge
This is quite complicated to achieve as Word is not designed for this type
of merge - see http://support.microsoft.com/?kbid=294686 -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org Simon J wrote: Hi, I'm trying to prepare a mailmerge that is a letter with part of the letter listing several rows of data to the recipient. The recipient information is in the data file 5 times as there are then 5 pieces of data that need listing in part of the letter before the letter is then finished. There is some other information in the data file that needs to go in the letter but that is supplied 5 times and is identical. Hope that made sense? Can anyone help as i'm getting 5 letters out each with one piece of the unique data as aposed to a list. Many thanks Simon |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Directory mail merge
Hi Simon,
Is this the same mailmerge process that was the subject of your post of 20 July? If so, you need to embed the 'correspondence' within the body of the field coding, plus you'll need to add a dummy record at the end of your data set in Excel. The process is a bit complicated, but you can see an example he http://www.wopr.com/cgi-bin/w3t/show...?Number=723456 -- Cheers macropod [MVP - Microsoft Word] "Simon J" wrote in message ... Hi, I'm trying to prepare a mailmerge that is a letter with part of the letter listing several rows of data to the recipient. The recipient information is in the data file 5 times as there are then 5 pieces of data that need listing in part of the letter before the letter is then finished. There is some other information in the data file that needs to go in the letter but that is supplied 5 times and is identical. Hope that made sense? Can anyone help as i'm getting 5 letters out each with one piece of the unique data as aposed to a list. Many thanks Simon |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Directory mail merge
Take a look at http://cornell.veplan.net/article.aspx?&a=3815
-- 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 "Simon J" wrote in message ... Hi, I'm trying to prepare a mailmerge that is a letter with part of the letter listing several rows of data to the recipient. The recipient information is in the data file 5 times as there are then 5 pieces of data that need listing in part of the letter before the letter is then finished. There is some other information in the data file that needs to go in the letter but that is supplied 5 times and is identical. Hope that made sense? Can anyone help as i'm getting 5 letters out each with one piece of the unique data as aposed to a list. Many thanks Simon |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Directory mail merge
I read the article from Cornell and the MS article 294686 and understand them
and have been successful implementing them. However, I'm wondering how to add other merge field(s) at the bottom of the page or after the multiple records only once (as if they were in the header), but before the page break. For example an invoice: has header info at the top of the page, the middle is multiple records (item, qty, price) and at the bottom a total for the entire invoice. I can get this total field from the data source there is no need to sum). I can't figure out how to get the total field at the bottom without it showing multiple times. Any advise would be greatly appreciated. "Doug Robbins - Word MVP" wrote: Take a look at http://cornell.veplan.net/article.aspx?&a=3815 -- 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 "Simon J" wrote in message ... Hi, I'm trying to prepare a mailmerge that is a letter with part of the letter listing several rows of data to the recipient. The recipient information is in the data file 5 times as there are then 5 pieces of data that need listing in part of the letter before the letter is then finished. There is some other information in the data file that needs to go in the letter but that is supplied 5 times and is identical. Hope that made sense? Can anyone help as i'm getting 5 letters out each with one piece of the unique data as aposed to a list. Many thanks Simon |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Directory mail merge
I do not think that it is possible to do that with that method of producing
such letters as any mergefields that you insert after the multiple data items will pick up the data that applies to the next record. If I was doing it, I would probably have the data in an Access database and use a report in Access. The other alternative is a "roll-your-own" substitute for mail merge that uses a template as the main document and uses VBA code to interate through the data source. creating new documents from the template when the key data changes, and inserting the multiple data items into each letter prior to going on to the next letter. -- 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 "Kimberly" wrote in message ... I read the article from Cornell and the MS article 294686 and understand them and have been successful implementing them. However, I'm wondering how to add other merge field(s) at the bottom of the page or after the multiple records only once (as if they were in the header), but before the page break. For example an invoice: has header info at the top of the page, the middle is multiple records (item, qty, price) and at the bottom a total for the entire invoice. I can get this total field from the data source there is no need to sum). I can't figure out how to get the total field at the bottom without it showing multiple times. Any advise would be greatly appreciated. "Doug Robbins - Word MVP" wrote: Take a look at http://cornell.veplan.net/article.aspx?&a=3815 -- 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 "Simon J" wrote in message ... Hi, I'm trying to prepare a mailmerge that is a letter with part of the letter listing several rows of data to the recipient. The recipient information is in the data file 5 times as there are then 5 pieces of data that need listing in part of the letter before the letter is then finished. There is some other information in the data file that needs to go in the letter but that is supplied 5 times and is identical. Hope that made sense? Can anyone help as i'm getting 5 letters out each with one piece of the unique data as aposed to a list. Many thanks Simon |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Directory mail merge
Hi Kimberly,
For a working solution that you might be able to modify to suit your needs, see: http://www.wopr.com/cgi-bin/w3t/show...?Number=723456 The example there is based on an Excel data source and requires you to insert a dummy 'last' data record into the data source. -- Cheers macropod [MVP - Microsoft Word] "Kimberly" wrote in message ... I read the article from Cornell and the MS article 294686 and understand them and have been successful implementing them. However, I'm wondering how to add other merge field(s) at the bottom of the page or after the multiple records only once (as if they were in the header), but before the page break. For example an invoice: has header info at the top of the page, the middle is multiple records (item, qty, price) and at the bottom a total for the entire invoice. I can get this total field from the data source there is no need to sum). I can't figure out how to get the total field at the bottom without it showing multiple times. Any advise would be greatly appreciated. "Doug Robbins - Word MVP" wrote: Take a look at http://cornell.veplan.net/article.aspx?&a=3815 -- 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 "Simon J" wrote in message ... Hi, I'm trying to prepare a mailmerge that is a letter with part of the letter listing several rows of data to the recipient. The recipient information is in the data file 5 times as there are then 5 pieces of data that need listing in part of the letter before the letter is then finished. There is some other information in the data file that needs to go in the letter but that is supplied 5 times and is identical. Hope that made sense? Can anyone help as i'm getting 5 letters out each with one piece of the unique data as aposed to a list. Many thanks Simon |
#8
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Directory mail merge
Hi Paul,
For some reason, the Landlord letter.doc opens up as a Letters type mail merge main document and has to be changed to a Directory type document to get it to work. The problem remains however that if you insert a merge field somewhere in the Landlord General Information Each time a tenant contacts the District to close their account, the account will automatically revert back to the landlord. Please notify the PUD if the tenant has vacated the addresses and has not notified the PUD to close account. that comes after the list of properties, that mergefield will display the data from the next (landlord) record in the datasource, not data from the landlord whose list of properties is included in that letter. -- 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 "macropod" wrote in message ... Hi Kimberly, For a working solution that you might be able to modify to suit your needs, see: http://www.wopr.com/cgi-bin/w3t/show...?Number=723456 The example there is based on an Excel data source and requires you to insert a dummy 'last' data record into the data source. -- Cheers macropod [MVP - Microsoft Word] "Kimberly" wrote in message ... I read the article from Cornell and the MS article 294686 and understand them and have been successful implementing them. However, I'm wondering how to add other merge field(s) at the bottom of the page or after the multiple records only once (as if they were in the header), but before the page break. For example an invoice: has header info at the top of the page, the middle is multiple records (item, qty, price) and at the bottom a total for the entire invoice. I can get this total field from the data source there is no need to sum). I can't figure out how to get the total field at the bottom without it showing multiple times. Any advise would be greatly appreciated. "Doug Robbins - Word MVP" wrote: Take a look at http://cornell.veplan.net/article.aspx?&a=3815 -- 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 "Simon J" wrote in message ... Hi, I'm trying to prepare a mailmerge that is a letter with part of the letter listing several rows of data to the recipient. The recipient information is in the data file 5 times as there are then 5 pieces of data that need listing in part of the letter before the letter is then finished. There is some other information in the data file that needs to go in the letter but that is supplied 5 times and is identical. Hope that made sense? Can anyone help as i'm getting 5 letters out each with one piece of the unique data as aposed to a list. Many thanks Simon |
#9
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Directory mail merge
Hi Doug,
I don't understand why the merge type changed but, nothwithstanding that, the field coding worked in my testing and met the needs of the wopr poster. -- Cheers macropod [MVP - Microsoft Word] "Doug Robbins - Word MVP" wrote in message ... Hi Paul, For some reason, the Landlord letter.doc opens up as a Letters type mail merge main document and has to be changed to a Directory type document to get it to work. The problem remains however that if you insert a merge field somewhere in the Landlord General Information Each time a tenant contacts the District to close their account, the account will automatically revert back to the landlord. Please notify the PUD if the tenant has vacated the addresses and has not notified the PUD to close account. that comes after the list of properties, that mergefield will display the data from the next (landlord) record in the datasource, not data from the landlord whose list of properties is included in that letter. -- 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 "macropod" wrote in message ... Hi Kimberly, For a working solution that you might be able to modify to suit your needs, see: http://www.wopr.com/cgi-bin/w3t/show...?Number=723456 The example there is based on an Excel data source and requires you to insert a dummy 'last' data record into the data source. -- Cheers macropod [MVP - Microsoft Word] "Kimberly" wrote in message ... I read the article from Cornell and the MS article 294686 and understand them and have been successful implementing them. However, I'm wondering how to add other merge field(s) at the bottom of the page or after the multiple records only once (as if they were in the header), but before the page break. For example an invoice: has header info at the top of the page, the middle is multiple records (item, qty, price) and at the bottom a total for the entire invoice. I can get this total field from the data source there is no need to sum). I can't figure out how to get the total field at the bottom without it showing multiple times. Any advise would be greatly appreciated. "Doug Robbins - Word MVP" wrote: Take a look at http://cornell.veplan.net/article.aspx?&a=3815 -- 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 "Simon J" wrote in message ... Hi, I'm trying to prepare a mailmerge that is a letter with part of the letter listing several rows of data to the recipient. The recipient information is in the data file 5 times as there are then 5 pieces of data that need listing in part of the letter before the letter is then finished. There is some other information in the data file that needs to go in the letter but that is supplied 5 times and is identical. Hope that made sense? Can anyone help as i'm getting 5 letters out each with one piece of the unique data as aposed to a list. Many thanks Simon |
#10
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Directory mail merge
In message of Tue, 19 Aug 2008
21:14:35 in microsoft.public.word.mailmerge.fields, macropod writes Hi Kimberly, For a working solution that you might be able to modify to suit your needs, see: http://www.wopr.com/cgi-bin/w3t/show...?Number=723456 The example there is based on an Excel data source and requires you to insert a dummy 'last' data record into the data source. macropod, I downloaded this, learnt a lot, and have some questions. I can get a working merge by pasting code from "Catalogue Mailmerge Tutorial.doc" to "Mailmerge Main Document.doc". I am unable to create my own document to mimic "Mailmerge Main Document.doc". The connection to "Catalogue Merge Data.xls" from "Mailmerge Main Document.doc" uses a technique which is hidden to me. It allows the folder to be relocated and maintain the connection. It does not use Cindy Meister's VBA method to establish the connection. The connection also allows money amounts like "$8,000" to be passed where I see "8000" and refers to the whole document rather than a sheet. How? I am sure others will appreciate an explanation of the techniques. Much less significant is the display of "Coffs Harbour" on a line which has "Justify" set. On my example, Harbour is thrown to the right by the justification; you avoid it. How? There seems to be a normal space between the two words. (Ctrl+F finds a space in Excel where I do not find anything like Word's Hide/Unhide to show graphic glyphs to render whitespace.) P.S. Can you suggest a probe which will allow me to answer such questions for myself? If necessary, I guess I could learn to read RTF ;( -- Walter Briscoe |
#11
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Directory mail merge
Hi Walter,
I am unable to create my own document to mimic "Mailmerge Main Document.doc". The procedures for creating your own mailmerge main document, linked to your own data source, are set out in section headed 'Set Up the Main Mailmerge Document'. The connection to "Catalogue Merge Data.xls" from "Mailmerge Main Document.doc" uses a technique which is hidden to me. 2. The 'Main Mailmerge Document' attached to the tutorial has already been through the process described at 1, above. The connection also allows money amounts like "$8,000" to be passed where I see "8000" 3. The $ symbols in the tutorial's merged output appear in the tutorial's data file. If they don't appear in your data file and you want them in your output, you'll need to format the relevant mergefields with the appropriate numeric picture switch. The field coding under the heading 'Format the Output and/or Insert Additional Text Before the Repeated Data' has such a switch (see also Word's help file for more details). Much less significant is the display of "Coffs Harbour" on a line which has "Justify" set. On my example, Harbour is thrown to the right by the justification; you avoid it. How? 4. In the tutorial, the paragraphs containing the mergefields were formatted with left & decimal tabs at 5 and 10cm, respectively. That's what controls the paragraph layout. Obviously, if you paste the code into a paragraph with a different layout, the results will differ. -- Cheers macropod [MVP - Microsoft Word] "Walter Briscoe" wrote in message ... In message of Tue, 19 Aug 2008 21:14:35 in microsoft.public.word.mailmerge.fields, macropod writes Hi Kimberly, For a working solution that you might be able to modify to suit your needs, see: http://www.wopr.com/cgi-bin/w3t/show...?Number=723456 The example there is based on an Excel data source and requires you to insert a dummy 'last' data record into the data source. macropod, I downloaded this, learnt a lot, and have some questions. I can get a working merge by pasting code from "Catalogue Mailmerge Tutorial.doc" to "Mailmerge Main Document.doc". I am unable to create my own document to mimic "Mailmerge Main Document.doc". The connection to "Catalogue Merge Data.xls" from "Mailmerge Main Document.doc" uses a technique which is hidden to me. It allows the folder to be relocated and maintain the connection. It does not use Cindy Meister's VBA method to establish the connection. The connection also allows money amounts like "$8,000" to be passed where I see "8000" and refers to the whole document rather than a sheet. How? I am sure others will appreciate an explanation of the techniques. Much less significant is the display of "Coffs Harbour" on a line which has "Justify" set. On my example, Harbour is thrown to the right by the justification; you avoid it. How? There seems to be a normal space between the two words. (Ctrl+F finds a space in Excel where I do not find anything like Word's Hide/Unhide to show graphic glyphs to render whitespace.) P.S. Can you suggest a probe which will allow me to answer such questions for myself? If necessary, I guess I could learn to read RTF ;( -- Walter Briscoe |
#12
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Directory mail merge
Hi Kimberly,
Another way of doing that, with such a field construction, would be to have the data that you want to display after the multiple records contained in a mergefield (you would probably have to add a new field in the data source in the NEXT record in the data source AFTER the last of the multiple records and to have a dummy record at the end of the datasource that contains just that data for the last group of multiple records. -- 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 "Kimberly" wrote in message ... I read the article from Cornell and the MS article 294686 and understand them and have been successful implementing them. However, I'm wondering how to add other merge field(s) at the bottom of the page or after the multiple records only once (as if they were in the header), but before the page break. For example an invoice: has header info at the top of the page, the middle is multiple records (item, qty, price) and at the bottom a total for the entire invoice. I can get this total field from the data source there is no need to sum). I can't figure out how to get the total field at the bottom without it showing multiple times. Any advise would be greatly appreciated. "Doug Robbins - Word MVP" wrote: Take a look at http://cornell.veplan.net/article.aspx?&a=3815 -- 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 "Simon J" wrote in message ... Hi, I'm trying to prepare a mailmerge that is a letter with part of the letter listing several rows of data to the recipient. The recipient information is in the data file 5 times as there are then 5 pieces of data that need listing in part of the letter before the letter is then finished. There is some other information in the data file that needs to go in the letter but that is supplied 5 times and is identical. Hope that made sense? Can anyone help as i'm getting 5 letters out each with one piece of the unique data as aposed to a list. Many thanks Simon |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge and Active Directory | Mailmerge | |||
Mail Merge directory | Mailmerge | |||
Mail Merge - Directory | Mailmerge | |||
Directory mail merge questions | Mailmerge | |||
Mail Merge - Directory | Mailmerge |