Access/Word integration Mail Merge issue

Microsoft OFFICE

    Sponsored Links


  • 1. [Excel, VB6] Encode text before sending to Linux server
    Hi, I have a big problem when trying to send text from an Excel application running on Windows, to a Linux server. On the server some special characters like " or carriage returns are not properly retieved from the Windows client. So I need to know if there is a function that can encode text to do such ASCII network transfers. Thanks in advance! J.
  • 2. csv-utf8encoding-word-mailmerge
    Hi, I am writing data in to CSV file for different languages in windows .Please note that the following problems are not occurring in English I am using the streamwriter(.net) with the following encodings. 1. Encoding.UTF8: Then a dialog pops saying that UTF8 is selected. It also allows the users to select the other encodings. I want to avoid this. 2. Encoding.default(ANSI): When I am using this in German and generating the report a dialog pops saying that shift-JIS is selected. That is happening only for some of the cases. I want to avoid this dialog. I tried using encoding.Ascii(7bit) then dialog does not come. But this ASCII encoding is giving me problem in Japanese and it apparently gives the problem in Chinese as well. Any help will be greatly appreciated. Thanks in advance.
  • 3. Posting Data to Excel Spreadsheet
    Hi, I receive a daily Excel file with data collected from a website wher clients register. The data is all contained in Column 1. There are variable number of clients with 16 data elements per client, and al the HTML tags are intact. Using VBA, I can determine the range, how many clients are represente and I can extract the pertinent data from the HTML tags. My problem is posting each individual client to one row in anothe spreadsheet and posting the next client in the row underneath th first, etc. I tested the code by using a named range that represented only on client's data using a For Each...Next loop, and posting the data to on row on another spreadsheet. I don't know how to go back to the raw data and pick up the nex client, post that data to the next row, and so on. I tried using a dynamic array as: Dim ClientArray() As Variant Dim intClient As Integer Dim intData As Integer ReDim ClientArray(1 To ClientCount, 1 To 16) For intClient = 1 To ClientCount For intData = 1 To 16 THIS IS WHERE I DON'T KNOW WHAT TO DO Next intData Next intClient Or is there a better way? Thanks for your help
  • 4. Certificate distribution
    Hello NG, our company uses an access-application. We use Access 2003, so everytime we start this application, we are asked whether to allow the start, or not (due to the Office security settings). Now, we could set the security settings to "lowest", which we don't want (we use the "medium" settings); but for certain applications, we don't want to be asked at all. I tried user-certificates, but there isn't any mechanism to distribute them on the client-pcs. How can we handle this case? Thank you in advance for your support, kind regards from Germany, Uwe
  • 5. Word 2003
    I tried to create word document using MS word 2003 by macro and getting following error message. Microsoft Word The measurement must be between 0.05 pt and 1584 pt. The wired thing is the same code works on word xp version. Please help and thanks in advance Alan

Access/Word integration Mail Merge issue

Postby TWljaGFlbCBTdXR0a3VzLCBJSQ » Sun, 30 Oct 2005 03:11:04 GMT

I'm automating an Access database.  One of the functions that it must perform 
is to print out envelopes to certain addresses stored in the database.  I've 
put the code below into a command button, but when it is run, several dialog 
boxes come up, specifically "Data Link Properties", "Confirm Data Source" and 
"Log In".

This is unacceptable.  The point of automation is to prevent the user from 
having to make choices like this, especially such abstruse ones that will not 
make the slightest bit of sense to most of my end-users.

Further, it just shouldn't happen, since most of the choices being asked of 
the user have already been indicated in the code, so obviously I'm doing 
something incorrectly.

Any help would be appreciated.

(Also, tell me if I'm posting this to the wrong forum, the groups here 
aren't always clearly delineated.)

Private Sub cmdPrintEnvelopes_Click()
    Dim WordApp As Word.Application
    Dim WordDoc As Word.Document
    Set WordApp = CreateObject("Word.Application")
    WordApp.Visible = True
    Set WordDoc = WordApp.Documents.Open(Application.CurrentProject.Path & 
"\envelopes.doc", , True, False, , , , , , , , True)
    With WordDoc.MailMerge
        .Destination = wdSendToPrinter
        .OpenDataSource _
                Name:=Application.CurrentProject.FullName, _
                ReadOnly:=True, _
                LinkToSource:=False, _
                AddToRecentFiles:=False, _
                PasswordDocument:="EZ4ME", _
                Revert:=False, _
                Connection:="QUERY Envelopes"
    End With
    WordDoc.Close False
    WordApp.Quit wdDoNotSaveChanges
End Sub

RE: Access/Word integration Mail Merge issue

Postby TWljaGFlbCBTdXR0a3VzLCBJSQ » Wed, 02 Nov 2005 01:01:08 GMT

I'm really getting a bit desperate here.

I've tried doing this very simple task a dozen different ways without 
success.  Each solution either refuses to work or requires the user to make 
several abstruse choices (i.e., fails to be automation at all).

The annyoing thing is that it works so simply manually.  If I open up the 
Envelopes.doc file, it puts up a dialog box indicating it will run an SQL, 
requiring the user to do nothing more complicated than select "Yes", and then 
"Merge to Printer".

However, when trying to do this programatically, it refuses to automatically 
open the datasource, and certainly doesn't present any dialog box as simple 
as the "Yes to SQL" box from the manual opening.

This problem is too simple to be this frustrating.

Re: Access/Word integration Mail Merge issue

Postby TC » Wed, 02 Nov 2005 09:08:04 GMT

Where do you say the name of the Access database? All I see is:


but that doesn't look right.


Re: Access/Word integration Mail Merge issue

Postby TWljaGFlbCBTdXR0a3VzLCBJSQ » Wed, 02 Nov 2005 21:56:05 GMT

As the code is running in Access, that resolves to the name of the file the 
codes is being run from.

Similar Threads:

1.Automate Mail Merge using MS SQL VIEW in a Word Mail Merge Templat

I've created a Word 2000 template as a Mail Merge to print mailing labels.  I've specified the Datasource to be a MS SQL2000 View (sincie it won't take stored procedure).  When I double click on the template it opens up and creates a new document but it doesn't automatically merge the datasource.  I have manually click on the Merge icon for it to merge.  Can someone show me what VBA code I need to have the Merge automatically done when the dcoment is opened and created.  

2.Mail merge issues/ security delays with using Word to create merged emails


I recently updated my officed product to OFfice 2000 sp-1 
then 2 then 3.

Before updating I had no troubles using Word to merge 
emails. However since updating I now get a HIGHLY 
annoying and TIME consuming window that asks me 
permission to automatically generate an outgoing email. 
Then I have to WAIT 5 second and CLICK YES per merged 
email. If you are trying to maintain a list of some sort 
and send 50-100 emails, this is indeed very annoying.

Any assitance to eliminate or by-pass this step would be 
GREATLY appreciated.



3.Transition from Word 2000 to 2003 and template/mail merge issues

I have several templates that pull merge data from an excel spreadsheet, all 
of which work just fine in Word 2000.  However, when trying to open them in 
Word 2003 the following happens:
1.  If Local Open, the database (.xls sheet) is no longer associated with 
the template.
2.  After that doesn't work, if we try opening the template from Recent 
Files, the database is associated with the template.
3.  The merge works on some but not all records, even though the merge is 
based on the first column in the database.

I'm so confused, and I don't even know the right questions to ask you.

4.Word 2003 Mail Merge Issues - Help Needed

I've got to be missing something... and it is probably very simple.

I pull up a blank Word document.
Add verbiage for a generic letter formatted in Times New Roman with 12
point font.
Create a new mail merge list in Word.
Insert where the datapoints/bookmarks will go.
When the data is added to the letter, all of the datapoints have
different font sizes and types!

What have I missed?  Why does a Times New Roman with 12 pt font turn
into 10 pt Courier New and 10 pt Times New Roman?

I do a Ctrl+A to change the font all back to what it should be, but
there has to be a way around this font change during the recipient list




5.Word 2000 Mail Merge: Word found no mail merge fields

Hello everybody,

As the subject says, I am trying to create a form letter in Word 2000
from an Excel 2000 spreadsheet, but when I try to to open the data
source, I get the following error: "Word found no mail merge fields in
your main document".  How do I create mail merge fields?  Can anybody
help me?

Thanks in advance.

6. MS Access Query and MS Word Mail Merge issue

7. Access to Word Mail Merge Date Format Issue !

8. Dates issues with mail merge Access to Word

Return to Microsoft OFFICE


Who is online

Users browsing this forum: No registered users and 74 guest