MS Word help anyone!

[Highfields Seagull]

As I thought. That's why I was checking about how they were separated before.

Would be OK if it was like this.

Name 1, Address 1 line 1, Address 1 line 2, Address 1 line 3
Name 2, Address 2 line 1, Address 2 line 2, Address 2 line 3

 

[On the Left Wing]

There is a way of doing it using Word. It is a right pain to do and it requires buying the proper labels as well.

I can't remember the details, but I think you have to go to

Tool > Mailings > Mail Merge

Don't do it if you are tired. It is really fiddly and awkward, but not as bad as excessive typing or writing it out by hand. Not for long list either.

Do a test run on the first page as the labels cost dosh and often come out screwy.

Pers ... that's how I started before I came on NSC to ask for help .....

thanks anyway

 

[perseus]

I see what you mean. My mistake. I am sure I have done something like this before. Can't remember how to do it today. And probably will not remember tomorrow either.

I would be inclined to use an Excel spreadsheet instead of a Access. I think this is what I must have done: typed the addresses in Excel first time around.

So it is how to get Word to export the addresses to Excel?

PS: If it was a one-off job, I would (and have done) put the addresses in columns and print them off on paper, and then cut out each individual address using a trimmer.
If this is on sticky paper it would not be too bad, as it is the sticking of the ungummed labels on the envelopes that is the hassle.

 

[On the Left Wing]

Probably, yes - need some useful delimiting character between each address....

yep that's where I am now ... brought it all into Excel as .txt with no problem and have field delimeters okay (returns) but now have to set up record delimeters .... will take a bit of time but a lot quicker than retyping ... still some way to go, but will report back again

Thanks guys

 

[On the Left Wing]

Okay guys I am stuck .... things aint working here for me. Tried variations but:


1. When I save as plain text .txt do I retain carriage returns and if so do I insert CR and Line Feed or just CR ?

2. Once in the spreadsheet, do I then save as an XLR or XLS or something else?

3. Then back in MS Word do I import the text in XLR/XLS format

If none of this works do I need to work on my address list again and place a comma at the end of every line as a field delimeter? Just a thought

Any other thoughts?

 

[sully]

Isn't it a .csv file that you need to save it as?

That's certainly what was required to import lists into Outlook.

It works best if you can get each address on one line with each cell across the page as a line of the address.

Rather than cutting and pasting, this can be done with a formula that can be copied down the page.

I did something similar to produce mailing labels from a list like I describe above and was very surprised at how easy it was once I'd got the formulas copying properly.

To finish off, you just copy and paste special:values, and you've got useful text rather than a page full of formulas.



I think.

 

[Barnet Seagull]

csv or xls.

 

[perseus]

I do not know if this works or is easier? Just an idea to play around with:

Arrange the Word document as follows:

Name,Address,Address,Post Code,

Name,Address,Address,Post Code,

Then in Excel go to Data > Import External Data > Tick the box comma delimited.

This would mean typing in lots of commas. Try a few as an experiment first. I think I have done something like this before.

Then you still have to work out to import back into Word with the correct label sizes etc. Uses the mailing list, labels menu. Too much of a heachache for me.

For a once-off I would still be inclined to print the addresses on a blank sheet of paper and then cut them up and stick them on with sellotape.

 

[On the Left Wing]

still trying - thanks guys

 

[Highfields Seagull]

Hope this makes sense:

How about post the list into Excel, it'll still be a list but one bit in each cell A1, A2, A3...etc.

Then in cell B1 type "=A2" and drag that all the way down.

In C1 type "=B2" and drag all the way down

Do this in D1, and E1 until you have the addresses in cells in horizontal order every 4 or five lines down.

Copy the whole lot and paste it into another sheet as values only.

Delete the gibberish rows that you no longer need.

I think this should do it and you'll be left with the addresses on a sheet in a nice easy format to import into a mail merge.

 

[Old Goat]

For a once-off I would still be inclined to print the addresses on a blank sheet of paper and then cut them up and stick them on with sellotape.

NOOOOOOOOOOOOOO!!
not for 600 addresses!!!!

 

[Old Goat]

Once you have the addresses in an Excel spreadsheet you can use this for a mailmerge - you dont have to move it back to Word or save it as a special type of file. And the mailmerge can use any sort of size label you can imagine. More details available on request....

 

[On the Left Wing]

EUREKA!!!

It's worked ... the problem was in the address , and . format to start with ... once I sorted that it slipped into EXcel and then mailmerge perfectly.


Well that's List 1 finished (280 addresses) just List 2 to do (330) !!!

Thanks again!