|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 22nd, 2006, 01:13 PM
posted to microsoft.public.publisher
|
|||
|
|||
Mail merge using Excel data
Using P2003 and mail merge
In Pub, whenever my "zipcode" field (that I am getting from an Excel file) has zip +4 digits, "0" shows up in the Pub merge results. In the Excel file, I have tried having the column attributes set as Custom, Text, and others to see if that was causing the problem, but still the same results. How can I get the zip + 4 to display correctly in the Pub merge? Thanks much for your help. 
|
|
#2
May 22nd, 2006, 04:46 PM
posted to microsoft.public.publisher
|
|||
|
|||
|
Mail merge using Excel data
Try inserting an apostrophe before the figures in Excel. This tells Excel
that the cell contains text. Does this work for you? -- Rae Drysdale "ladyt" wrote: Using P2003 and mail merge In Pub, whenever my "zipcode" field (that I am getting from an Excel file) has zip +4 digits, "0" shows up in the Pub merge results. In the Excel file, I have tried having the column attributes set as Custom, Text, and others to see if that was causing the problem, but still the same results. How can I get the zip + 4 to display correctly in the Pub merge? Thanks much for your help.
|
|
#3
May 22nd, 2006, 04:49 PM
posted to microsoft.public.publisher
|
|||
|
|||
|
Mail merge using Excel data
Save the Excel file as a .csv. See if that works.
-- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "ladyt" wrote in message ... Using P2003 and mail merge In Pub, whenever my "zipcode" field (that I am getting from an Excel file) has zip +4 digits, "0" shows up in the Pub merge results. In the Excel file, I have tried having the column attributes set as Custom, Text, and others to see if that was causing the problem, but still the same results. How can I get the zip + 4 to display correctly in the Pub merge? Thanks much for your help.
|
|
#4
May 24th, 2006, 03:46 PM
posted to microsoft.public.publisher
|
|||
|
|||
|
Mail merge using Excel data
Thank you for your replies. However, I tried both methods, and neither
one worked. I was running out of time, so I manually put in the addresses. ladyt wrote: Using P2003 and mail merge In Pub, whenever my "zipcode" field (that I am getting from an Excel file) has zip +4 digits, "0" shows up in the Pub merge results. In the Excel file, I have tried having the column attributes set as Custom, Text, and others to see if that was causing the problem, but still the same results. How can I get the zip + 4 to display correctly in the Pub merge? Thanks much for your help.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I save an access document in word document? | cmartin | General Discussion | 2 | September 13th, 2005 11:26 PM |
| Link excel and word in mail merge without losing your data source? | angie | General Discussion | 5 | July 1st, 2005 06:29 PM |
| Mail merge - won't open Excel data source | Ed Williamson | Mailmerge | 1 | November 16th, 2004 05:59 PM |
| Mail Merge using Excel as data base | Tamara Norris | Mailmerge | 2 | May 22nd, 2004 07:58 AM |
| Word mail merge with Excel data | Peter Jamieson | Mailmerge | 1 | April 26th, 2004 07:30 PM |
Linear Mode
