This site will have limited functionality while we undergo maintenance to improve your experience. If an article doesn't solve your issue and you want to ask a question, we have our support community waiting to help you at @FirefoxSupport on Twitter and/r/firefox on Reddit.

Avatar for Username

সহায়তা খুঁজুন

Avoid support scams. We will never ask you to call or text a phone number or share personal information. Please report suspicious activity using the “Report Abuse” option.

আরও জানুন

এই থ্রেডটি সংরক্ষিত ছিল। যদি আপনি সাহায্য চান তাহলে অনুগ্রহ করে একটি নতুন প্রশ্ন জিজ্ঞাসা করুন

mail merge number field not importing

  • 3 উত্তরসমূহ
  • 1 এই সমস্যাটি আছে
  • 3 দেখুন
  • শেষ জবাব দ্বারা office10

office10
office10
more options

I have a mail merge that has a number field meant to be a dollar amount. All the other (text) fields work fine, but after merging, the space the number should be is blank. I've tried redoing it several times, including adding a space between the dollar sign and left bracket. No matter what, the number just won't import to the email. Example of the text where the field is: " ...amount of $ {{Total Pledged}}. "

I have a mail merge that has a number field meant to be a dollar amount. All the other (text) fields work fine, but after merging, the space the number should be is blank. I've tried redoing it several times, including adding a space between the dollar sign and left bracket. No matter what, the number just won't import to the email. Example of the text where the field is: " ...amount of $ {{Total Pledged}}. "

সমাধান চয়ন করুন

somehow this got resolved. Unfortunately I changed 2 things instead of 1 at a time, so not sure which was the thing that resolved it. I went back to my spreadsheet and changed the format of number field from dollars to number, and I changed the field name so it would not have any spaces (total_pledged instead of total pledged). In any case, it's working now.

প্রেক্ষাপটে এই উত্তরটি পড়ুন। 👍 0

All Replies (3)

office10
office10 প্রশ্নের মালিক
more options

চয়ন করা সমাধান

somehow this got resolved. Unfortunately I changed 2 things instead of 1 at a time, so not sure which was the thing that resolved it. I went back to my spreadsheet and changed the format of number field from dollars to number, and I changed the field name so it would not have any spaces (total_pledged instead of total pledged). In any case, it's working now.

Matt
Matt
  • Moderator
  • Top 10 Contributor
more options

I would guess that the change to a field name without a space will be the change that got things working. With CSV files it is always a good idea to actually convert numbers into text values in the spreadsheet. There is nothing wrong with numbers, but if they are preformated and converted to text there are less odd issues later when you merge. Such as currency symbols not appearing or in particular dates becoming julian or just a large number.

office10
office10 প্রশ্নের মালিক
more options

Thanks - that makes sense. Of course these things only happen under deadline...