Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-21-2015, 03:33 AM
Roger Keeling Roger Keeling is offline Creating recipient list for mail-merge Windows XP Creating recipient list for mail-merge Office 2003
Novice
Creating recipient list for mail-merge
 
Join Date: May 2015
Posts: 4
Roger Keeling is on a distinguished road
Default Creating recipient list for mail-merge


Using mail-merge I can create and send individualised emails to addresses on a recipient list. To create the list I have to type in all the details manually. I have a windows folder containg a series of .txt files of details of people I would like to email. Is it possible to populate the mail-merge recipient list directly from these files? I'd be happy to write a simple program (eg in visual basic) to do the conversion if I knew the structure of the recipient list.
Reply With Quote
  #2  
Old 05-21-2015, 04:13 AM
gmayor's Avatar
gmayor gmayor is offline Creating recipient list for mail-merge Windows 7 64bit Creating recipient list for mail-merge Office 2010 32bit
Expert
 
Join Date: Aug 2014
Posts: 4,096
gmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud ofgmayor has much to be proud of
Default

A mail merge data file can have any format you wish. Ideally you would create an Excel worksheet with the data you require in columns with a header row. If you can get your text files into a worksheet in a common layout you should be good to go.

Without any information about the format of the text files, it is impossible to advise further.
__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com
Reply With Quote
  #3  
Old 05-23-2015, 04:34 AM
Roger Keeling Roger Keeling is offline Creating recipient list for mail-merge Windows XP Creating recipient list for mail-merge Office 2003
Novice
Creating recipient list for mail-merge
 
Join Date: May 2015
Posts: 4
Roger Keeling is on a distinguished road
Default

Thanks. I can create a .csv file and feed that into an excel spreadsheet so it looks like a complete solution.
Reply With Quote
Reply

Tags
recipient list

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Editing recipient list in mail merge from word 2007 not working dlaslett Mail Merge 4 03-16-2015 02:02 AM
Creating recipient list for mail-merge Recipient counter in Mail Merge Wizard displays only one digit in Word Liuneddu Word 1 08-13-2013 03:57 AM
Mail merge with a hyperlink for multiple recipient with different url's? prkk.06 Mail Merge 6 05-01-2013 06:42 AM
Creating recipient list for mail-merge Edit mail merge recipient list Freddies_grandad Mail Merge 7 12-10-2012 11:05 PM
Creating recipient list for mail-merge mail merge stops midway and then generates messages with no recipient or subject VivaceTS Mail Merge 1 08-09-2012 05:31 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:49 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft