Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge - Using Word as the data source?
Hi, I have a word document with mailing labels. Is it possible to go
backwards and export this data into Excel? If so, details? Thanks a ton! |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge - Using Word as the data source?
Hi mrfrenchy,
If your Word document was generated via a mailmerge, then the mailmerge data source would probably be a better place to start exporting the data in a format suitable for Excel. If all you've got is a set of labels in Word, each formatted along the lines of: Title Init S_Nm Company_Nm Premises_Nm Post_Addr Locality State Zip and/or: Title G_Name S_Nm Street_Addr Locality State Zip then you could easily enough turn these into sets of delimited fields like: Title Init S_Nm, Company_Nm, Premises_Nm, Post_Addr, Locality State Zip and: Title G_Name S_Nm, Street_Addr, Locality State Zip You can easily enough import these into Excel, but you'll have to deal with labels that have fewer fields than others (eg no Company_Nm and/or Premises_Nm) and you'll probably want to split the first and last lines of the address blocks into their component parts also. Again, you'll have to deal with missing data (eg no Init) and fields that might consist of more than one word (eg S_Nm, Locality, State) So, yes, you can do it, but you might have a lot of word to do to get it all structured correctly if you start working from your Word document. Cheers -- macropod [MVP - Microsoft Word] "mrfrenchy" wrote in message ... Hi, I have a word document with mailing labels. Is it possible to go backwards and export this data into Excel? If so, details? Thanks a ton! |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mailmerge - Using Word as the data source?
Graham Mayor has some info. that may help at
http://www.gmayor.com/convert_labels...mail_merge.htm Peter Jamieson "mrfrenchy" wrote in message ... Hi, I have a word document with mailing labels. Is it possible to go backwards and export this data into Excel? If so, details? Thanks a ton! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
take yet another lesson from wordperfect "reveal codes" | Microsoft Word Help | |||
Detach or change SQL data source for Word template, and other Qs | Mailmerge | |||
Change paper size; Word changes to invalid margins | New Users | |||
Word 2003 Mail Merge Problem when E-Mailing Data Source | Mailmerge | |||
multiple docs, one data source | Mailmerge |