 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / December 2003Mail Merge, Can not get it to work!!! PLEASE HELP!!
Hello, I have a been trying to get a list of names (approx. 600-700) to merge with word. My original file looks like this in word and notepad. Ex: Regina Lewis 6400 8th Ave 90043 Los Angeles Cassandra M. York 736 E 103rd St 90002 Los Angeles Eleazar Valenzuela 352 W 68th St 90003 Los Angeles Ruth E. Parks 2056 W 68th St 90047 Los Angeles This is how it looks in notepad, and word. If I import it into excel it puts each line in a row (Not sure how to work Excel, but I thought I would give it a try. Anyway,) The file is typed this way, meaning that if I look at the carriage return's there is one after each typed line. I tried to find and replace with a comma, for merging with comma seperated values , but that does not work. There are 11 names to a sheet. Any help would be appreciated.. MC Hi Manny, See the following page of fellow MVP Graham Mayor's website: http://www.gmayor.com/convert_labels_into_mail_merge.htm Please post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP > Hello, > [quoted text clipped - 18 lines] > > This is how it looks in notepad, and word. If I import it into excel it puts each line in a row (Not sure how to work Excel, but I thought I would give it a try. Anyway,) The file is typed this way, meaning that if I look at the carriage return's there is one after each typed line. I tried to find and replace with a comma, for merging with comma seperated values , but that does not work. There are 11 names to a sheet. > Any help would be appreciated.. > > MC You are the man! I cannot believe it but this is gonna make my life so much easier today. Thank you and Happy holidays.. MC |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.