Format Cell using letter & number to use in mail merge

  • Thread starter Thread starter audrey87
  • Start date Start date
A

audrey87

trying to mail merge using database with letter & number in cell. The merge
comes out with a 0 instead of T321
 
Hi audrey,

If the column these fields are in has a numbers (with or without other alphanumeric strings) in the first 8 rows, the mailmerge
process is liable to interpret the column as being numeric and any alphanumeric strings will be evalutated as 0.

What version of Word are you using for the mailmerge, and what data connection method?
 
Hi audrey,

If the column these fields are in has a numbers (with or without other alphanumeric strings) in the first 8 rows, the mailmerge
process is liable to interpret the column as being numeric and any alphanumeric strings will be evalutated as 0.

What version of Word are you using for the mailmerge, and what data connection method?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

HELP!!!!!!!!! 2
Display date in spanish 3
Using formula-generated figures in excel in mail-merging 1
time format from hh:mm:ss to h:mm 2
Convert number to text as displayed 3
Counting Merged Cells 5
How to count merged cells 1
Mail Merge issue 5

Back
Top