Reply
 
Thread Tools Display Modes
  #1   Report Post  
Nicci Nicci is offline
Junior Member
 
Posts: 1
Default Mail merge formula

Hi,

I am trying to mail merge a letter from data in a spreadsheet.

I need to be able to find a company name and bring back multiple employees from that company.

I can bring back the first person it finds for that specific company but not multiple names on the same letter.

Does anyone know the formula for this?

Thanks, Nicci
  #2   Report Post  
WelshGasman WelshGasman is offline
Junior Member
 
Posts: 3
Default

Quote:
Originally Posted by Nicci View Post
Hi,

I am trying to mail merge a letter from data in a spreadsheet.

I need to be able to find a company name and bring back multiple employees from that company.

I can bring back the first person it finds for that specific company but not multiple names on the same letter.

Does anyone know the formula for this?

Thanks, Nicci
You do not say how your sheet is structured, but to do that, the sheet would have to have the company name for each employee in a column. Then you could filter on that company in the mailmerge.?
Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using a formula in mail merge Rounder Mailmerge 1 January 30th 14 06:12 PM
NEED HELP !!!!! Add another formula to the Mail Merge Forumla IF Adi.Master Mailmerge 0 August 18th 13 11:34 PM
Multiplying a mail merge formula Grazza215 Mailmerge 0 August 13th 13 04:42 PM
Mail Merge Formula - Logic Stumped MaxArk[_28_] Mailmerge 2 June 1st 10 11:11 AM
Date formula in merge Chandra Mailmerge 1 May 17th 06 06:41 PM


All times are GMT +1. The time now is 11:52 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"