Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / February 2006

Tip: Looking for answers? Try searching our database.

Mail Merge Not Reading Field Codes Properly

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sandi - 21 Feb 2006 15:10 GMT
HELP HELP HELP!!!

I have a mail merge document where I am trying to pull in my data source
from an excel spread sheet and I have 3 fields in my data source that are
percentages.  Each time I merge my document, it's not reading the
percentages, but take it out into a decimal like this for example:
0.65000000000002.  I've tried everything I know possible to correct the
problem, but it's not working at all.  Also when I go in to select my data
source and it comes up to confirm my data souce I usually select the MS Excel
Worksheets via DDE but it keeps telling me that it can't re-establish a DDE
connection to Microsoft Excel to complete my task.  This is normally how I
perform a mail merge with an Excel file.  Any help would be greatly
appreacited.
Thanks,

Sandi Gardner
Doug Robbins - Word MVP - 21 Feb 2006 18:29 GMT
See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at

http://www.gmayor.com/formatting_word_fields.htm

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> HELP HELP HELP!!!
>
[quoted text clipped - 14 lines]
>
> Sandi Gardner
Sandi - 21 Feb 2006 18:57 GMT
It keeps giving me a syntak error?  I'm not sure if I am entering in the
information correctly.  I've never tried this before...
Signature

Sandi Gardner

> See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
> website at
[quoted text clipped - 19 lines]
> >
> > Sandi Gardner
Doug Robbins - Word MVP - 21 Feb 2006 19:59 GMT
Exactly what have you done?

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> It keeps giving me a syntak error?  I'm not sure if I am entering in the
> information correctly.  I've never tried this before...
[quoted text clipped - 26 lines]
>> >
>> > Sandi Gardner
Sandi - 21 Feb 2006 20:17 GMT
Never mind - I got it to work properly.  Thanks so much!!!!! I wasn't using
the Ctrl+F9 combination.  

Thanks so much for your help.
Signature

Sandi Gardner

> Exactly what have you done?
>
[quoted text clipped - 28 lines]
> >> >
> >> > Sandi Gardner
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.