Paste Clipboard

[Allen Browne]

No. You will have to OpenRecordset, and loop through the records.

 

[Kathy Webster]

OpenRecordset, and loop through the records.

Hmm, I know you've spent a lot of time already, but care to walk me through
trying this as a solution instead?

 

[Allen Browne]

Here's an example of how to OpenRecordset() and loop through the records:
http://allenbrowne.com/func-DAO.html#DAORecordsetExample

 

[Kathy Webster]

OpenRecordset, and loop through the records.

Hmm, I know you've spent a lot of time already, but care to walk me
through trying this as a solution instead?

Is that a resounding "no"?

 

[Allen Browne]

Perhaps you did not see my last reply, Kathy, to enable you to learn how to
walk recordsets for yourself. Here it is again:

Here's an example of how to OpenRecordset() and loop through the records:
http://allenbrowne.com/func-DAO.html#DAORecordsetExample

 

[Kathy Webster]

Thank you Allen, no I never saw your reply. Will this work for a query as
well as a table? Would I just replace MyTable with MyQuery?
Then, how would I insert the looped field contents into the TO line of the
email?

 

[Allen Browne]

Give it a try, Kathy, and see.

(Or you could just use the name of the query as strSql.)

 

[Kathy Webster]

OK. Did that. Added reference to Microsoft DAO 3.6 Object Library, Removed
reference to Microsoft ActiveX Data Objects 2.1 Library. It compiled.

Now when I run the code, I get:
Runtime error: 3061
Too few parameters. Expected 2.
....and this is in yellow:
Set rs = DBEngine(0)(0).OpenRecordset(strSql)

 

[Douglas J. Steele]

What's DA_EmailSL? If it's a query, does the query expect parameters?

 

[Kathy Webster]

Yes its a query and it does not expect parameters.

 

[Kathy Webster]

I found a problem...I wasn't referencing the right field name in my query. I
corrected that...now I get:

Runtime error: 3061
Too few parameters. Expected 1.

 

[Douglas J. Steele]

Double check that DA_EmailSL still opens on its own. Given how little code
there is, that's really the only possibility.

 

[Kathy Webster]

Yes, DA_EmailSL still opens on its own.

Double check that DA_EmailSL still opens on its own. Given how little code
there is, that's really the only possibility.

 

[Dory A. Lottner]

I have text in my clipboard from an MSAccess table. How can I paste it into
the TO line of my email? My users could be using one of many email
programs, so I am getting to their email program using MSAccess's
SendObject command. The cursor is now in the user's email TO line, with
the clipboard full of email addresses. How do I simply paste the text?

TIA,
Kathy

 

[John Nurick]

Why not just include the text as the To argument of SendObject?