Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Mail Merge


  • Please log in to reply

#1
Dominator666

Dominator666

    New Member

  • Member
  • Pip
  • 2 posts
I have a template that I would like to base a mail merge on. The query I have linked with the mail merge document has several records with the same information aside from a few fields. I would like to combine all of the duplicate records adn combine the few fields that do not have exact information. I am trying to create a report that gives information of customers. Each row on the query is a contact point (phone call) with the customer. Instead of having a seperate report for each call I want to have a seperate report that combines all of the differant phone calls while also displaying the customers information.

A document would have one section having the name, address, contact numbers, and such for the cusotmer. The section after that would have call #1, call #2, call #3 etc.. Each call information would be a combination of the differant date fields, call summary, and employee name fields of the query. Each call would also need to be on a new line. Is this possible in Word using VBA?

I successfully did this in Excel but inporting teh queries information and then have it copy the data into a prelaid out worksheet. The code then searched of rows that had the same tracking number and when to the date, summary, and employee name columns and combined it for each tracking number that matched.

Any help or ideas would be greatly appreciated. Thank you.
  • 0

Advertisements







Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP