Re: Word/Access mailmerge

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Graham Mayor (gmayor_at_DELETECAPSmvps.org)
Date: 03/15/04 

Date: Mon, 15 Mar 2004 10:41:57 +0200

Merge to a new document which will insert the address data into the document
or if it is the field information you want, then convert the document to a
normal word document before saving it. You will then have to attach a data
file before you merge again. 

-- 
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
     Graham Mayor -  Word MVP
      Web site www.gmayor.com
  Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Harmannus wrote:
> Hallo,
>
> I use Access as a basis voor my Word mailmerge. Is there a way to
> preserve the (address) data from Access in my document on saving this
> document in Word? Word keeps a active link to the Database. I don't
> want this. Meaning saving the Word document should save it without
> the link but with the (address) data intact. I now save a document as
> RTF that solves this issue.
>
> But can it be done automatically? e.g a macro or that automatically
> saves as RTF and resaves as DOC or someting or a macro that removes
> the Link with the database but preserves the data?
>
> Thanx in advance for any tips!
>
> Regards,
> Harmannus

Relevant Pages

  • Re: Export Project notes to Access or Excel
    ... I was able to get the RTF by casting the column to varchar. ... from a Project database file to jdpeterson, ... What I do have however is a VBA macro ... I don't have a database server, ...
    (microsoft.public.project)
  • Word/Access mailmerge
    ... Word keeps a active link to the Database. ... saving the Word document should save it without the link but with the ... I now save a document as RTF that solves this issue. ... RTF and resaves as DOC or someting or a macro that removes the Link with the ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Setting up a template
    ... > creating a blank document from your template, saving the file as RTF, ... That's clever -- you've got my vote for this month's "thinking ... After using method 2 of Microsoft Knowledge Base article 193538, ...
    (microsoft.public.word.docmanagement)
  • Re: save as creates a hidden copy
    ... The reason I asked was to determine whether you were saving to a removable ... your macro is part of the problem or not, but FWIW there is a macro with ... >> Microsoft MVP ... >>> On the same topic, my working directory just accumulates temp files, ...
    (microsoft.public.word.application.errors)
  • Re: Indirect concatenated link doesnt work with UNC
    ... Saving B doesn't save ... just the formula/function. ... which of the Workbook A's to pull from, will just pull from whichever is open ... then have a macro which would use copy/paste special/value from ...
    (microsoft.public.excel)