Email Writing

[drunkenneo]

I want to write a email where there are 2 or 3 different ordernumbers for same email, i want to include the email in the mail part as single column table. how to do it?



also can i use result of one recordset for other recordset?

[rpeare]

what is your current code for sending the email?

Typically with this sort of thing what you'd have to do is cycle through records in a recordset and build the body of your email by appending the data (in your case order numbers) line by line but there are other ways to do it, for instance exporting a document/excel spreadsheet and attaching the spreadsheet rather than listing them in an email. It really depends on your current process or how you want it to work.

I'm assuming you want to do this with VBA because I don't think you can do it easily with a macro.

[drunkenneo]

what is your current code for sending the email?

Typically with this sort of thing what you'd have to do is cycle through records in a recordset and build the body of your email by appending the data (in your case order numbers) line by line but there are other ways to do it, for instance exporting a document/excel spreadsheet and attaching the spreadsheet rather than listing them in an email. It really depends on your current process or how you want it to work.

I'm assuming you want to do this with VBA because I don't think you can do it easily with a macro.

you got my point, i do not want an attachment for it, rather i would like to list in email.

[rpeare]

So you have no code at all right now?

look at the sendobject command for sending an email.

http://www.fmsinc.com/microsoftacces...endobject.html

look at this to cycle through a recordset:

http://allenbrowne.com/ser-29.html

look at section 5, all you'd be doing in it's place is extracting your order number adding a carriage return linefeed (vbcrlf) and moving to the next record.