Pages

Search

Microsoft Word - mail merge to multiple documents

Microsoft Word - mail merge to multiple documents


mail merge to multiple documents

Posted: 04 Jun 2014 01:45 PM PDT

We currently use Office 2002 & 2003 and XP, and are upgrading to Office 2010 / Windows 7.

Our 3party software creates a mailmerge data source with multiple mail merge records, then does a loop to call the Mail merge template multilpe times (once for each record) using this command:

open \\\\twsaasagl\\wdscript\\template\\Mars_AWD.dot with ""

This opens the template once, runs the auto open with this code and merges the first record only:

Sub MAIN()
Dim OpenDocs As Integer
OpenDocs = Documents.Count

'Auto mail merge
'-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
    With ActiveDocument.MailMerge
   
        .Destination = wdSendToNewDocument
        .SuppressBlankLines = True
        With .DataSource
            .FirstRecord = OpenDocs
            .LastRecord = OpenDocs
        End With
        .Execute Pause:=False
    End With
    
  End Sub

Then when the 3 party software calls the template again, it is already open, so it does not open again, then the autoopen code runs again, and merges the second record.  When the process is complete (up to 50 records), we have a button on the normal.dot tool bar that reads data from each document, prints the documents, saves with a file name found in the document and closes the document.

Problem:

With office 2010/window7, each time the third party software executes the

open \\\\twsaasagl\\wdscript\\template\\Mars_AWD.dot with "" code, a new instance of the template opens.  When the second instance (and all following) try to open the "this document is open for editing by another user" appears.  Even if I select "open read only , the code does not work because the could in the mail merge resets to 1 so the first record is merged over and over again.

I am aware of the gmayor solution for individual merge letters, however  it does not work because these are documents with header and footer, and the document must remain open after the merge, not automatically saved.

As an additional note, in the Office 2002 & 2003 if I change the code to open \\\\twsaasagl\\wdscript\\template\\Mars_AWD.dot with "winword.exe" , the same problem occurs.

Please help.

Anomalies with WORD 2007.

Posted: 04 Jun 2014 01:15 PM PDT

Dear Madam or Sir:

 

Is it my continued curse for having built my own PC, or is it simply that MS WORD is garbage? 

 

Since having tried to unsuccessfully install Office 2010 on my Windows 7 (Windows 8 is an atrocity to my mind) and having returned to Office 2007 within the past few weeks (May, 2014), I am now plagued by the following:

 

          ● The "Cut" function does not work whatsoever, and if I dare to attempt to use it for a "Paste"

             movement, I am totally SOL, as there is nothing "Pasted" and my original text is gone to the great

             beyond; and

 

          ● The "Copy & Paste" function in general is a hit-and-miss aggravation of the highest order,

             seemingly working only when it sees fit ("ghosts in the machine" indeed) to allocate a new text

             selection for copying purposes, but mostly only wanting to "copy" something that came from

             another previous work product.  This problem not only affects my document creation, but also

             anything that I wish to use with Mozilla Firefox for my "Hotmail" via the great and mighty

             "Outlook."

 

May anyone please be able to explain to me in a reasonable and intelligent manner as to why these anomalies may be happening and what should I do in order to correct/solve them?

 

Respectfully yours,

 

Gregory Falasz

How to default bullets in Word 2010

Posted: 04 Jun 2014 12:07 PM PDT

Is there anyway to set the default for bullet points in Word 2010 from round to square?

How do you set bullets point defaults?

Thank you!

converted from PDF to Word

Posted: 04 Jun 2014 12:06 PM PDT

I am working with a document that was converted from PDF format.

The document looks like a table but each piece of text is in a text box. Is there a way to convert this to a Word table and have the format remain the same? I know how to remove the text boxes and I've also tried converting them to frames but no matter what I do, I keep running into a problem with retaining the format.

Converting Word to PDF with List of Tables - Captions linked to previous location

Posted: 04 Jun 2014 10:20 AM PDT

Not sure if anybody else has run into this problem, but when I save a .docx to .pdf, the links from my table of contents and list of tables are embedded into the file, but the links for my list of figures are all referencing the original .docx file.  Is there a way to save in .pdf and have the figure captions embedded into the file?

Word Opening View

Posted: 04 Jun 2014 09:59 AM PDT

Word opens in a view that Microsoft thinks is good, but is irritating me. I don't know the technical name but it seems to be in some type of reading view, and is whatever the default that Word created. I have to click View and then Edit Document to get where I can work on any document. Is there a universal way to stop this? It doesn't matter how I save the document, I have the change views every time I open any document. Microsoft might think was a good idea, but I find it a waste of time and extra effort to work on my documents.

Word Style Strong Missing From Style Gallery

Posted: 04 Jun 2014 09:32 AM PDT

The word style Strong is missing from the style gallery but is in the complete list of styles.

How can I put it back?

Thanks

Hugh

insert into outlook word files sections with markups

Posted: 04 Jun 2014 09:00 AM PDT

I have word files with comments and markups.  I want to insert Sections of the word files into an e-mail with all of the markups and comments intact, so people can see the history.

Thanks

Creating sub-documents from parts of master document

Posted: 04 Jun 2014 07:34 AM PDT

I have a master document with a lot of parts included, but will often need to make documents from this document that do not include all headings (levels include 1 and 2) of the master. Each part is not long, but they are many. I am looking for a streamlined fashion to move terms over to shell documents prepared for different types of scenarios.

My best guess is using macros and may a user-form to move it over, but I'm new to the more advanced uses of word, especially macros. I'm familiar with Excel Macros, so I can see how it is possible there, but not here.

If I could get a direction on how best to go about this, I can look around for specifics as to more details, but any information on best direction would be great as I'm at a loss other than that guess above.

Thanks for the help!

Is XPS completely useless?

Posted: 04 Jun 2014 06:10 AM PDT

I made a XPS file and all I can do with it is view it in XPS viewer. Go ahead and tell me to get the addon do these people actally live in present or are they stuck in 2000 get new blood MS you are dying

"Conditional formatting" in Word? (no tables)

Posted: 04 Jun 2014 06:05 AM PDT

I have a very long chat log in a document. For each person's response, there is one line with the time and name, and the next line is the response. I would like to indent all the response paragraphs; in other words, every paragraph that does not start with a number. Is it possible to perform something similar to conditional formatting in Excel or tables in Word, but to paragraphs?

Can't access my Office 2003 documents

Posted: 04 Jun 2014 04:43 AM PDT

Since changes in early April 14, I am no longer able to access my Office 97 - 2003 documents.  I currently use Office 2007.  When I try to open them, I get a message telling me to disable the registry policy setting, plus a reference 922850.  I've tried to follow this up but can't find details on how to do this.  I imagine that I need to find a way of accessing the 2003 docs, then rewrite them as 2007 files.  Help ... I need my files!! 

When Inserting a Cross Reference, sometimes Heading section is missing - Any work arounds?

Posted: 04 Jun 2014 04:04 AM PDT

When I go to insert a Cross Reference to a Heading section (in my case, I am using numbered headings, so I would normally insert the Heading Number, then the Heading Text, then the page number (sure wish Word would do this in one step)), there are instances where the Heading Section is not listed at all in the scroll down list.  Microsoft Word seems to somehow get confused, I see the headings above and below the one I'm trying to reference, but not the section in question.  Seems like a bug, but something that's been there forever (currently I'm on Microsoft Word 2011 for Mac, latest available).  Are there any work-arounds to get the missing heading section appear on the insert Cross Reference list?

For example, assume I have sections 1, 2, 3:

1 Section 1

...

2 Section 2

....

3 Section 3

...

Sometimes, when I go to insert a Cross Reference to Section 2, the list will not show it.  I've tried rebuilding the Table of Contents (F9), etc., still not on the list.

Extra white space

Posted: 04 Jun 2014 03:57 AM PDT

Hello world!

Im having this problem with Word 2013. My pages have an extra white space (red cyrcles) as you can see in the picture. How can i remove this? 

Thanks

Table Problem

Posted: 04 Jun 2014 02:22 AM PDT

I would like to use a table to create a exercise program card, everything is fine until I try to paste a picture of the exercise in to one of the table spaces, the cell (is that the correct term ?) then expands to accommodate the picture, which then affects the rest of the table, ideally I would like the cell that I am going to paste the picture in, to be fixed so that I can adjust the picture size to suit the table, is this possible?

Mail Merge Problem

Posted: 04 Jun 2014 01:20 AM PDT

I am using office 2007 at my work. in which i am using mail merge option, and i am sending 500 mails to outlook at a time, but somehow my mails are not gng that smoothly, my word file get hang after sending 1 or 2 mails.... what can be the reason... plz help me out...

E-mail

Posted: 03 Jun 2014 10:23 PM PDT

I installed  Microsoft Office Home and Student 2010 on my computer(Family Pack). I cannot send emails with word files attached, because it says my trial period is up. How do I get the e-mail and attachment to send. I already paid for the 2010 version a few years ago. Thanks, TG 

Lynn

Posted: 03 Jun 2014 08:58 PM PDT

Hi,

I just want to know why you charge for this program? I thought it came free with your computer, and just updated itself.


Test documents' readability

Posted: 03 Jun 2014 07:52 PM PDT

I found the options to test the readability already. (For Word 2007, you right click the button Spelling and then choose Customize.... to see the table). But the option "Show readability statistics" is hidden, which means I cannot click on because it turns grey, unenabling me to click on. How can I enable it? 

Why can't I save my document as .docx in Word 2010?

Posted: 03 Jun 2014 06:51 PM PDT

I have several Word documents which make up the chapters of a report. When I bring the Word documents together they won't save as .docx. 

If I try to Save As and click save, the dialog box briefly disappears and then reappears. No error message, nothing. It just doesn't save. It will save fine as .doc or any other file type just not .docx.

The process I used to combine the documents is Insert>Object>Text from file. But I've found if I just copy and paste the contents from each of the Word documents I have the same problem.

This is not a pressing issue for me as I have discovered a workaround. It will save just fine with all the chapters if I first save the empty document BEFORE I add all the chapters of the report.

This really shouldn't be necessary though. If it were a one off issue I wouldn't care, but it has happened many times of different reports I have put together.

Does anyone have any idea how this happens or if it can be avoided?

Cheers

Josh

Spaces display in styleRef target when comment is added to styleRef source. Why?

Posted: 03 Jun 2014 04:35 PM PDT

I'm using Word 2007. I'm working in a document that uses the StyleRef field to copy text from the body of document to its header. I've found that when I add a comment to the source location of the StyleRef field (in the body of the document), an extra space displays in the StyleRef field, which is located in the header. Example: If the source location in the body of the document is the word "Guide" and I add a comment that is anchored on just the letter d, a space displays in the StyleRef field, located in the header, immediately after the d. The space deletes when the comment is deleted. What causes this problem and why? Is there anything that can be done to stop it from occurring?

The Print Preview panel in Word does not show an accurate preview of multiple-pages-per-sheet?

Posted: 03 Jun 2014 04:17 PM PDT

I'm trying to print a very large (many pages) landscape-oriented document. To save on paper, I want to print 4-pages-per-sheet. When I select this option from the bottom of the Print dialog, the print preview area shows the same as it did with 1-page-per-sheet, instead of a preview of the actual sheet with 4 pages on it.

This is very frustrating! I have no idea how this is going to look when I print... what's the point of having a preview at all, if it doesn't show what's going to be on the sheet?

In addition, when I print -- it puts the 4 landscape pages very small on a portrait sheet, instead of larger on a landscape sheet. Printing 2-pages-per-sheet put two landscape pages side by side on a landscape sheet. Either option is the worst possible choice... and I have no idea how to change this, because I can't tell what changes are happening when I make them, because the preview doesn't work!

Please fix this

Thanks,

Seth

page layout MS Office 2013

Posted: 03 Jun 2014 03:59 PM PDT

I am struggling with writing my first letters as I simply cannot work out how to use the page.  It is most frustrating as the bottom paragraph ends up on the second page and I simply cannot work out how to decrease the footer. Please advise.