|
|
#1
09-27-2012, 10:30 AM
|
|||
|
|||
Word 2010 Merge Issues
I have a few questions about Merge in Word 2010:
Background: The data file is a name/address database in an Excel spreadsheet. For each record the street address is in four separate columns as follows: One column has the street number, next column has street direction (North, South, etc.), next column has street name, next column has suite number. (Example: 123 N Main Street Suite 200.) For most records the street direction column is empty and for most records the suite number column is empty. The entire database (about 200 records) will be merged into a Word document. Not a letter, not labels, just a regular Word document with one record appearing after another in the following layout (shown using Word merge field codes): <<Category>> <<Name>> <<Number>> <<Direction>> <<Street>> <<Suite>> <<Phone>> <<Web>> 1. How do I tell it not to include the space between <<Direction>> <<Street>> if the <<Direction>> field for that record is empty? 2. Excel stores phone numbers in this format: (123) 456-7890. When I do the merge the phone numbers appear as: 1234567890. How do I get it to either keep the Excel format or add dashes: 123-456-7890? 3. In the Excel database Web addresses are stored as a hyperlink. When I do the merge I get the web address but it’s plain text, not a hyperlink. How do I make it merge as a hyperlink? Thanks in advance for any help! Peter 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Word 2010 - TOC Issues | Skinny87 | Word | 2 | 07-03-2012 03:18 AM |
 Numbers don't merge right in Word 2010
|
ll4u76 | Mail Merge | 1 | 06-05-2012 11:53 AM |
|
Word 2010 and Excel 2010 Mail merge - multiple headers
|
robby | Word | 3 | 04-18-2012 06:37 PM |
|
word 2010 mail merge execute twice
|
smaddi | Mail Merge | 1 | 02-05-2012 02:45 AM |
| Mail Merge using Word 2010 - Header source not be recognized | Gage262 | Word | 8 | 02-01-2012 11:08 AM |
Windows 7 
Office 2007
Threaded Mode