Mail merge, using my own fields: .xls, word 2003 xp pro

Posted by Flotsam N. Jetsam on Super User See other posts from Super User or by Flotsam N. Jetsam
Published on 2010-12-27T18:21:00Z Indexed on 2010/12/27 18:55 UTC
Read the original article Hit count: 239

Filed under:

microsoft-word-2003

|

mail-merge

Office Version:Office 2003Operating System:Windows XP 0 I have a Word doc that looks like this:

<<PracticeName>>

<<PracticeAddress>> 

<<PracticeCitystate>>

<<PatientName>>

<<PatientAddress>>

And a .xls that looks like this:

PracticeName        PracticeAddress    PracticeCitystate     PatientName    PatientAddress

Acme Diagnostics    101 Apian Road     Cleveland, OH 44115   George Bush    111 Broad Way

I have Word 2003 and I:

Open Word & blank doc
>Tools>Letters&Mailings>MailMerge
Letters is checked>Next
Check "Start from existing," and select my aforementioned doc, open>Next
Check "Use an existing list," and open my aforementioned xls, open, use defaults > Next
Do nothing at "write your letter" > Next

OK, I'm at preview, yet my document still looks exactly as shown above. What am I doing wrong?

© Super User or respective owner

Related posts about microsoft-word-2003

hierarical numbering in microsoft word 2003

as seen on Super User - Search for 'Super User'
I have a headline in my document of level 3 and want the document hierarical numbered but it seems my level 3 headings do restart numbering at 1.1.1 and i have no clue why. it looks like that: 1. blah 1.1 blub 1.2 blub 2. blah 2.1 blub 2.2 blub 1.1.1 blubb <- shouldnt this be 2.2.1 ? 3. blah how… >>> More
Referencing a specific figure in Microsoft Word 2003

as seen on Super User - Search for 'Super User'
Referring to the screenshot below: I want to be able to reference the figure in the body of the text properly without having to change them manually every time I add a figure label before that body of text. However, I don't know how to do it aside from adding caption labels, which won't work for… >>> More
Preserving CDATA Editing Xml File using Microsoft Word 2003

as seen on Super User - Search for 'Super User'
I have an xml file that I need to edit using Microsoft Word 2003. Everything works fine but the CDATA section is lost and is converted to normal html. For example <Description> <![CDATA[ <i> ]]> </Description> Gets converted to <Description> <i> </Description> Is… >>> More
Referencing a specific figure in Microsoft Word 2003

as seen on Super User - Search for 'Super User'
Referring to the screenshot below: I want to be able to reference the figure in the body of the text properly without having to change them manually every time I add a figure label before that body of text. However, I don't know how to do it aside from adding caption labels, which won't work for… >>> More
Creating a specific style for tables in Word

as seen on Super User - Search for 'Super User'
I want to create a style specifically for tables. The problem I'm facing is that every time I create a new table or modify it, it switches to "Normal" instead of my "Table Text" >>> More

Related posts about mail-merge

Switch Text Paragraphs in OpenOfficeOrg Writer mailmerge

as seen on Super User - Search for 'Super User'
I am using mailmerge to write the same letter with minor differenes to many peolpe. I experienced that switching text paragraphs depending on database values was not easy for me. I ended up putting huge text paragraphs into the database becaus switching did not really work for me. Actually I dont'… >>> More
mail merge e-mail in Word 2007 with attachment

as seen on Super User - Search for 'Super User'
Is there a simple way to mail merge with Word 2007 and add an attachment? I've searched google, and all results point to pasting in VB code. I want to a small team of novice users to be able to mail merge e-mails and add attachments. Does anyone know a simple way of doing this without code? >>> More
Electronic Postage provider compatible with Microsoft Word Mail Merge

as seen on Super User - Search for 'Super User'
We're looking for an e-postage provider that is capable of working with the Mail Merge function in Microsoft Word 2007. Every now and then we extract addresses from our database to mail letters or notices. We use Mail Merge in Word 2007 to print the address information straight to the envelopes and… >>> More
Remove mailmerge data source via OpenXML

as seen on Stack Overflow - Search for 'Stack Overflow'
I have some code that uses OpenXML to open up a docx file, find all mailmerge fields, and replace them with data (ignoring the datasource that may have been provided). I initially tested this against a document created in Office 2007 and it seemed to work great. We then created one in 2003 based… >>> More
Question about mail merge in DesignPro 1.0.1 for mac

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm using Avery DesignPro v. 1.0.1 for mac to print out address labels using a mail merge. There are two columns for addresses (Address1 and Address2), but for most of the entries on the list, Address2 is blank. When I do the mail merge, I get several address labels with a blank line between Address1… >>> More