| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Not Reading Field Codes Properly
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 |
|
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mail Merge Not Reading Field Codes Properly
See "Formatting Word fields with switches" on fellow MVP Graham Mayor's
website at http://www.gmayor.com/formatting_word_fields.htm -- 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 "Sandi" wrote in message ... 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 |
|
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mail Merge Not Reading Field Codes Properly
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... -- Sandi Gardner "Doug Robbins - Word MVP" wrote: See "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at http://www.gmayor.com/formatting_word_fields.htm -- 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 "Sandi" wrote in message ... 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 |
|
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mail Merge Not Reading Field Codes Properly
Exactly what have you done?
-- 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 "Sandi" wrote in message ... 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... -- Sandi Gardner "Doug Robbins - Word MVP" wrote: See "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at http://www.gmayor.com/formatting_word_fields.htm -- 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 "Sandi" wrote in message ... 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 |
|
#5
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
|
Mail Merge Not Reading Field Codes Properly
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. -- Sandi Gardner "Doug Robbins - Word MVP" wrote: Exactly what have you done? -- 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 "Sandi" wrote in message ... 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... -- Sandi Gardner "Doug Robbins - Word MVP" wrote: See "Formatting Word fields with switches" on fellow MVP Graham Mayor's website at http://www.gmayor.com/formatting_word_fields.htm -- 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 "Sandi" wrote in message ... 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 |
| Reply |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I mail merge to EMAIL from MS Word AND add a pdf attachment | Mailmerge | |||
| Possible to insert a file into Word based on a mail merge field? | Mailmerge | |||
| can you limit the length of a mail merge field? | Mailmerge | |||
| Mail merge drops zip codes and replaces with zero | Mailmerge | |||
| How do I get a field to self adjust in a mail merge? | Mailmerge | |||
Linear Mode
