R
Ruth Isaacs
Hello All
This problem has baffled me for too long now, and I hope someone out there
can explain to me what's going on!
I have a simple macro, with a single command line that has a SendObject
action, with parameters as follows:
Object type: query
Object name: qry new staff details
Output format: Microsoft excel (*.xls)
To: =DLookUp("[practices]!","[practices]","[practices]![prac
name]=[Forms]![frm x main]![prac name]")
Cc: (blank)
Bcc: (blank)
Subject: Staff details
Message text: Please find attached an Excel spreadsheet for you to enter
your Staff details.
Edit message: No
Template file: (blank)
The macro runs OK ... except that every time, TWO identical emails are
sent!!
They arrive simutaneously in the recipients Inbox, with exactly the same
date/time received.
How can this be?
There is definitely only one command line in the macro (I've checked this
many times!).
I have tried setting the Edit message parameter to Yes, but although I was
only offered the opportunity of editing the message once, it made no
difference - TWO emails arrived.
Is this a bug? I hope someone can save my sanity, because this is driving me
nuts.
Thanks in advance.
Les
This problem has baffled me for too long now, and I hope someone out there
can explain to me what's going on!
I have a simple macro, with a single command line that has a SendObject
action, with parameters as follows:
Object type: query
Object name: qry new staff details
Output format: Microsoft excel (*.xls)
To: =DLookUp("[practices]!","[practices]","[practices]![prac
name]=[Forms]![frm x main]![prac name]")
Cc: (blank)
Bcc: (blank)
Subject: Staff details
Message text: Please find attached an Excel spreadsheet for you to enter
your Staff details.
Edit message: No
Template file: (blank)
The macro runs OK ... except that every time, TWO identical emails are
sent!!
They arrive simutaneously in the recipients Inbox, with exactly the same
date/time received.
How can this be?
There is definitely only one command line in the macro (I've checked this
many times!).
I have tried setting the Edit message parameter to Yes, but although I was
only offered the opportunity of editing the message once, it made no
difference - TWO emails arrived.
Is this a bug? I hope someone can save my sanity, because this is driving me
nuts.
Thanks in advance.
Les