Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-29-2014, 04:39 PM
macropod's Avatar
macropod macropod is offline Inputting 339 supplier names into individual Word documents Windows 7 32bit Inputting 339 supplier names into individual Word documents Office 2010 32bit
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 22,467
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by Aron19 View Post
What I need to do is have a supplier name input into Word for 339 different suppliers for the same letter that is going out.

I just want to be able to have the supplier names listed in Excel come over into Word and create an individual letter for each supplier without having to do all 339 myself by copying and pasting.

Is this possible?
That is quite possible using a letter mailmerge in Word.

To use this, your Excel data would need to be organised in columns, with a column for the supplier names and at least one column for each separate address line. The first row in Excel would be a header row and each subsequent row would have the supplier details. Thus, for the header row, you might have:
Supplier, Address1,Address2,Locality,State,Zip
It doesn't matter if some suppliers only have one address line - the blank ones can be suppressed in the mailmerge.

In Word, you'd write the letter as if it were going to just one supplier. having done that, you'd use Word's mailing tools to create the mailmerge. See:


http://word.mvps.org/FAQs/MailMerge/...AMailMerge.htm
http://office.microsoft.com/en-au/wo...102809678.aspx
http://support.microsoft.com/kb/294683/en-us
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Inputting 339 supplier names into individual Word documents Mailmerge Individual Documents DaddyMac Mail Merge 4 06-06-2013 09:22 PM
How to transpose the datas of part code and supplier into row and column PRADEEPB270 Excel 3 10-26-2012 07:22 PM
Watermark PPT prints with a series of individual names walvis PowerPoint 1 12-16-2011 06:49 AM
Inputting Sound files - 2 options, neither working. msteinruck PowerPoint 0 09-16-2010 09:44 AM
Inputting variable data axy Word 0 09-08-2009 04:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:23 AM.


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