| View previous topic :: View next topic |
| Author |
Message |
Lee Batdorff
General User
Joined: 20 Jun 2012
Posts: 5
Location: Cleveland Ohio
|
 Posted: Thu Jun 21, 2012 9:04 am Post subject: Mail merge will not include zip code |
 |
|
I'm trying out OOs mail merge feature and I seem to be able to make it work except it will not pull the zip code from the OO spreadsheet and put it where it should be.
I was told on this form to use the text function. In my spreadsheet I applied =VALUE("44124"). While the zip code appears in the spreadsheet cell it does not appear in my mail merge document. What am I doing wrong.   
Last edited by Lee Batdorff on Thu Jun 21, 2012 11:49 am; edited 1 time in total |
|
| Back to top |
|
 |
thomasjk
Super User
Joined: 16 Dec 2005
Posts: 2309
|
| Posted: Thu Jun 21, 2012 9:21 am Post subject: |
|
|
| The zipcode needs be entered as text not a number.. Use the Text function to covert them. |
|
| Back to top |
|
|
Lee Batdorff
General User
Joined: 20 Jun 2012
Posts: 5
Location: Cleveland Ohio
|
| Posted: Thu Jun 21, 2012 9:48 am Post subject: |
|
|
| thomasjk wrote: | | The zipcode needs be entered as text not a number.. Use the Text function to covert them. |
How do I use the text function while in Open Office mail merge? |
|
| Back to top |
|
|
Lee Batdorff
General User
Joined: 20 Jun 2012
Posts: 5
Location: Cleveland Ohio
|
| Posted: Thu Jun 21, 2012 11:35 am Post subject: |
|
|
| thomasjk wrote: | | The zipcode needs be entered as text not a number.. Use the Text function to covert them. |
I've tried several things including =value(44124) which it says is supposed to show up but does not. Very complicated to put a zip code in.   |
|
| Back to top |
|
|
thomasjk
Super User
Joined: 16 Dec 2005
Posts: 2309
|
| Posted: Thu Jun 21, 2012 12:05 pm Post subject: |
|
|
| You don't use Text during the mail merge. You have to change the underlying spreadsheet. Use the Text formula there not Value. Then copy the contents of the column that contains the formulas and use paste special to paste back into this same column. Click at the top of the column and Use Format--->Cells--->Text to format the entire column as text. This way when you add any new zipcodes they will be treated as text. |
|
| Back to top |
|
|
Lee Batdorff
General User
Joined: 20 Jun 2012
Posts: 5
Location: Cleveland Ohio
|
| Posted: Thu Jun 21, 2012 12:48 pm Post subject: |
|
|
| thomasjk wrote: | | You don't use Text during the mail merge. You have to change the underlying spreadsheet. Use the Text formula there not Value. Then copy the contents of the column that contains the formulas and use paste special to paste back into this same column. Click at the top of the column and Use Format--->Cells--->Text to format the entire column as text. This way when you add any new zipcodes they will be treated as text. |
I've been working on the spread sheet, not the mail merge document. What do you mean "copy the contents of the column that contains the formulas and use paste special to paste back into the same column." I've selected the column, then placed =TEXT for this column. Then I've copied this then special pasted it back into the column. No dice.
Where am I going wrong with this very complicated procedure?
All your help is appreciated.
|
|
| Back to top |
|
|
thomasjk
Super User
Joined: 16 Dec 2005
Posts: 2309
|
| Posted: Thu Jun 21, 2012 3:04 pm Post subject: |
|
|
Your formula should look something like this:
=Text(a1,0) assuming your numeric zip codes are column A.
Is that what you have?
Copy the formula down the column as far as you need.
Once you have the formulas correct then do the copy and paste special. You will want to adjust your merge document to point to the new column. |
|
| Back to top |
|
|
thomasjk
Super User
Joined: 16 Dec 2005
Posts: 2309
|
|
| Back to top |
|
|
|
