Posts Topics Forums Images
Search videos from message boards Videos Search messages from microblogs Microblogs Search messages from imdb.com Imdb Search messages from yuku.com Yuku Search messages from lefora.com (free forums) Lefora
My account: Login | Sign Up
Loading... 

Mailmerge | Forum profile

Forum profile page for Mailmerge on http://www.officefrustration.com. This report page is the aggregated overview from a single forum: Mailmerge, located on the Message Board at http://www.officefrustration.com. This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period. Additional forum profile information for "Mailmerge" on the Message Board at http://www.officefrustration.com is also shown in the following ways:

1) Latest Active Threads
2) Hot Threads for Last Week

Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.

Site: Microsoft Office (Excel, Word) forum - OfficeFrustration - Mailmerge (site profile, domain info officefrustration.com)
Title: Mailmerge
Url: http://www.officefrustration.com/forumdisplay.p...
Users activity: 22 posts per thread
Forum activity: 40 active threads during last week
 

Posting activity on Mailmerge:

  Week Month 3 Months
Threads: 40 141 493
Post: 74 287 1,076
 

Mailmerge Posting activity graph:

Posts by:  day  week  month 

Top authors during last week:

Name
Posts
Doug Robbins - Word MVP
11
user's latest post:
Mail Merge Word 2007-UPDATE LABELS
Published (2009-11-28 07:04:00)
It is the Update Labels button under the Write and Insert Fields section of the Mailings tab of the Ribbon that you need to use, but it is only enabled if the document is a label type mail merge main document. Via the Start Mail Merge button in the Start Mail Merge section of the Ribbon, check what type of mail merge main document Word thinks it is working with. -- Hope this helps. Please reply to the newsgroup unless you wish to avail...
Peter Jamieson
8
user's latest post:
Mailmerging labels and...
Published (2009-11-30 10:19:00)
The option is switched on by default, but if you need to change it, you will probably need to use the old Mail Merge Helper, for example, a. enable the Mail Merge Toolbar using View-Toolbars b. go to Tools-Customize-Commands, select All Commands in the list of categories on the left, look for MailMergeHelper in the alphabetic list on the right, and drag it to thee mail merge toolbar. c. close the Tools-Customize dialog box. d. Ensure your...
GeoBrooks
4
user's latest post:
Word 2007 crashes on recipient sort
Published (2009-11-23 16:28:00)
The culprit: Google Desktop Add-in. Once removed, the data source sort no longer crashes. Gee, do Google & Microsoft not get along? g "GeoBrooks" wrote: The crash continues after reinstalling Office 2007 + sp2. ARRGGHH! g "GeoBrooks" wrote: Peter, The crash only occurs in 2007. In Word 2003, sorting the data source table does not cause any trouble. And when I use '03's table in '07 I...
Shannan
3
user's latest post:
Using If
Published (2009-11-26 18:49:00)
I have no idea if this is possible, but here's what i would like to do: I have a mail merge letter and part of the letter is the following  Indicated normal hearing for both ears  Indicated the need for a more thorough hearing evaluation. The student has been referred to the Public Health Unit Audiology program for a complete evaluation. I have columns in my data source spreadsheet for "Right Ear" and for...
macropod[_2_]
3
user's latest post:
Macro To Set Salutation Line
Published (2009-11-26 22:06:00)
Hi kaneda0149, The simplest appraoch is to put your address lines inside a table cell with the desired fixed row height. That way, the suppression of the unused lines won't affect the layout of the rest of the page. -- Cheers macropod [Microsoft MVP - Word] "kaneda0149" wrote in message ... I have a mail merge letter document already in place where there are four (4) address lines available to pre-fill (if available)...
nadine
3
user's latest post:
Word 2007 - mailmerge, live...
Published (2009-11-26 01:45:00)
SP2 Office pack resolved the problem. But all the information was helpful for us. Thanks "Peter Jamieson" wrote: Not documents from internet or intranet. Just in case there is any misunderstanding, the problem here is that when you open a document that is on a Windows network share (whether you map via a drive letter or not) it looks as if that should have nothing to do with Intranet/Internet. It's the "Windows...
Doug Robbins - Word MVP external...
3
user's latest post:
DocVariable
Published (2009-11-27 23:08:00)
If you press Alt+F9 to toggle on the display of the field codes in the document, the DocVariable fields will appear as { DOCVARIABLE variablename } -- 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 "Paul" wrote in message ... Hello I inherited a Word 2007 template with several...
Graham Mayor
3
user's latest post:
Mail Merge Word 2007-UPDATE LABELS
Published (2009-11-28 08:59:00)
See http://www.gmayor.com/merge_labels_with_word_2007.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org JoeF wrote: When doing a mail merge with labels in Microsoft Word. I have the labels picked avery 5160's, i have my list picked, i have my mail merge fields in one of the labels. I need to get them to the whole page of labels, actually 2 pages of labels. I am thinking that it is the update...
CDAVIS
2
user's latest post:
Creating dependency between...
Published (2009-11-26 01:23:00)
Way over my head with the whole VBA aspect, but I am going to try it. What website should I head to for beginner VBA tutorials? "Doug Robbins - Word MVP" wrote: I think that I would do the whole thing in Access. However to do it in Word, I think that you will need to use a "roll-your-own" VBA equivalent to mailmerge. Such an approach is used in the following which allows the "use" of...
ArcticWolf
2
user's latest post:
Mailmerge named ranges from...
Published (2009-11-26 10:22:00)
Hi Peter, Many thanks for the quick and detailed response, much appreciated. I'm using the simple paste-link method and it's working fine with the odd tweak here and there in my source data. Thanks again and kind regards, AW "Peter Jamieson" wrote: Mail merge expects a data source to be a table: in the scenario you describe, you wouldn't be able to use your data as a data source because in effect, you have a...
 

Latest active threads on Mailmerge::

Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 4 days, 1 hour ago (2009-11-30 10:19:00)  by Peter Jamieson
The option is switched on by default, but if you need to change it, you will probably need to use the old Mail Merge Helper, for example, a. enable the Mail Merge Toolbar using View-Toolbars b. go to Tools-Customize-Commands, select All Commands in the list of categories on the left, look for MailMergeHelper in the alphabetic list on the right, and drag it to thee mail merge toolbar....
Thread:  Show this thread (2 posts)   Thread info: Mailmerging labels and supressing blank fields using Word 2003 Size: 2,292 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Mailmerging labels and supressing blank fields using Word 2003 :: Mailmerge :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 4 days, 21 hours ago (2009-11-29 14:33:00)  by John Brooks[_2_] external usenet poster
When I mailmerge from an outlook contact list into a set of labels, some, but not all, carriage returns in the "Street" section of the outlook contact appear when merged into the labels as square symbols and the text is continuous. Like so:- Main Road Any village Appears as Main Road[]Any village The actual symbol is NOT two square brackets but an actual square. Any ideas how t...
Thread:  Show this thread (2 posts)   Thread info: Strange symbols in mail merge Size: 584 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "Strange symbols in mail merge :: Mailmerge :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 1 week, 2 days ago (2009-11-24 20:35:00)  by Doug Robbins - Word MVP
You may need to use something like the method that is detailed in 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.z ip 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 ...
Thread:  Show this thread (3 posts)   Thread info: word email mail merge Size: 2,285 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: word email mail merge :: Mailmerge :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 6 days, 4 hours ago (2009-11-28 07:04:00)  by Doug Robbins - Word MVP
It is the Update Labels button under the Write and Insert Fields section of the Mailings tab of the Ribbon that you need to use, but it is only enabled if the document is a label type mail merge main document. Via the Start Mail Merge button in the Start Mail Merge section of the Ribbon, check what type of mail merge main document Word thinks it is working with. -- Hope this helps....
Thread:  Show this thread (3 posts)   Thread info: Mail Merge Word 2007-UPDATE LABELS Size: 1,491 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Mail Merge Word 2007-UPDATE LABELS :: Mailmerge :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 6 days, 5 hours ago (2009-11-28 06:56:00)  by Doug Robbins - Word MVP
See the following page of fellow MVP Graham Mayor's website: http://www.gmayor.com/changing_envelope_layout.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, originally posted via msnews.microsoft.com "dauhnl" wrote in message ... i can only print 8 1/2 x 11 on ...
Thread:  Show this thread (2 posts)   Thread info: Prints only 8 1/2 x11 envelope, no matter what size selected Size: 1,598 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Prints only 8 1/2 x11 envelope, no matter what size selected :: Mailmerge :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 6 days, 10 hours ago (2009-11-28 01:17:00)  by Miles
I'm having a very strange problem in Word 2007 only, previous versions of Word are all OK. I start with a table containing an INCLUDEPICTURE field, works fine. If I move the table around *sometimes*, the IncludePicture magically gets converted into a hard-coded picture (round selection buttons at the corners, green dot connected to top, middle of frame). Examining the Document.Fields...
Thread:  Show this thread (2 posts)   Thread info: IncludePicture in table magically becomes an image, loses field Size: 2,456 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "IncludePicture in table magically becomes an image, loses field :: Mailmerge :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 1 week ago (2009-11-26 23:08:00)  by Doug Robbins - Word MVP
If you press Alt+F9 to toggle on the display of the field codes in the document, the DocVariable fields will appear as { DOCVARIABLE variablename } -- 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 "Paul" wrote in message ... ...
Thread:  Show this thread (4 posts)   Thread info: DocVariable Size: 1,044 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: DocVariable :: Mailmerge :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 1 week ago (2009-11-26 23:07:00)  by Doug Robbins - Word MVP
It is not clear to what drop down you are referring. It would be easier to give you specific advice related to your version of the software if you had told us what it is. However, in all versions, you can select a file from any folder to which you have access on your computer or network - by making use of the left hand panel of the Select Data Source dialog, which may have a ...
Thread:  Show this thread (4 posts)   Thread info: Word Mail Merge 'select existing Doc' How purge list in drop dn Size: 1,209 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Word Mail Merge 'select existing Doc' How purge list in drop dn :: Mailmerge :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Microsoft Office (Excel, Word) forum - OfficeFrustration
Started 1 week ago (2009-11-26 22:06:00)  by macropod[_2_]
Hi kaneda0149, The simplest appraoch is to put your address lines inside a table cell with the desired fixed row height. That way, the suppression of the unused lines won't affect the layout of the rest of the page. -- Cheers macropod [Microsoft MVP - Word] "kaneda0149" wrote in message ... I have a mail merge letter document already in place where there are four (4) ...
Thread:  Show this thread (4 posts)   Thread info: Macro To Set Salutation Line Size: 1,197 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Macro To Set Salutation Line :: Mailmerge :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
 

Hot threads for last week on Mailmerge::

Mailmerge
Started 1 week, 2 days ago (2009-11-25 10:37:00)  by Peter Jamieson
There is certainly a problem with Word 2007 (possibly with Vista) to do with data files on network drives that did not exist in earlier versions. Whether there is a solution, or precisely what that might be, I cannot tell for sure. Things you may be able to check include: a. are the "users that work" also using Vista, or are they using XP? b. do you have the same permissions as ...
Thread:  Show this thread (10 posts)   Thread info: Word 2007 - mailmerge, live update of recipients Size: 4,685 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Word 2007 - mailmerge, live update of recipients :: Mailmerge :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Mailmerge
Started 1 week, 1 day ago (2009-11-25 20:28:00)  by Doug Robbins - Word MVP
I think that I would do the whole thing in Access. However to do it in Word, I think that you will need to use a "roll-your-own" VBA equivalent to mailmerge. Such an approach is used in the following which allows the "use" of formfields as used in protected documents with mailmerge. It may be enough to get you started. Sub MailMergefromAccesswithFormFields() Dim dSource As ...
Thread:  Show this thread (4 posts)   Thread info: Creating dependency between records in Mail Merge directories Size: 3,637 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Creating dependency between records in Mail Merge directories :: Mailmerge :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Mailmerge
RE: DocVariable - 4 new posts
Started 1 week ago (2009-11-26 23:08:00)  by Doug Robbins - Word MVP
If you press Alt+F9 to toggle on the display of the field codes in the document, the DocVariable fields will appear as { DOCVARIABLE variablename } -- 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 "Paul" wrote in message ... ...
Thread:  Show this thread (4 posts)   Thread info: DocVariable Size: 1,044 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: DocVariable :: Mailmerge :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Mailmerge
Started 1 week ago (2009-11-26 23:07:00)  by Doug Robbins - Word MVP
It is not clear to what drop down you are referring. It would be easier to give you specific advice related to your version of the software if you had told us what it is. However, in all versions, you can select a file from any folder to which you have access on your computer or network - by making use of the left hand panel of the Select Data Source dialog, which may have a ...
Thread:  Show this thread (4 posts)   Thread info: Word Mail Merge 'select existing Doc' How purge list in drop dn Size: 1,209 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Word Mail Merge 'select existing Doc' How purge list in drop dn :: Mailmerge :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Mailmerge
Started 1 week ago (2009-11-26 22:06:00)  by macropod[_2_]
Hi kaneda0149, The simplest appraoch is to put your address lines inside a table cell with the desired fixed row height. That way, the suppression of the unused lines won't affect the layout of the rest of the page. -- Cheers macropod [Microsoft MVP - Word] "kaneda0149" wrote in message ... I have a mail merge letter document already in place where there are four (4) ...
Thread:  Show this thread (4 posts)   Thread info: Macro To Set Salutation Line Size: 1,197 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Macro To Set Salutation Line :: Mailmerge :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Mailmerge
Started 1 week, 1 day ago (2009-11-25 18:58:00)  by Peter Jamieson
Mail merge expects a data source to be a table: in the scenario you describe, you wouldn't be able to use your data as a data source because in effect, you have a different "data source" for each item of data and mailmerge only knows how to work with one. As long as you are only producing /one/ output document, you should be able to insert LINKS to the relevant data item, and update ...
Thread:  Show this thread (4 posts)   Thread info: Mailmerge named ranges from Excel03 to Word03 Size: 3,374 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Mailmerge named ranges from Excel03 to Word03 :: Mailmerge :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Mailmerge
Started 1 week, 1 day ago (2009-11-26 00:08:00)  by Peter Jamieson
If you can, before you do the merge, select the rows and columns you need in the Excel Spreadsheet(probably everything except row 1) and create a range name that covers that area. Then, when you set up the connection from Word, you should see that range name listed in the "Tables" dialog box. Unfortunately you will probably need to do this each time you merge as the range will ...
Thread:  Show this thread (3 posts)   Thread info: Mail Merge: Column titles Size: 1,881 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Mail Merge: Column titles :: Mailmerge :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Mailmerge
Started 6 days, 4 hours ago (2009-11-28 07:04:00)  by Doug Robbins - Word MVP
It is the Update Labels button under the Write and Insert Fields section of the Mailings tab of the Ribbon that you need to use, but it is only enabled if the document is a label type mail merge main document. Via the Start Mail Merge button in the Start Mail Merge section of the Ribbon, check what type of mail merge main document Word thinks it is working with. -- Hope this helps....
Thread:  Show this thread (3 posts)   Thread info: Mail Merge Word 2007-UPDATE LABELS Size: 1,491 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Mail Merge Word 2007-UPDATE LABELS :: Mailmerge :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Mailmerge
Started 1 week, 1 day ago (2009-11-25 20:33:00)  by Doug Robbins - Word MVP
Have you read all of the introductory information on Graham's website, particulaly Note 2. Where do you have the template installed? What is your operating system and what version of Office are you using? -- 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...
Thread:  Show this thread (2 posts)   Thread info: Mail Merge to multiple docs to save as multiple files Size: 1,740 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: Mail Merge to multiple docs to save as multiple files :: Mailmerge :: Microsoft Office (Excel, Word) forum - OfficeFrust..."
Mailmerge
Started 1 week, 2 days ago (2009-11-25 11:51:00)  by Graham Mayor
What are you using to attempt to convert the files to Word format? If you want to send me a sample I could see what may be possible - use the link on the home page of my web site. -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org artvic46 wrote: I have Professional Write files I can not access. I get a message ...
Thread:  Show this thread (2 posts)   Thread info: converting professional write document to word document Size: 936 bytes
Related Threads: Same Site | All Sites
Customize:  Customize "RE: converting professional write document to word document :: Mailmerge :: Microsoft Office (Excel, Word) forum - OfficeFrust..."