Mail Merge

[mouseman]

Hi,

I have a 50 records added to my Mail Merge. I need to add another field (Address 2) to the Mail Merge. Is there a way to add another field, I could not figure it out. Thanks in avance.

Stephen

 

[mdav2]

You need to change the data source to incorporate the second field (address 2). This may involve changing the way the data is extracted or created. Once done then the field will appear ready for you to add into your document.

 

[mouseman]

Hi, thanks for your help. What is the best way to do this without losing any information i entered in. Is there a quick way? I tried a couple, nothing seems to work. Thanks again.

 

[nberryman]

If you used the mail merge wizard the data source will be a Word document with a table. Open the document and add a column where you want it and fill it in.

When you open the merge document it will see the new field and you will be able to add it to the doc.

Neil Berryman
IT Trainer
neil_berryman@btopenworld.com

 

[megmem]

Thanks, works great

 

[Dreamboat]

Just an FYI for you, Neil.

Word XP uses an Access database as the default data source now---it actually creates an Access db...ya believe it?? Anne Troy

http://www.TheWordExpert.com

http://www.Brainbench.com

 

[Snickle]

I suppose I could insert another column in my Excel file with Address 2 as the header and merge from there?

 

[nberryman]

If XP uses an Access database as a data source what if you don't buy Access. Do they now all come with run time?

Neil Berryman
IT Trainer
neil_berryman@btopenworld.com

 

[Dreamboat]

Actually, I don't think you can buy Office without it. And I dunno what they do if you only buy Word. Probably reverts to Word as data source. Not sure. Anne Troy

http://www.TheWordExpert.com

http://www.Brainbench.com