Access/Word integration Mail Merge issue

Microsoft OFFICE

    Sponsored Links

    Next

  • 1. Beware IE7 Screws up vertical text controls in Access reports
    I've found another problem in Access (I'm using 2002) that appeared after installing IE7. If you have a vertical control (label or text) on a report with Arial font it will print in what appears to be Times New Roman. To reproduce: Create a new report On it place a label control and set its Caption property to "anything you like" Make sure the Font is set to Arial Set Font Size to 20 to view easier Now copy & paste the control Set the copied control's Vertical property to Yes Resize as necessary Now Print This is weird, the horizontal label prints as Arial but the vertical one prints Times New Roman I've just noticed that it doesn't have to be arial font, most other fonts still print out as T N R On machines that still have IE6 this behaviour doesn't occur. This is scary Any one any ideas on how to correct this problem or is it a bug? Cheers John
  • 2. Opening .ini file & using contents in textbox VBA
    Hi, iv been having trouble the last couple of weeks with a bit of vb, wondering if anyone could help. I Have a window which has a textbox ok and cancel button, in the textbox i need the value to show the contents of a .ini file, iv already got working that whatever the user types into the textbox and hits OK is written to the .ini file, i just need the textbox to display whatever value is in the file. any help appreciated :) Matt
  • 3. how to reference the commandbars
    i am using the webbrowser control in it i am loading a word document how do i refer to the commandbars.item(x) for that app all my current efforts keep effecting the commandbars in the hosting application (excel) i've tried webbrowser1.application.commandbars and webbrowser1.application.application.commandbars and others so--- host app is excel, which has a webbrowser control, which loads a word doc,...and i need to hide the commandbars in the word doc hope that's clear enough thanks you mg
  • 4. Beta 2007 Software
    I am unable to use beta Office 2007 plus. For some reason I can not get the application to open previous versions of office files. I have installed the compatiablitiy pack and files still will not open. In the mean time I reinstalled Office 2003 in order to have the ability to use email and compose letters. Attempts have been made to un-install the software. When doing so, I get a message stating the software is corrupt and need to reinstall from original source or an application disk. The soft was download and I can no longer get back to the Beta refresh web site for orginal source. When tryiing to reinstall by using the software save to my hard drive, I get the message that says the update is already on the computer. Can someone assist in providing a solution for un-installing the corrupt version? The add/remove application will not uninstall the version of Office Professional Plus 2007 beta 2. I have run out of options. Help !! -- Thanks, Demetris
  • 5. problem with getting page number of endnotes
    Hi, i have a problem with getting page number of endnote. I have document that has a lot of text and endnotes. Endnotes are placed on the last two pages(only endnotes on this two pages) in the document. And i have code like this: Sub CurPage() For Each en In ActiveDocument.Endnotes en.Range.Select Selection.MoveEnd wdCharacter, -1 MsgBox "Endnote ends on page" & Selection.Information(wdActiveEndPageNumber) Next End Sub I expect that Selection.Information(wdActiveEndPageNumber) will return current page, where the endnote is placed. But it returns number of the page where the reference (link) to this endnote placed. Maybe somebody know how to get correct page number and why it is happens? Thanks, Ruslan

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"
        
        .Execute
    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:

   Name:=Application.CurrentProject.FullName

but that doesn't look right.

TC


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

Hi, 
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.  
Thanks, 
Alpha

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

Hi,

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.

Thanks

Peter

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

merge. 


Thanks, 


Lisa

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.
Brian

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 59 guest