Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Single but Multiple records
Hi jacqui! Did you solve your issue? I have the same question as you. Would
be possible with this Macro?? Thanks!! -- mery "jacquieamer (removethis) @earthlink.net" wrote: In the spreadsheet list the employee data, but have columns named "CoachingIssue1" "Coaching Issue2", etc. -----Original Message----- I have a spreadsheet in Excel that contains my employees' data (name, ID, manager, etc.) along with "coaching issues". Every item has its own column. The majority of the time, a person will be listed several times with several different coaching issues. Is it possible for the Mailmerge to create one page that includes the employee's data (one time) and all the records under his/her name (such as in a table format); and do this for all employee's listed on the spreadsheet? I am trying to get away from creating a page for every issue under the same employee. My idea is to create a small but comprehensive report that I may be able to give each employee at the end of the month. One glance sees everything, without having to flip from page to page for the same employee. . |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Single but Multiple records
See fellow MVP Macropod's "Word 97-2007 Catalogue/Directory Mailmerge
Tutorial" at: http://www.wopr.com/index.php?showtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it as you must get the mail merge main document set up exactly as required. -- 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, originally posted via msnews.microsoft.com "maria" wrote in message ... Hi jacqui! Did you solve your issue? I have the same question as you. Would be possible with this Macro?? Thanks!! -- mery "jacquieamer (removethis) @earthlink.net" wrote: In the spreadsheet list the employee data, but have columns named "CoachingIssue1" "Coaching Issue2", etc. -----Original Message----- I have a spreadsheet in Excel that contains my employees' data (name, ID, manager, etc.) along with "coaching issues". Every item has its own column. The majority of the time, a person will be listed several times with several different coaching issues. Is it possible for the Mailmerge to create one page that includes the employee's data (one time) and all the records under his/her name (such as in a table format); and do this for all employee's listed on the spreadsheet? I am trying to get away from creating a page for every issue under the same employee. My idea is to create a small but comprehensive report that I may be able to give each employee at the end of the month. One glance sees everything, without having to flip from page to page for the same employee. . |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Single but Multiple records
Hi Doug, Unfortunately I follow all the steps into the Tutorial but is not possible for me to run the Macro as it always shows an error message. Could be possible for you to send me an example maybe? Thanks a lot!!! -- mery "Doug Robbins - Word MVP" wrote: See fellow MVP Macropod's "Word 97-2007 Catalogue/Directory Mailmerge Tutorial" at: http://www.wopr.com/index.php?showtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it as you must get the mail merge main document set up exactly as required. -- 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, originally posted via msnews.microsoft.com "maria" wrote in message ... Hi jacqui! Did you solve your issue? I have the same question as you. Would be possible with this Macro?? Thanks!! -- mery "jacquieamer (removethis) @earthlink.net" wrote: In the spreadsheet list the employee data, but have columns named "CoachingIssue1" "Coaching Issue2", etc. -----Original Message----- I have a spreadsheet in Excel that contains my employees' data (name, ID, manager, etc.) along with "coaching issues". Every item has its own column. The majority of the time, a person will be listed several times with several different coaching issues. Is it possible for the Mailmerge to create one page that includes the employee's data (one time) and all the records under his/her name (such as in a table format); and do this for all employee's listed on the spreadsheet? I am trying to get away from creating a page for every issue under the same employee. My idea is to create a small but comprehensive report that I may be able to give each employee at the end of the month. One glance sees everything, without having to flip from page to page for the same employee. . |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Single but Multiple records
What is the error message?
When do you see it? Which version of Word? What is the data source? Peter Jamieson "maria" wrote in message ... Hi Doug, Unfortunately I follow all the steps into the Tutorial but is not possible for me to run the Macro as it always shows an error message. Could be possible for you to send me an example maybe? Thanks a lot!!! -- mery "Doug Robbins - Word MVP" wrote: See fellow MVP Macropod's "Word 97-2007 Catalogue/Directory Mailmerge Tutorial" at: http://www.wopr.com/index.php?showtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it as you must get the mail merge main document set up exactly as required. -- 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, originally posted via msnews.microsoft.com "maria" wrote in message ... Hi jacqui! Did you solve your issue? I have the same question as you. Would be possible with this Macro?? Thanks!! -- mery "jacquieamer (removethis) @earthlink.net" wrote: In the spreadsheet list the employee data, but have columns named "CoachingIssue1" "Coaching Issue2", etc. -----Original Message----- I have a spreadsheet in Excel that contains my employees' data (name, ID, manager, etc.) along with "coaching issues". Every item has its own column. The majority of the time, a person will be listed several times with several different coaching issues. Is it possible for the Mailmerge to create one page that includes the employee's data (one time) and all the records under his/her name (such as in a table format); and do this for all employee's listed on the spreadsheet? I am trying to get away from creating a page for every issue under the same employee. My idea is to create a small but comprehensive report that I may be able to give each employee at the end of the month. One glance sees everything, without having to flip from page to page for the same employee. . |
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Single but Multiple records
hi Peter,
i'm sending you an example of that I wanted to merge: City Employee Sales Atlanta Smith $3,000 Atlanta Gates $50,000 Atlanta Henderson $10,000 Houston Jones $8,000 Houston Kelley $9,000 Houston Peterson $0 I need to send ONLY ONE e-mail for "Atlanta" with the 3 employees (Smith, Gates & Henderson) details. When I running the Macro, after insert the "merge fields" the message error is the following: "Run-Time error 5941" the Macro that I'm using is exactly as the tutorial (I copied from the tutorial). thank you very much, I really appreciated you help on this! -- mery "Peter Jamieson" wrote: What is the error message? When do you see it? Which version of Word? What is the data source? Peter Jamieson "maria" wrote in message ... Hi Doug, Unfortunately I follow all the steps into the Tutorial but is not possible for me to run the Macro as it always shows an error message. Could be possible for you to send me an example maybe? Thanks a lot!!! -- mery "Doug Robbins - Word MVP" wrote: See fellow MVP Macropod's "Word 97-2007 Catalogue/Directory Mailmerge Tutorial" at: http://www.wopr.com/index.php?showtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it as you must get the mail merge main document set up exactly as required. -- 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, originally posted via msnews.microsoft.com "maria" wrote in message ... Hi jacqui! Did you solve your issue? I have the same question as you. Would be possible with this Macro?? Thanks!! -- mery "jacquieamer (removethis) @earthlink.net" wrote: In the spreadsheet list the employee data, but have columns named "CoachingIssue1" "Coaching Issue2", etc. -----Original Message----- I have a spreadsheet in Excel that contains my employees' data (name, ID, manager, etc.) along with "coaching issues". Every item has its own column. The majority of the time, a person will be listed several times with several different coaching issues. Is it possible for the Mailmerge to create one page that includes the employee's data (one time) and all the records under his/her name (such as in a table format); and do this for all employee's listed on the spreadsheet? I am trying to get away from creating a page for every issue under the same employee. My idea is to create a small but comprehensive report that I may be able to give each employee at the end of the month. One glance sees everything, without having to flip from page to page for the same employee. . |
#6
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Single but Multiple records
Did you copy both macros - Sub EmailMergeTableMaker() and the Sub
TableJoiner()? Have you created AND EXECUTED the multi-table merge to create a document like that shown in the tutorial? Is that document the active document when you run the EmailMergeTableMaker macro? If you click on Debug, what line of code is highlighted in yellow? -- 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, originally posted via msnews.microsoft.com "maria" wrote in message ... hi Peter, i'm sending you an example of that I wanted to merge: City Employee Sales Atlanta Smith $3,000 Atlanta Gates $50,000 Atlanta Henderson $10,000 Houston Jones $8,000 Houston Kelley $9,000 Houston Peterson $0 I need to send ONLY ONE e-mail for "Atlanta" with the 3 employees (Smith, Gates & Henderson) details. When I running the Macro, after insert the "merge fields" the message error is the following: "Run-Time error 5941" the Macro that I'm using is exactly as the tutorial (I copied from the tutorial). thank you very much, I really appreciated you help on this! -- mery "Peter Jamieson" wrote: What is the error message? When do you see it? Which version of Word? What is the data source? Peter Jamieson "maria" wrote in message ... Hi Doug, Unfortunately I follow all the steps into the Tutorial but is not possible for me to run the Macro as it always shows an error message. Could be possible for you to send me an example maybe? Thanks a lot!!! -- mery "Doug Robbins - Word MVP" wrote: See fellow MVP Macropod's "Word 97-2007 Catalogue/Directory Mailmerge Tutorial" at: http://www.wopr.com/index.php?showtopic=731107 or http://www.gmayor.com/Zips/Catalogue%20Mailmerge.zip Do read the tutorial before trying to use the mailmerge document included with it as you must get the mail merge main document set up exactly as required. -- 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, originally posted via msnews.microsoft.com "maria" wrote in message ... Hi jacqui! Did you solve your issue? I have the same question as you. Would be possible with this Macro?? Thanks!! -- mery "jacquieamer (removethis) @earthlink.net" wrote: In the spreadsheet list the employee data, but have columns named "CoachingIssue1" "Coaching Issue2", etc. -----Original Message----- I have a spreadsheet in Excel that contains my employees' data (name, ID, manager, etc.) along with "coaching issues". Every item has its own column. The majority of the time, a person will be listed several times with several different coaching issues. Is it possible for the Mailmerge to create one page that includes the employee's data (one time) and all the records under his/her name (such as in a table format); and do this for all employee's listed on the spreadsheet? I am trying to get away from creating a page for every issue under the same employee. My idea is to create a small but comprehensive report that I may be able to give each employee at the end of the month. One glance sees everything, without having to flip from page to page for the same employee. . |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multiple records on single merge doc | Mailmerge | |||
Multiple records on a single mail merge - another question | Mailmerge | |||
Mailmerge multiple Excel records for one name to a single Word Doc | Mailmerge | |||
Multiple records into a single document | Mailmerge | |||
How do I get multiple Access records into a single mailmerge lett. | Mailmerge |