MailMerge field for decimals with letters, i.e. 1A.23

scribbled · #4 06-28-2024, 06:42 AM

Quote:

Originally Posted by Guessed

I did have a fiddle with the one entry and you might be able to try something along the lines of testing formatted vs unformatted eg
{If {MERGEFIELD ItemNumber \# ##.##} = {MERGEFIELD ItemNumber } {MERGEFIELD ItemNumber } {MERGEFIELD ItemNumber \# ##.##}}

So, this actually did work, thank you so much for taking the time. Unfortunately, while it does work when I'm manually opening Word and selecting the data source, for some reason it still doesn't work when Word is using a freshly generated data source from the application.

Oh well, I think it's time to move on.

Thanks again

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Ref field to Database field doesn't update properly in Mailmerge	huynguyen865	Mail Merge	1	08-30-2021 07:30 AM
Macro to insert an image to a word mailmerge document based on the value of a mailmerge field?	Jake93	Mail Merge	3	07-02-2019 05:38 PM
Mailmerge field format?	Rothera85	Mail Merge	9	05-11-2014 03:41 PM
Words & letters half burried in a Text field in a table.	Ed54	Word	4	01-05-2012 04:10 PM
mailmerge with letters of a different numbers of pages	roel1972	Mail Merge	0	02-21-2011 11:45 AM