A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Mergefield Format - Numbers and Text



 
 
Thread Tools Display Modes
  #1  
Old August 23rd, 2008, 05:31 AM posted to microsoft.public.word.mailmerge.fields
VickiMc
external usenet poster
 
Posts: 24
Default Mergefield Format - Numbers and Text

In my (Excel) Database I have Field I need to merge which contains a four
digit Code, the majority of which are numbers eg 6781. These merge fine
without any requirement to place a switch, however one or two of the codes
are made-up of four letters and are displayed as a single zero. *MERGEFORMAT,
& *CHARFORMAT result in a blank field.
What do I have to stipulate to get the text to appear in the Mergefield?
PS I have formatted the column in Excel as TEXT.
  #2  
Old August 23rd, 2008, 06:29 AM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default Mergefield Format - Numbers and Text

If using a version of Word before 2007, from the Tools menu, select Options
and then go to the General tab and check the box for "Confirm conversions at
open ". If using Word 2007, click on the Office button and then on Word
Options and then on Advanced and go to the General section of the dialog and
check the box for "Confirm file format conversion on open"

After doing that, when you attach the data source to the mail merge main
document, select the DDE option for the method by which the attachment
should be made (In Word 2007, it is necessary to click on the "Show all
formats" button to see that option.

--
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

"VickiMc" wrote in message
...
In my (Excel) Database I have Field I need to merge which contains a four
digit Code, the majority of which are numbers eg 6781. These merge fine
without any requirement to place a switch, however one or two of the codes
are made-up of four letters and are displayed as a single zero.
*MERGEFORMAT,
& *CHARFORMAT result in a blank field.
What do I have to stipulate to get the text to appear in the Mergefield?
PS I have formatted the column in Excel as TEXT.



  #3  
Old August 23rd, 2008, 06:44 AM posted to microsoft.public.word.mailmerge.fields
VickiMc
external usenet poster
 
Posts: 24
Default Mergefield Format - Numbers and Text

Thanks for our prompt reply Doug.
I have tried this routine previously but (for whatever reason) I get a
MessageBox stating that Word cannot establish a DDE link - I left it there,
thought it was me, and promptly posted my question.
Any ideas how I am to proceed further?
I'm not that savvy when it comes to the nuts & bolts of computers, but in
case it matters, I should advise you this is a company computer to which I
have no administrative rights.

"Doug Robbins - Word MVP" wrote:

If using a version of Word before 2007, from the Tools menu, select Options
and then go to the General tab and check the box for "Confirm conversions at
open ". If using Word 2007, click on the Office button and then on Word
Options and then on Advanced and go to the General section of the dialog and
check the box for "Confirm file format conversion on open"

After doing that, when you attach the data source to the mail merge main
document, select the DDE option for the method by which the attachment
should be made (In Word 2007, it is necessary to click on the "Show all
formats" button to see that option.

--
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

"VickiMc" wrote in message
...
In my (Excel) Database I have Field I need to merge which contains a four
digit Code, the majority of which are numbers eg 6781. These merge fine
without any requirement to place a switch, however one or two of the codes
are made-up of four letters and are displayed as a single zero.
*MERGEFORMAT,
& *CHARFORMAT result in a blank field.
What do I have to stipulate to get the text to appear in the Mergefield?
PS I have formatted the column in Excel as TEXT.




  #4  
Old August 23rd, 2008, 09:08 AM posted to microsoft.public.word.mailmerge.fields
Peter Jamieson
external usenet poster
 
Posts: 4,550
Default Mergefield Format - Numbers and Text

If you haven't already looked at http://tips.pjmsn.me.uk/t0003.htm then I
suggest you do. Unfortunately it is very difficult to advise what your next
step should be. Probably the simplest workaround if you are performing the
merge yourself is to select the table in Excel, and copy/paste into a new
Word document, save that and use it as the data source.

--
Peter Jamieson
http://tips.pjmsn.me.uk

"VickiMc" wrote in message
...
Thanks for our prompt reply Doug.
I have tried this routine previously but (for whatever reason) I get a
MessageBox stating that Word cannot establish a DDE link - I left it
there,
thought it was me, and promptly posted my question.
Any ideas how I am to proceed further?
I'm not that savvy when it comes to the nuts & bolts of computers, but in
case it matters, I should advise you this is a company computer to which I
have no administrative rights.

"Doug Robbins - Word MVP" wrote:

If using a version of Word before 2007, from the Tools menu, select
Options
and then go to the General tab and check the box for "Confirm conversions
at
open ". If using Word 2007, click on the Office button and then on Word
Options and then on Advanced and go to the General section of the dialog
and
check the box for "Confirm file format conversion on open"

After doing that, when you attach the data source to the mail merge main
document, select the DDE option for the method by which the attachment
should be made (In Word 2007, it is necessary to click on the "Show all
formats" button to see that option.

--
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

"VickiMc" wrote in message
...
In my (Excel) Database I have Field I need to merge which contains a
four
digit Code, the majority of which are numbers eg 6781. These merge fine
without any requirement to place a switch, however one or two of the
codes
are made-up of four letters and are displayed as a single zero.
*MERGEFORMAT,
& *CHARFORMAT result in a blank field.
What do I have to stipulate to get the text to appear in the
Mergefield?
PS I have formatted the column in Excel as TEXT.





  #5  
Old August 23rd, 2008, 09:53 AM posted to microsoft.public.word.mailmerge.fields
VickiMc
external usenet poster
 
Posts: 24
Default Mergefield Format - Numbers and Text

Thanks Peter, I think I may have identified the problem at your point 2.
The mergelist I have is on the second Worksheet of the Workbook.
I'll swap the worksheets around and see if that rectifies the problem.
Standby. . . . .

"Peter Jamieson" wrote:

If you haven't already looked at http://tips.pjmsn.me.uk/t0003.htm then I
suggest you do. Unfortunately it is very difficult to advise what your next
step should be. Probably the simplest workaround if you are performing the
merge yourself is to select the table in Excel, and copy/paste into a new
Word document, save that and use it as the data source.

--
Peter Jamieson
http://tips.pjmsn.me.uk

"VickiMc" wrote in message
...
Thanks for our prompt reply Doug.
I have tried this routine previously but (for whatever reason) I get a
MessageBox stating that Word cannot establish a DDE link - I left it
there,
thought it was me, and promptly posted my question.
Any ideas how I am to proceed further?
I'm not that savvy when it comes to the nuts & bolts of computers, but in
case it matters, I should advise you this is a company computer to which I
have no administrative rights.

"Doug Robbins - Word MVP" wrote:

If using a version of Word before 2007, from the Tools menu, select
Options
and then go to the General tab and check the box for "Confirm conversions
at
open ". If using Word 2007, click on the Office button and then on Word
Options and then on Advanced and go to the General section of the dialog
and
check the box for "Confirm file format conversion on open"

After doing that, when you attach the data source to the mail merge main
document, select the DDE option for the method by which the attachment
should be made (In Word 2007, it is necessary to click on the "Show all
formats" button to see that option.

--
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

"VickiMc" wrote in message
...
In my (Excel) Database I have Field I need to merge which contains a
four
digit Code, the majority of which are numbers eg 6781. These merge fine
without any requirement to place a switch, however one or two of the
codes
are made-up of four letters and are displayed as a single zero.
*MERGEFORMAT,
& *CHARFORMAT result in a blank field.
What do I have to stipulate to get the text to appear in the
Mergefield?
PS I have formatted the column in Excel as TEXT.





  #6  
Old August 23rd, 2008, 10:00 AM posted to microsoft.public.word.mailmerge.fields
VickiMc
external usenet poster
 
Posts: 24
Default Mergefield Format - Numbers and Text

My gratitude to both you and Doug - I'm fixed.
Must have been a 'doh' moment when I set-up the database in the first place
- I do so know the basic principles of mailmerge.
Once Again, Thank You!

"VickiMc" wrote:

Thanks Peter, I think I may have identified the problem at your point 2.
The mergelist I have is on the second Worksheet of the Workbook.
I'll swap the worksheets around and see if that rectifies the problem.
Standby. . . . .

"Peter Jamieson" wrote:

If you haven't already looked at http://tips.pjmsn.me.uk/t0003.htm then I
suggest you do. Unfortunately it is very difficult to advise what your next
step should be. Probably the simplest workaround if you are performing the
merge yourself is to select the table in Excel, and copy/paste into a new
Word document, save that and use it as the data source.

--
Peter Jamieson
http://tips.pjmsn.me.uk

"VickiMc" wrote in message
...
Thanks for our prompt reply Doug.
I have tried this routine previously but (for whatever reason) I get a
MessageBox stating that Word cannot establish a DDE link - I left it
there,
thought it was me, and promptly posted my question.
Any ideas how I am to proceed further?
I'm not that savvy when it comes to the nuts & bolts of computers, but in
case it matters, I should advise you this is a company computer to which I
have no administrative rights.

"Doug Robbins - Word MVP" wrote:

If using a version of Word before 2007, from the Tools menu, select
Options
and then go to the General tab and check the box for "Confirm conversions
at
open ". If using Word 2007, click on the Office button and then on Word
Options and then on Advanced and go to the General section of the dialog
and
check the box for "Confirm file format conversion on open"

After doing that, when you attach the data source to the mail merge main
document, select the DDE option for the method by which the attachment
should be made (In Word 2007, it is necessary to click on the "Show all
formats" button to see that option.

--
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

"VickiMc" wrote in message
...
In my (Excel) Database I have Field I need to merge which contains a
four
digit Code, the majority of which are numbers eg 6781. These merge fine
without any requirement to place a switch, however one or two of the
codes
are made-up of four letters and are displayed as a single zero.
*MERGEFORMAT,
& *CHARFORMAT result in a blank field.
What do I have to stipulate to get the text to appear in the
Mergefield?
PS I have formatted the column in Excel as TEXT.





  #7  
Old May 28th, 2010, 07:54 PM posted to microsoft.public.word.mailmerge.fields
BotR
external usenet poster
 
Posts: 9
Default Mergefield Format - Numbers and Text

Thanks Doug.
This helped me fix the "0" issue I was having.

"Doug Robbins - Word MVP" wrote:

If using a version of Word before 2007, from the Tools menu, select Options
and then go to the General tab and check the box for "Confirm conversions at
open ". If using Word 2007, click on the Office button and then on Word
Options and then on Advanced and go to the General section of the dialog and
check the box for "Confirm file format conversion on open"

After doing that, when you attach the data source to the mail merge main
document, select the DDE option for the method by which the attachment
should be made (In Word 2007, it is necessary to click on the "Show all
formats" button to see that option.

--
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

"VickiMc" wrote in message
...
In my (Excel) Database I have Field I need to merge which contains a four
digit Code, the majority of which are numbers eg 6781. These merge fine
without any requirement to place a switch, however one or two of the codes
are made-up of four letters and are displayed as a single zero.
*MERGEFORMAT,
& *CHARFORMAT result in a blank field.
What do I have to stipulate to get the text to appear in the Mergefield?
PS I have formatted the column in Excel as TEXT.




  #8  
Old May 28th, 2010, 10:22 PM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default Mergefield Format - Numbers and Text

You're welcome.

--
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, originally posted via msnews.microsoft.com

"BotR" wrote in message
...
Thanks Doug.
This helped me fix the "0" issue I was having.

"Doug Robbins - Word MVP" wrote:

If using a version of Word before 2007, from the Tools menu, select
Options
and then go to the General tab and check the box for "Confirm conversions
at
open ". If using Word 2007, click on the Office button and then on Word
Options and then on Advanced and go to the General section of the dialog
and
check the box for "Confirm file format conversion on open"

After doing that, when you attach the data source to the mail merge main
document, select the DDE option for the method by which the attachment
should be made (In Word 2007, it is necessary to click on the "Show all
formats" button to see that option.

--
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

"VickiMc" wrote in message
...
In my (Excel) Database I have Field I need to merge which contains a
four
digit Code, the majority of which are numbers eg 6781. These merge fine
without any requirement to place a switch, however one or two of the
codes
are made-up of four letters and are displayed as a single zero.
*MERGEFORMAT,
& *CHARFORMAT result in a blank field.
What do I have to stipulate to get the text to appear in the
Mergefield?
PS I have formatted the column in Excel as TEXT.




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:10 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.