Thread: [Solved] Need guidance on creating special use table
View Single Post
 
Old 02-06-2013, 02:31 PM
macropod's Avatar
macropod macropod is offline Windows 7 64bit Office 2010 32bit
Administrator
  
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,963
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
Hi bookbean,

You really haven't told us enough about your data or what you want to do with them for anyone to give specific advice. What particular issues are you having?

Also, despite your concerns about having separate cells for the city, state, etc, that is exactly how I would recommend setting up your data - preferably in Excel (though a Word table could be used). With the data at such a granular level, you can then easily use Word's mailmerge tools (or Excel's own functions) to reformat the data for different kinds of output (including tables with "the full address which includes street, suite number, city, state and zipcode ... as it would look in a letter or a mailing envelope").

As for "I will have to cut and paste", that largely depends on how the data are presently organised. Depending on what you now have, some or all of the compilation might be possible with a macro.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote