Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Data frm excel to word using mail merge
Hi,
I am using mail merge to create report. I encounter problem when working with and printing mail merge. I need solution for: 1) number from excel e.g 20, turn 20.0 in word. 2) percentage frm excel e.g 67%, turn 67.33456 in word. 3) date from excel 30 March 2006, turn 30/3/2006 12:00pm pls let me. Tq param |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Data frm excel to word using mail merge
Look up Word Help for field switches, e.g. so instead of
{ MERGEFIELD mydate } you use { MERGEFIELD mydate \@"DD MMMM YYYY" } Alternatively, revert to the old method (DDE) of link to Excel - check Word Tools|Options|General|"Confirm conversions at open", go through the process of connecting to your sheet again, and choose the DDE option when prompted. This method is "deprecated", requires Excel on your system, and only works with the sheet that excel opens by default - typically the first sheet in the workbook. Peter Jamieson "Param" wrote in message ... Hi, I am using mail merge to create report. I encounter problem when working with and printing mail merge. I need solution for: 1) number from excel e.g 20, turn 20.0 in word. 2) percentage frm excel e.g 67%, turn 67.33456 in word. 3) date from excel 30 March 2006, turn 30/3/2006 12:00pm pls let me. Tq param |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How Come? | Mailmerge | |||
Word mail merge with excel data ..how to save the link? | Mailmerge | |||
Mail Merge from data in excel to word document. | Mailmerge | |||
In mail merge (word & excel) how do i get the data to read top to. | Mailmerge | |||
Mail merge error occurs when filtering Excel data source | Mailmerge |