Powerful Outlook Add-ins

Service Support Forum for DS Development Add-ins and Utilities
It is currently Mon Dec 09, 2019 7:46 am

All times are UTC




Post new topic Reply to topic  [ 6 posts ] 
Author Message
PostPosted: Sun Oct 29, 2006 12:30 pm 
Offline

Joined: Wed Oct 25, 2006 4:46 am
Posts: 4
I have done an email to email merge,but have a problem with inserting values, the format is not working. The first I have is 2.08, however on the preview it shows 2.0800000000000001. How can I format it so that it reads correctly.

Example below:

I notice that your account payment is overdue and that you have £ 2.0800000000000001 outstanding following your last delivery.



Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Mon Oct 30, 2006 11:18 am 
Offline
Site Admin

Joined: Tue Oct 04, 2005 9:09 am
Posts: 182
Hi Karen,

Have you used as a contact source a CSV file exported from MS Excel?

Also what versions of Microsoft Outlook and Easy Mail Merge are you using?

_________________
Dan Pascal
DS Development
http://www.emailaddressmanager.com



Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Sun Nov 05, 2006 9:23 am 
Offline

Joined: Wed Oct 25, 2006 4:46 am
Posts: 4
I do produce my csv's from excel. I am using outlook 2003 version 11.8010.6568, and Easy email merge for outlook 1.1.70.0.



Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Sun Nov 05, 2006 2:01 pm 
Offline
Site Admin
User avatar

Joined: Thu Mar 25, 2004 1:52 pm
Posts: 669
Hi Karen,

If you right click on the CSV file and select to open with NotePad, how do you see the currency field? Does it say £ 2.0800000000000001 or £ 2.08 ?

If your original Excel file contained formulas or other calculations, when exporting to a CSV file from Excel, Excel exports the fully digits of the value field, although it only displays the first digits when viewing the table in Excel.

Try to save the Excel file as a new/separate Excel table, then get rid of the nested formulas, then export to CSV and see if it makes any difference.

Regards,
Bogdan



Top
 Profile  
Reply with quote  
 Post subject:
PostPosted: Mon Mar 19, 2007 11:15 am 
Offline

Joined: Tue Mar 13, 2007 12:43 pm
Posts: 1
I have the same problem as Karen. The values come out to two decimal places fine if I don't open the csv file in Excel prior to using Easy Mail Merge, but if I open it to amend details, it defaults back to the multi-decimal place values. If I open the amended file in Notepad, the values are fine (to two decimal places). I've tried resaving but to no avail - and I can't find any nested formulas in the Excel table, but I'm not very good with Excel!

I use Outlook 2003 11.6359.6360 and Easy Mail Merge for Outlook 1.1.74.0.



Top
 Profile  
Reply with quote  
PostPosted: Tue Jul 06, 2010 3:01 am 
Offline

Joined: Tue Jul 06, 2010 2:41 am
Posts: 1
If this is what's causing the apparent discrepancy and you want to avoid it
then you should add the rounded cost to the rounded freight charge by means
of the Round function.

_________________
[url=http://www.computerseo.com]www.computerseo.com[/url]



Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

All times are UTC


Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group