Within an Access database in VBA I have the following statement:
DoCmd.SendObject acSendForm, , acFormatXLS, _
"Doe, John", "Doe, Jane. ; Doe, Jack ; Doe, Jill.; Doe, James", , _
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/13980-commas-in-a-string-of-text.html
"Molding - Zero Quantities", "There are currently zero spares on
hand for the following items:", True
The problem I am having is that once this bit of code is ran and the e-mail
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=13980
pops-up with the "Doe" names in their appropriate fields, instead of putting
commas between Doe, John it puts Doe; John. How do I get these semi-colons
to apepar as commas. Thanks in advance.