Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Mail Merge w/ Excel Data
I am trying to make labels with data from an excel file. After I do the
merge, the label is not exactly like the data from excel. For example, on Excel I have fields with a dollar sign and no decimal places, after the merge, those fields on word have no dollar sign and 6 decimal places. How do I format my word labels to look exactly like the data in Excel? |
#2
|
|||
|
|||
This is due to the new data format in OLE. This allows you to access data
from any Excel workbook, but doesn't keep the formatting for numbers. My workaround: 1) Make sure that your data is on the first page of your workbook 2) In Word, go to Tools, Options, and click on the tab "Confirm conversion on open" 3) Continue with your merge. When you reference your Excel file, you'll see a box asking you which type of conversion to use. I can't tell you all the options, but the one you want is DDE - I remember it because it's the DEAD version of the format. Your merge should work now. "PFLY" wrote: I am trying to make labels with data from an excel file. After I do the merge, the label is not exactly like the data from excel. For example, on Excel I have fields with a dollar sign and no decimal places, after the merge, those fields on word have no dollar sign and 6 decimal places. How do I format my word labels to look exactly like the data in Excel? |
#3
|
|||
|
|||
See http://www.gmayor.com/formatting_word_fields.htm
and the Excel data section of http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org PFLY wrote: I am trying to make labels with data from an excel file. After I do the merge, the label is not exactly like the data from excel. For example, on Excel I have fields with a dollar sign and no decimal places, after the merge, those fields on word have no dollar sign and 6 decimal places. How do I format my word labels to look exactly like the data in Excel? |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Specific Email Merge w/ Specific Attachements | Mailmerge | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge | |||
Mail merge error occurs when filtering Excel data source | Mailmerge | |||
how do i create a mail merge for email using excel as a data sourc | Mailmerge | |||
Mail Merge with no header row in the Excel Data | Mailmerge |