Home |
Search |
Today's Posts |
#7
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail merge question
Maybe this might help.
How to send the current record to Word 2000 with automation 'http://support.microsoft.com/kb/q210271/ Private Sub MergeButton_Click() On Error GoTo MergeButton_Err Dim objWord As Word.Application 'Copy the Photo control on the Employees form. DoCmd.GoToControl "Photo" DoCmd.RunCommand acCmdCopy 'Start Microsoft Word 97. Set objWord = CreateObject("Word.Application") With objWord 'Make the application visible. .Visible = True 'Open the document. .Documents.Open ("C:\MyMerge.doc") 'Move to each bookmark and insert text from the form. .ActiveDocument.Bookmarks("First").Select .Selection.Text = (CStr(Forms!Employees!FirstName)) .ActiveDocument.Bookmarks("Last").Select .Selection.Text = (CStr(Forms!Employees!LastName)) .ActiveDocument.Bookmarks("Address").Select .Selection.Text = (CStr(Forms!Employees!Address)) .ActiveDocument.Bookmarks("City").Select .Selection.Text = (CStr(Forms!Employees!City)) .ActiveDocument.Bookmarks("Region").Select .Selection.Text = (CStr(Forms!Employees!Region)) .ActiveDocument.Bookmarks("PostalCode").Select .Selection.Text = (CStr(Forms!Employees!PostalCode)) .ActiveDocument.Bookmarks("Greeting").Select .Selection.Text = (CStr(Forms!Employees!FirstName)) 'Paste the photo. .ActiveDocument.Bookmarks("Photo").Select .Selection.Paste End With 'Print the document in the foreground so Microsoft Word will not close 'until the document finishes printing. objWord.ActiveDocument.PrintOut Background:=False 'Close the document without saving changes. objWord.ActiveDocument.Close SaveChanges:=wdDoNotSaveChanges 'Quit Microsoft Word and release the object variable. objWord.Quit Set objWord = Nothing Exit Sub MergeButton_Err: 'If a field on the form is empty, remove the bookmark text, and 'continue. If Err.Number = 94 Then objWord.Selection.Text = "" Resume Next 'If the Photo field is empty. ElseIf Err.Number = 2046 Then MsgBox "Please add a photo to this record and try again." Else MsgBox Err.Number & vbCr & Err.Description End If Exit Sub End Sub |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mail merge question | Mailmerge | |||
Mail merge question | Mailmerge | |||
Mail Merge Question | Microsoft Word Help | |||
Mail Merge Question | New Users | |||
Mail Merge question | Microsoft Word Help |