 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / November 2007Link for mail merge help not working
Hello, on the helpful site you give out : (MVP Cindy Meister's website): http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic... ...it has a link to go to "know how" but its not working: http://www.knowhow.com/Guides/DatabaseInfo/DatabaseInfo.htm Any other suggestions to find this info? Thank you! I can't find the specific link that you mention on that page, though there is a different one http://www.knowhow.com/Guides/CompoundMerges/CompoundMeger.htm on that page that I know no longer works. Perhaps if you tell us what it is that you need help with, we may be able to provide it.  SignaturePlease reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP > Hello, on the helpful site you give out : (MVP Cindy Meister's website): > http://homepage.swissonline.ch/cindymeister/mergfaq1.htm#DBPic... [quoted text clipped - 3 lines] > > Any other suggestions to find this info? Thank you! Hello Doug, thanks for responding. I am trying to do a mail merge from excel into word that adds an individual pie chart (pre-calculates) for each person into the mail merge letter. The quantity of people is large (4500) so it would be hard to do individually. I thought that the suggestion (number 2) on Cindy's website sounded like it may help, although the link that it tells you how to do it was the one I wanted to read. I have searched the discussion groups to see what other people have done, but most just refer you to Cindy's website for this. If you have any other suggestions that would be great. Thanks again, Nancy > I can't find the specific link that you mention on that page, though there > is a different one [quoted text clipped - 13 lines] > > > > Any other suggestions to find this info? Thank you! Hi Nancy, For that method, you have to preview the merge data, one record at a time, and print as you go, which is probably not feasible if you want to do it for 4,500 people, though as Cindy says, the process could be automated so that the preview and printing could be done automatically. If you are using Word XP or later, I would recommend that you investigate the fourth method - "Creating the charts on the fly as the mailmerge executes in the main merge document" However, to learn a bit about the use of database fields, the following links may help: http://www.bettersolutions.com/word/WOO733/LA811111611.htm http://office.microsoft.com/en-us/word/HP051862061033.aspx http://office.microsoft.com/en-us/word/HP051901661033.aspx For the last one, be sure to click on the Show All. SignatureHope 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 > Hello Doug, thanks for responding. I am trying to do a mail merge from > excel [quoted text clipped - 31 lines] >> > >> > Any other suggestions to find this info? Thank you! Hi Doug, Thank you for all of the additional suggestions, will certainly try them and do much research! I have Word 2003. I am sure something is bound to work. Thanks again, Nancy > Hi Nancy, > [quoted text clipped - 53 lines] > >> > > >> > Any other suggestions to find this info? Thank you! Hi Doug, I am trying the 4th method, and got stuck on the following steps: 1) insert a normal module and a class module into the main merge doc and copy cooresponding code (where can I find these modules?) 2) go to tools/references in Visual Basic Editor (I do not think I have VBE?!), can it still work? Where do I get VBE at? Thanks! > Hi Doug, > [quoted text clipped - 61 lines] > > >> > > > >> > Any other suggestions to find this info? Thank you! Sorry - I found this info finally, however, I do not know what the " cooressponding code" is. Any ideas? > Hi Doug, I am trying the 4th method, and got stuck on the following steps: > [quoted text clipped - 70 lines] > > > >> > > > > >> > Any other suggestions to find this info? Thank you! The code is in the modules in the MailMergePieChartLetter.doc file SignatureHope 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 > Sorry - I found this info finally, however, I do not know what the " > cooressponding code" is. Any ideas? [quoted text clipped - 91 lines] >> > > >> > >> > > >> > Any other suggestions to find this info? Thank you! Thanks, really appreciate the support....!! :) > The code is in the modules in the MailMergePieChartLetter.doc file > [quoted text clipped - 93 lines] > >> > > >> > > >> > > >> > Any other suggestions to find this info? Thank you! Hi , I used the 4th mehod using the vba. When i run the vba code i get only one record merged . I would like to create the documents with all the records. As we have 9 records in the example file. Any help is appreciated. SHashi > Thanks, really appreciate the support....!! :) > [quoted text clipped - 95 lines] > > >> > > >> > > > >> > > >> > Any other suggestions to find this info? Thank you! If you read through this thread, you will see where it is said: > > >> > > For that method, you have to preview the merge data, one record > > >> > > at a > > >> > > time, > > >> > > and print as you go SignatureHope 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 > Hi , > [quoted text clipped - 123 lines] >> > >> > > >> > >> > >> > > >> > Any other suggestions to find this info? Thank you! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.