View Single Post
 
Old 08-20-2018, 08:34 AM
Formd Formd is offline Windows 7 32bit Office 2007
Advanced Beginner
 
Join Date: Feb 2015
Location: TX
Posts: 46
Formd is on a distinguished road
Default One letter for each person in a mergefield using VBA

Hello everyone. Once again, I am seeking your assistance.

I have a mergefield called SERVICES, with a number of persons listed with name and complete address. The list /field could be any number of persons from 1 to 20.
The mergefield could looks like this:
Mary Brown
123 Address One
City, State 12345

John Brown
234 Address Two
City, State 23456

Jack Brown
345 Address Three
City, State, 34567

One Two Three Association
456 Address Four
City, State 45678

The Alphabet Bank
567 Address Here
City, State 56789

I have a letter that I want to send to each person listed in my "SERVICES" mergefield.
I am not sure if I use "Do while" or "Loop" Or maybe some other method.

What do I want to Accomplish - From the list above, my outcome should have 5 letters. Each letter Should have one of the names and address from the SERVICES field.

EXAMPLE, one of the five letters would look something like this:

Mary Brown
123 Address One
City, State 12345


Dear Mary Brown:

This is a letter to advise you............

Sincerely

Bob Jones
Manager

How can I make this happen?
Reply With Quote