Re: mail merge with a word database

Thank for your help, unfortunately I am not even getting paid for this!

To answer your question, the database form is consistant, it starts with the
name and address of the business, followed by name and title followed by a
bulleted list of employees. This is all on one page per business (all 97 of
them) - what type of macro would I need to do this?
--
Thanks,,
Kim


"Doug Robbins - Word MVP" wrote:

It is not so much an issue of how you set up the necessary fields as one of
the manipulation that will be required of the data to get it into a format
that it is suitable for use as a mail merge data source.

If there is consistency in the way the data is arranged on each page, it
should be possible to create a macro that will manipulate that data into an
acceptable format, but we would need to know exactly how it is arranged to
be able to make suggestions for the code for such a macro.

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

"Kim K" <KimK@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:E751C6E9-F200-4B72-9DB2-A7C26C1B1E61@xxxxxxxxxxxxxxxx
I have 2 word docs given to me to merge. One is a form letter, the other
the
"database". THe form letter needs to have 3 fields. Field one needs to
pull
the info from the database of name of business, address, city, state,
zip -
FIeld 2 needs ot pull the name and title of the program director, foeld
three
needs to have a list of the employees and their title. All this info is
on
seperate pages in teh word database.

How do I set up the necessary fields to populate the corerct info into the
proper places? I ahve only done this with excel but never word, so input
is
appreciated.
--
Thanks,,
Kim



.

Relevant Pages

  • Re: checkbox help
    ... > weekly basis for multiple bowling leagues based on the league itself. ... > and use that in a calculation to find out how much the bowler owes Total ... > how much they have paid. ... > If necessary I can supply the database for help. ...
    (microsoft.public.access.gettingstarted)
  • Re: Date problem
    ... in the database there is stored the year (as int) and the month. ... Now, when retrieving datasets from the database, of course, '1' means 'JANUARY'. ... When I want to print a notification/bill, I want to say "The dues have to be paid until 15 of January 2007". ... the common '0' makes as much sense as defining JANUARY as something other that the common '1'. ...
    (comp.lang.java.programmer)
  • Re: Determining market penetration.
    ... >I have been having a debate recently on another forum about database ... >b) if an install is paid for, how much was paid (VAR, Corporate ... and the deployed run-times can be to customers. ...
    (comp.databases.theory)
  • Re: USS Liberty Coverup for the Jooz.
    ... >> From your database you know how long it took and how reluctantly ... >> they paid. ... Mind you seeing the inflamatory rot that gets ...
    (sci.military.naval)
  • Re: UPA membership expirations
    ... you paid, so they had to keep track of everybody's renewals (and that ... And college players to be would subscribe. ... everything to the database... ...
    (rec.sport.disc)
Loading