I am using a mail merge to create a multi page document that highlights a different company on each page. The information about each company is coming from an excel spreadsheet. Since it is not a typical word merge.. I am having some issues- all of which I did not have under Office 2007. I am now on Office 2010. Here are the areas that will not show up properly-



1) phone numbers. Not all of the phone numbers have extensions, so I can't simply format the number using this switch (000) 000'-'0000
2) I am pulling in the results of formulas- the are all words, but come from a variety of separate excel sheets. Sometimes the formulas are blanks and other times they are a character (a bullet, so be precise) that is concatenated with text.

Any ideas on how to format the merge fields so that they will look correct in my merge?

Thanks for your help!!!