Go Back  DVD Talk Forum > General Discussions > Tech Talk
Reload this Page >

Excel help: mail merge specific items

Tech Talk Discuss PC Hardware, Software, Internet and Other Technology

Excel help: mail merge specific items

Old 11-05-07, 01:45 PM
  #1  
DVD Talk Limited Edition
Thread Starter
 
A-aron's Avatar
 
Join Date: Apr 2002
Location: Formerly known as achau9598 - Baltimore, MD
Posts: 5,719
Likes: 0
Received 0 Likes on 0 Posts
Excel help: mail merge specific items

ok .. my boss gave me an excel sheet of about 75 names and addresses. There are three letters, and the addresses could be used for any one of the three letters as needed.

Is there a way to mark certain addresses for certain letters? That way when I merge the addresses into the letter, only those tagged for that letter will merge?
Old 11-05-07, 03:19 PM
  #2  
Senior Member
 
Join Date: Jun 2001
Location: dc-md-va
Posts: 959
Likes: 0
Received 0 Likes on 0 Posts
Wow, Mail Merge seems to have changed since I last used it.

Anyway, assuming an Excel->Word merge, it seems that (in Word) you can use a conditional Skip Record If under Insert Word Field (Mail Merge toolbar). So, if want to add a column in the Excel file as a checkbox for the merge, then Skip Record If new-column not ' ', or new-column equal Letter A,B,C, it will work.

Last edited by dleedlee; 11-05-07 at 03:22 PM.

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are Off
Pingbacks are Off
Refbacks are Off


Thread Tools
Search this Thread

Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service - Do Not Sell My Personal Information

Copyright 2018 MH Sub I, LLC dba Internet Brands. All rights reserved. Use of this site indicates your consent to the Terms of Use.