Notices


Reply
 
LinkBack Thread Tools Display Modes

Old 09-27-2007, 12:35 PM   #1 (permalink)
Junior Member

Join Date: Sep 2007
Location: Vancouver
Posts: 10
Rep Power: 0 ruby_mak is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- API/VBA

MS Word Mail Merge Field Error?

I don't know why it keeps happening but occasionally when I export donor acknowledgement letters from the Mail function in RE, when I merge it to a MS Word doc, the 'Field Calculation Error.." pops up and I can't merge the letters!.. The error will run through all the letters so if I had 78 letters, it would go Field Calculation Error 1, and then 2 and then 3, so on and so forth until #78 (which I usually force quit by error 2). If I re-mail merge the letter, it would do the same thing so I would have to close down and restart my computer. It usually happen on the second mail merge I do for the day which is odd.

I don't think it's something to do with the computer settings because this has happen to two different organisations I worked with.

Please let me know if this happen to anyone else and what the solution is to this annoying problem.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 09-28-2007, 09:51 AM   #2 (permalink)
Senior Member

Join Date: Sep 2006
Posts: 257
Rep Power: 3 jas. is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)

what version of word are you using, and what fields are you exporting? Is this a complicated conditional merge, or something simple?

I'm curious because there was a similar problem I was having in word 2000, with a conditional merge that pulled in text from several other documents, and googling turned up that it was a glitch that was solved in XP and 2003.
__________________
james andrews
manager of development services
philadelphia museum of art
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 09-28-2007, 10:38 AM   #3 (permalink)
Junior Member

Join Date: Sep 2007
Location: Vancouver
Posts: 10
Rep Power: 0 ruby_mak is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)
- API/VBA

I'm using MS Word 2003 (on Windows XP) with the conditional merge (I am pulling the text of the letters from different documents into one mail merge file).

The fields I'm exporting are
«Addressee»
«Position»
«Organization_Name»
«Address_line_1»
«Address_line_2»
«Address_line_3»
«City»
«Province»
«Postal_Code»
«Salutation»
«Gift_Amount»
«Fund_description1»
«Program_1»
«Gift_Reference»

I wonder if it is because the different acknowledgement letters have different required merge fields (i.e. our Alumni letter only needs the Addressee/Salutation, Address and Gift amount but our other letters require more merged fields).

Do you know if it is a RE problem or a MS Word problem?
__________________
Ruby Mak
Burnaby, BC
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote

Old 09-28-2007, 10:53 AM   #4 (permalink)
my feet hurt.

Melissa Siobhan's Avatar

Join Date: May 2006
Location: Connecticut
Posts: 1,455
Rep Power: 4 Melissa Siobhan is on a distinguished road

Blackbaud Products
- Raiser's Edge (RE)

I think it might be a Word problem. Are any of your merge fields used in a calculation in the letter? What might be differentabout the second mail merge you do every day? Does restarting your computer fix the problem every time?
__________________
Melissa S. Graves

Director of Development Services
The Village for Families and Children
www.villageforchildren.org



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!Spurl this Post!Reddit! Wong this Post!
Reply With Quote
Reply

Tags
error, field, mail, merge, microsoft, word


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


Loan - Cheap Gas - Mortgage - Credit Card Consolidation
All times are GMT -6. The time now is 01:50 AM.

Miscellaneous


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Integrated by BBpixel Team 2008 :: jvbPlugin R1012.364.1

SEO by vBSEO 3.2.0 Copyright 2008 Blackbaud User SocietyAd Management by RedTyger
Inactive Reminders By Icora Web Design

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64