Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.docmanagement
ddbutterfield ddbutterfield is offline
external usenet poster
 
Posts: 1
Default How do I open existing data base (.mdb) to edit before doing a mer


  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default How do I open existing data base (.mdb) to edit before doing a mer

Use the database as the datasource for a Directory type mailmerge in the
main document of which you have a one row table with a mergefield in each
cell of that table. When you execute that merge to a new document, that
document will contain a table with one row of data for each record in the
datasource. Edit the data there and then insert a row at the top of the
table into the cells of which you insert the names of the mergefields. Then
save that document and use it as the datasource for your mailmerge.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"ddbutterfield" wrote in message
...



  #3   Report Post  
Posted to microsoft.public.word.docmanagement
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default How do I open existing data base (.mdb) to edit before doing a mer

Alternatively activate the old mailmerge helper (see
http://www.gmayor.com/mail_merge_lab...th_word_xp.htm ) whereby the edit
data source option will convert the MDB file to a Word document which you
can do what you want with. That will then be the data source for the merge.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Data sources for different mailmerge letters Lee Mailmerge 11 January 27th 07 08:04 AM
Using Excel as source data - can't edit Cowtoon Mailmerge 1 December 18th 06 05:57 PM
Cannot find datasource George Microsoft Word Help 3 July 22nd 06 03:38 PM
How Come? Michael Koerner Mailmerge 9 February 10th 06 10:29 PM
When I open an existing word document, I cannot modify or edit it beno Microsoft Word Help 1 January 23rd 06 08:23 AM


All times are GMT +1. The time now is 07:43 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"