Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
nats lee carter nats lee carter is offline
external usenet poster
 
Posts: 13
Default Mail merge to seperate documents error

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.

  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
nats lee carter nats lee carter is offline
external usenet poster
 
Posts: 13
Default Mail merge to seperate documents error



"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.

  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
nats lee carter nats lee carter is offline
external usenet poster
 
Posts: 13
Default Mail merge to seperate documents error

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.

  #4   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Mail merge to seperate documents error

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.



  #5   Report Post  
Posted to microsoft.public.word.mailmerge.fields
nats lee carter nats lee carter is offline
external usenet poster
 
Posts: 13
Default Mail merge to seperate documents error

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.



.

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Merge to seperate documents Matty_b Mailmerge 13 July 3rd 12 01:24 PM
Saving mail merged letters as seperate documents Nayme Microsoft Word Help 2 March 13th 07 04:15 PM
Merge to seperate Documents Doug Mailmerge 1 March 3rd 06 04:58 AM
Merge to print won't staple seperate documents? trunkles Mailmerge 1 February 10th 06 05:04 AM
Merge to seperate documents Mattyb_gb Mailmerge 0 April 27th 05 01:20 PM


All times are GMT +1. The time now is 06:14 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"