[nats lee carter]

Hi

I am merging with an excel spreadsheet as a db.

when I run the macro I have 2 problems:

1. I get the following error straightaway:
Run-time erro '-21417467259 (80004005)':
Method 'Value' of object 'MailmergedataField' failed

and I cannot continue.....?

2. I need a switch to make the decimal places correct
ie: 150.00 is 150.000000000000 etc. I need it to 2 decimal places

Please can you give me advice in laymans terms as am not so experienced at
this and totally alone on this one!

thanks!
natasha.

[nats lee carter]

"nats lee carter" wrote:

Hi

I am using the macro from gmayor.com I am merging with an excel spreadsheet as a db.

when I run the macro I have 2 problems:

1. I get the following error straightaway:
Run-time erro '-21417467259 (80004005)':
Method 'Value' of object 'MailmergedataField' failed

and I cannot continue.....?

2. I need a switch to make the decimal places correct
ie: 150.00 is 150.000000000000 etc. I need it to 2 decimal places

Please can you give me advice in laymans terms as am not so experienced at
this and totally alone on this one!

thanks!
natasha.

[nats lee carter]

sorry, I am using gmayors macro too...

"nats lee carter" wrote:

Hi

I am merging with an excel spreadsheet as a db.

when I run the macro I have 2 problems:

1. I get the following error straightaway:
Run-time erro '-21417467259 (80004005)':
Method 'Value' of object 'MailmergedataField' failed

and I cannot continue.....?

2. I need a switch to make the decimal places correct
ie: 150.00 is 150.000000000000 etc. I need it to 2 decimal places

Please can you give me advice in laymans terms as am not so experienced at
this and totally alone on this one!

thanks!
natasha.

[Graham Mayor]

With regard to the first question I have answered your private e-mail.
As for the second part, you need a formatting switch on the merge field.
Toggle the display with ALT+F9 from fieldname to { Mergefield
Fieldname }
Add the switch before the closing bracket
{ Mergefield Fieldname \# ",0.00" }
Update the field

--

Graham Mayor - Word MVP

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



"nats lee carter" wrote in message
...
Hi

I am merging with an excel spreadsheet as a db.

when I run the macro I have 2 problems:

1. I get the following error straightaway:
Run-time erro '-21417467259 (80004005)':
Method 'Value' of object 'MailmergedataField' failed

and I cannot continue.....?

2. I need a switch to make the decimal places correct
ie: 150.00 is 150.000000000000 etc. I need it to 2 decimal places

Please can you give me advice in laymans terms as am not so experienced at
this and totally alone on this one!

thanks!
natasha.

[nats lee carter]

thank u am going to try this now.

"Graham Mayor" wrote:

With regard to the first question I have answered your private e-mail.
As for the second part, you need a formatting switch on the merge field.
Toggle the display with ALT+F9 from fieldname to { Mergefield
Fieldname }
Add the switch before the closing bracket
{ Mergefield Fieldname \# ",0.00" }
Update the field

--

Graham Mayor - Word MVP

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



"nats lee carter" wrote in message
...
Hi

I am merging with an excel spreadsheet as a db.

when I run the macro I have 2 problems:

1. I get the following error straightaway:
Run-time erro '-21417467259 (80004005)':
Method 'Value' of object 'MailmergedataField' failed

and I cannot continue.....?

2. I need a switch to make the decimal places correct
ie: 150.00 is 150.000000000000 etc. I need it to 2 decimal places

Please can you give me advice in laymans terms as am not so experienced at
this and totally alone on this one!

thanks!
natasha.



.