 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / March 2004Word/Access mailmerge
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 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.  Signature<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> Graham Mayor - Word MVP Web site www.gmayor.com Word MVP web site www.mvps.org/word <>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> > Hallo, > [quoted text clipped - 13 lines] > Regards, > Harmannus Hallo, Thanx for the reply. How do i convert a document linked to a Access database to "normal document" to preserve the data but not the link? Regards, Harmannus > 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 [quoted text clipped - 18 lines] > > Regards, > > Harmannus You should be doing the first thing that Graham mentioned. That is, execute the merge to a new document and save that. The new document will be populated with the data from Access, but there will be no link to the database. The data will appear as normal text in the document. SignaturePlease post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP > Hallo, > [quoted text clipped - 33 lines] >> > Regards, >> > Harmannus Hallo, Thanx for the reply! I merge based on a .dot template. So the document is new. Saving this document has a link to the database (what i do not want).. Regards, Harmannus > You should be doing the first thing that Graham mentioned. That is, > execute the merge to a new document and save that. The new document will be [quoted text clipped - 38 lines] > >> > Regards, > >> > Harmannus If you create a merge document from a template it is simply a document copy of the template. You still need to merge to a new document to produce a new document containing record content and not fields. Signature<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> Graham Mayor - Word MVP Web site www.gmayor.com Word MVP web site www.mvps.org/word <>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<> > Hallo, > [quoted text clipped - 68 lines] >>>>> Regards, >>>>> Harmannus Hallo, I see. Thanx for the help! Regards, Harmannus > If you create a merge document from a template it is simply a document copy > of the template. You still need to merge to a new document to produce a new [quoted text clipped - 72 lines] > >>>>> Regards, > >>>>> Harmannus |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.