Most of the replies in this forum are probably only tested on Windows
versions of Word.
Mac versions of Word differ from Word versions in several respects (even
though they share the file formats .doc, .rtf, and .docx). Recent
versions of Mac Word and Mac Office have been "diverging" - i.e. they
have some features that Windows Word does not have, and lack some
features that Windows Word has. For example...
a. Mostly "ordinary" fields work the same way, but some do not, and
Mac has some "extras".
b. Mac Word does not have the Mailmerge events, so VBA Events examples
will not work
c. Mac Word 2008 does not have VBA, so anything that relies on VBA
will not work, e.g. "Online Forms" that use the forms fields /and/
require VBA, MACROBUTTONs that require VBA (I am not even sure that
regular MACROBUTTONs work)
d. recent Mac Word only has one connection method when connecting to
Excel data. It uses a converter - the interface looks rather like the
DDE one that is often mentioned here, but allows access to all the
sheets in th workbook. Mac Word does not use DDE or OLE DB. Mac Word
2004 and 2008 cannot use ODBC (although Excel can use it)
e. Mac Word does not have the \b or \f switches in MERGEFIELD fields.
(Even Windows Word has them from Word XP/2002 onwards).
I guess that means that you either have to use an { IF } field
construction to do this, or you have to add the Wingding in your data
source in such a way that it "gets through" to Word.
For the { IF } field you would need something like
{ IF { MERGEFIELD myfield } = "" "" "wingding{ MERGEFIELD myfield }" }
where you insert a wingding character where I have written wingding
Unfortunately, although Word 2008 will display Wingding characters
inserted into an Excel cell manually, if you insert them using a
worksheet formula such as
="thewingding" & B2
then in Word you see a _ character instead of thewingding
There might be some other way around this in Excel, but if you want to
use Excel formulas to create columns that have the thewingding
character in them, at the moment the only way I can see is to copy/paste
the Excel data into Word and use that as the data source.
Peter Jamieson
http://tips.pjmsn.me.uk
Yookaroo wrote:
I need to add a wingding (the circle with the shadow) before each field, but
that wont show up if the field isnt there.
I read it was something like this
{ MERGEFIELD product_41 \b text I want to insert }
I am on a mac and I have cut and pasted several answers from this forum, but
nothing seems to work, I have tried adding the circle into excel as well with
no luck. I am hoping this is possible