Commas in a string of text

M

Mr. Smiley

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", , _
"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
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.
 

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

Commas in a string of text in VBA 2
Email issue 0
Line up Text in Report 0
Turning document text into a label for my userform 4
Copy the contents of a cell in excel to another cell 2
Count how many instances of an item appear in a range 2
Help with converting data in Excel 6
Passing a string to a function instead of a cell reference 2

Top