[[email protected]]

Thanks Macropod,
I've read that solution on another post and tried it. I had problems
connecting with DDE.
The solution I found was to change the regional settings. Now I have to
get used to the date format mm/dd/yyyy for all the other applications.
In other PC's I can't make it work without changing the regional
config.
Thanks
Gastón


macropod ha escrito:

Hi Gaston,

The problem here seems to be that the mailmerge data are being transferred
in Excel's native format, rather than with the formatting that you applied
there. You can preserve the source data's formatting by using Dynamic Data
Exchange (DDE).

To choose the DDE data transfer method when you're connecting to an Excel
worksheet during a mail merge, all you have to do is select one check box in
Word:
1. On the Word Tools menu, click Options, and then click the General tab.
2. Click Confirm conversion at Open.

At the step in the mail-merge process where you connect to your data file,
after you locate the file you want to connect to, the Confirm Data Source
dialog box opens. Click "Application via DDE (*.???)", and then click OK. In
the Application dialog box, select the table/range that contains the
information you want to merge, and then click OK. The data will now be
formatted the same in your merged documents as they look in the source file.

Alternatively, you can code mailmerge fields with the appropriate formulae
and numeric/picture switches.

For 'Total_Fijo_Mensual ', all you'd need to do is add a picture switch to
the field, thus:
{MERGEFIELD Total_Fijo_Mensual \# ,0}
This will round off each amount to the nearest whole number. You may want to
do this anyway if your Excel data are formatted to show the decimal values,
but you don't want to show them in your mailmerge or alter your source file.

For 'Fecha_Ult_Increm', the numers you're seeing are the serial values Excel
uses for dates. To fix this you could download my Date Calc 'tutorial', at:
http://www.wopr.com/cgi-bin/w3t/show...?Number=249902
and adapt the field coding under the heading 'Importing Date and Time Values
From Excel and Access' to suit, by changing the 'ImportValue' string to
'MERGEFIELD Fecha_Ult_Increm' and modifying the date & time switch.

Personally, I'd recommend using the DDE connection.

Cheers

--
macropod
[MVP - Microsoft Word]


wrote in message
oups.com...
Without the switches I get,

{MERGEFIELD Total_Fijo_Mensual} 4389.44 ( I want no decimal places)

{MERGEFIELD Fecha_Ult_Increm} 38078

Thanks


What do
{MERGEFIELD Total_Fijo_Mensual}
and.....
{MERGEFIELD Fecha_Ult_Increm}
produce without the switches?

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



wrote:
It's still not working. I've read your page, very good source.
neither of them are working Don't know what to do, I've updated the
values with F9 save it and opened it again.
I've tried this... ({MERGEFIELD "Total_Fijo_Mensual"\# "##.000}
and..... {MERGEFIELD Fecha_Ult_Increm \@ "dd/MM/yy"}
Don`t know what to do..
Thanks fotr your help




Graham Mayor ha escrito:

Try {MERGEFIELD Total_Fijo_Mensual \# "##.000"} (was that supposed
to be three decimal places?)
and {MERGEFIELD Fecha_Ult_Increm \@ "dd/MM/yy"}
and make sure the quotes are plain quotes and not smart quotes.
Having made the changes, update the fields
See also http://www.gmayor.com/formatting_word_fields.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



wrote:
Sorry Macropod...

{MERGEFIELD "Total_Fijo_Mensual"\###.###}
{MERGEFIELD "Fecha_Ult_Increm"\@dd/mm/yy}

None is working.
Thanks for your help.
Gastsn




macropod ha escrito:

Hello Gaston,

Insufficient information! Please post samples of the mergefields
using these switches.

Cheers

--
macropod
[MVP - Microsoft Word]


wrote in message
ups.com...
Dear all,
I have a problem, a big one.
I`m trying to format mergefields and \# is not working, I`ve tried
everything... also \@ is not working.
I have Office 2003 SP1 in Spanish.
Thanks in advance