[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 257
  • Last Modified:

Excel 2010 wont display email correctly

Hi,

I have two uesers who receive an email from an external user. On one of the laptops, the email shows correctly whilst on the other laptop, its shown has just text.

The email in question has a section of an excel spreadsheet pasted into the body of the email.

Why would it be that on one laptop, it displays correctly but on the other, its just text.

Ive checked to see where I can set the email client to view messages in HTML but Im not able to find it and whether that is the issue.

Thanks
D
0
daiwhyte
Asked:
daiwhyte
  • 2
  • 2
1 Solution
 
elevationkevinCommented:
I don't have a whole lot of experience with this but here is a try.


Mailmerge Number & Currency Formatting?
To control number & currency formatting in Word, add a numeric picture switch to the mergefield. To do this:
• select the field;
• press Shift-F9 to reveal the field coding. It should look something like {MERGEFIELD MyData};
• edit the field so that you get {MERGEFIELD MyData \# $,0.00} (or whatever other numeric format you prefer - see below);
• position the cursor anywhere in this field and press F9 to update it;
• run your mailmerge.
 
Note: The '\# $,0.00' in the field is referred to as a numeric picture switch. Other possibilities include:
. \# 0 for rounded whole numbers
. \# ,0 for rounded whole numbers with a thousands separator
. \# ,0.00 for numbers accurate to two decimal places, with a thousands separator
. \# $,0 for rounded whole dollars with a thousands separator
. \# "$,0.00;($,0.00);'-'" for currency, with brackets around negative numbers and a hyphen for 0 values
Note: The precision of the displayed value is controlled by the '0.00'. You can use anything from '0' to '0.000000000000000'.
 
If you use a final ';' in the formatting switch with nothing following, (eg \# "$,0.00;($,0.00);") zero values will be suppressed. Note that this suppresses 0s resulting from empty fields and from fields containing 0s.
 
Mailmerge Percentage Formatting
To control percentage formatting in Word, add a formula and numeric picture switch to the mergefield, as follows:
• select your mergefield, which will look something like «Percent»;
• press Ctrl-F9 to wrap another field around it, thus { «Percent» };
• edit the field so that you get {=«Percent»*100 \# 0.00%};
• position the cursor anywhere in this field and press F9 to update it;
• run your mailmerge.
Note: The precision of the displayed value is controlled by the '0.00'. You can use anything from '0' to '0.000000000000000'.
0
 
daiwhyteAuthor Commented:
Thank you for your post but I suspect they are for another question?
0
 
Rob HensonIT & Database AssistantCommented:
Currently working in Outlook 2003 but maybe the same in later versions.

Tools > Options. Preferences Tab > EMail Options button.

New Window > message handling section has tick box for "Read all standard mail in plain text".

Maybe that would correct.

Thanks
Rob H
0
 
daiwhyteAuthor Commented:
Thank you.
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now