Question Microsoft Outlook (1 Viewer)

[DeonO]

Hi all,
I am experiencing a problem with Outlook.
I have an application that mails a report as soon as the user clicks on save. The mailing happens without the user knowing it.

The issue is when Outlook opens, the e-mail addresses has been changed by Outlook. EXAMPLE:

In my code, I retrieve the e-mail addresses from a table. The e-mail addres is as follows:
dirk.vdwest@senco.co.za

when Outlook opens, the e-mail address has been altered to look like this:
dirk;vdwest@senco;co;za

The periods has been changed to semicolons.

I am using the "SendObject". The code looks like this:

DoCmd.SendObject acReport, "TripMasterForEmail", "PDFFormat(*.pdf)", C1, D1, "", "Trip Masters", "Please find attached Trip Master(s).", True, ""

The variables C1 and D1 holds the e-mail addresses.

Any suggestions?

Much appreciated
Deon

 

[Minty]

Can you debug.print c1 and d1 in you code to see what it is actually passing to the command

 

[DeonO]

The variables C1 and D1 contains the following values when debug.print:


C1 = dirk.vdwest@senco.co.za
D1 = cassie@cargon.co.za

When Outlook opens the message to be send, the mail addresses are placed in the "To:" and "CC" fields, but it looks as follows:

To: dirk;vdwest@senco;co;za
Cc: cassie@cargon;co;za

 

[DeonO]

Hi,
Just for information, I have changed my regional settings. The List Seperator = period and the Decimal separator = period.

Maybe this has an influence?

 

[spikepl]

List Separator = period ?????????????? I bet Outlook doesn't like that. What did you have before? The usual one is comma "," but in countries with "," as decimal separator it might be ";"

 

[DeonO]

Yep, You are 100% correct. Outlook does not like the period as a list separator. After changing it to a comma, the problem disappeared.

Thanks for the assistance. Greatly appreciated.