Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format Cell using letter & number to use in mail merge
trying to mail merge using database with letter & number in cell. The merge
comes out with a 0 instead of T321 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Format Cell using letter & number to use in mail merge
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? -- Cheers macropod [Microsoft MVP - Word] "audrey87" wrote in message ... trying to mail merge using database with letter & number in cell. The merge comes out with a 0 instead of T321 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mail merge - creating cover letter with attachment | Excel Discussion (Misc queries) | |||
Send a letter via e-mail merge to several people? | Excel Discussion (Misc queries) | |||
Use Letter Template but not Mail Merge | Excel Discussion (Misc queries) | |||
doing mail merge with excel the first letter in zip code is missi | Excel Discussion (Misc queries) | |||
in mail merge can you add something in to the body of the letter | Excel Discussion (Misc queries) |