- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Mail merge help, anything to have merge build a table and populate fields?
Posted on 10/3/19 at 7:03 pm
Posted on 10/3/19 at 7:03 pm
1. Mailing account info to multiple clients
issue
2. Some clients have multiple types of accounts
Header fields for every balance
1. client
2. address
3. account type (example: checking, saving, investment)
4. Account number
5. Balance
Example report
Mr. Doe
123 main st
Checking
xxxx123 $20,000
savings
xxxxx321 $80,000
next record
Ms. Bubba
Checking
xxxx999 $10,000
xxxx888 $15,000
Investment
xxxxx777 $175,000
next record
I can't seem to figure out how to dynamically add additional rows or remove unneeded rows.
Can mail merge see two checking records and post each under checking? See no saving account so delete that section.
as of now I'm having to create checking account 1,2,3,4,5....and have "blank" information filled in and then manually delete each blank line.....for over 800 clients we are running this adhoc (once every couple years) mailer.
Hate word!
issue
2. Some clients have multiple types of accounts
Header fields for every balance
1. client
2. address
3. account type (example: checking, saving, investment)
4. Account number
5. Balance
Example report
Mr. Doe
123 main st
Checking
xxxx123 $20,000
savings
xxxxx321 $80,000
next record
Ms. Bubba
Checking
xxxx999 $10,000
xxxx888 $15,000
Investment
xxxxx777 $175,000
next record
I can't seem to figure out how to dynamically add additional rows or remove unneeded rows.
Can mail merge see two checking records and post each under checking? See no saving account so delete that section.
as of now I'm having to create checking account 1,2,3,4,5....and have "blank" information filled in and then manually delete each blank line.....for over 800 clients we are running this adhoc (once every couple years) mailer.
Hate word!
Posted on 10/3/19 at 8:34 pm to Kujo
Do you have any reporting tools? Even MS Access would be a better tool for this.
Popular
Back to top
