Mail Merge

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database in Excel that contains information for employees. In the
database an employee can have several salary adjustment amounts that I want
to merge into a Word document. After it pulls in all the information for one
employee I'd want it to page break and populate the next page with the next
employee's salary adjustments. I've tried the online tutorials but I can't
get this to work. If anyone has done this before I'd appreciate it if you
could share this with me.

Thank you.
 
I don't know how to do this in Word or Excell. This would be a very easy
job in a (relational) database program like Access. (vs. a spreadsheet or
word processing program.) Two tables (employees and salary adjustments,
linked on employee ID). The a report sorted and grouped by employee, with
employee name in the section header and a page break in the section footer.
 
Word isn't really designed to do this (you might be better off trying to do
it in Access, for example), but a starting point for doing this
without VBA is the MS Knowledgebase article at

http://support.microsoft.com/kb/211303

For other info that may help, I suggest you search Google Groups for recent
articles with the following search criteria:

Peter Jamieson MERGESEQ
 
Thank you so much...I'll give that a try.

FredFred said:
I don't know how to do this in Word or Excell. This would be a very easy
job in a (relational) database program like Access. (vs. a spreadsheet or
word processing program.) Two tables (employees and salary adjustments,
linked on employee ID). The a report sorted and grouped by employee, with
employee name in the section header and a page break in the section footer.
Click to expand...
 
Back
Top