PLEASE HELP: Send email from Access with data in email body

Hi All,

How can I send email from access with data displayed in the email body? I 
have a button "Email users" in access custom form that sends email to all the 
users, But I dont know how to send them their particular schedule only.

For eg: Here is what My Table looks like:

Users    Day    Time
User1    M     13:00
User2    M     14:00
User3    T      15:00
User1    T      16:00
User3    W     17:00
User4    W     18:00
User4    Th    13:00

So basically, When I click "Email Users" Button, I want all the users to 
receive their respective schedules only.

How can I do thi?

Thanks in advance
0
Utf
4/26/2010 5:58:01 PM
access.formscoding 7493 articles. 0 followers. Follow

1 Replies
1162 Views

Similar Articles

[PageSpeed] 43

sam wrote:
>Hi All,
>
>How can I send email from access with data displayed in the email body? I 
>have a button "Email users" in access custom form that sends email to all the 
>users, But I dont know how to send them their particular schedule only.
>
>For eg: Here is what My Table looks like:
>
>Users    Day    Time
>User1    M     13:00
>User2    M     14:00
>User3    T      15:00
>User1    T      16:00
>User3    W     17:00
>User4    W     18:00
>User4    Th    13:00
>
>So basically, When I click "Email Users" Button, I want all the users to 
>receive their respective schedules only.
>
>How can I do thi?
>
>Thanks in advance

Something like this will work:
http://www.granite.ab.ca/access/email/recordsetloop.htm

But I think you would have to create a function that converted the recordset
to a table.  (pretty standard if you're using ADO and HTML.  Basically use
GetString and fix the delimiters and you're good to go)

-- 
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/201005/1

0
PieterLinden
5/7/2010 4:03:01 AM
Reply:

Similar Artilces:

CToolBar Help
Hello, I've been trying to add a toolbar to my dialog following the example from MSDN a http://msdn.microsoft.com/library/default.asp?url=/library/en-us/vcmfc98/html/_mfc_ctoolbar.asp But for some reason I just can't add the toolbar I created. Here is my code: CToolBar m_toolbar; if (!m_toolbar.Create(this, WS_CHILD | WS_VISIBLE | CBRS_TOP | CBRS_GRIPPER | CBRS_TOOLTIPS | CBRS_FLYBY | CBRS_SIZE_DYNAMIC, IDR_TOOLBAR1)) { MessageBox("Error -1"); } m_toolbar.LoadToolBar(IDR_TOOLBAR1); Could somebody please tell what, if anything, I am doing wrong? Thank you, V...

How do I host email for two separate organizations on 1 box?
Hi everyone, I am currently hosting my company's email on Exch 2000 and I want to host another company's email on the same box. How do I do this?? I have tried changing the recipient policy but to no avail. When I want to generate a new user in AD, all I get is an option to create a user for already hosted organzation. I've already set up a separate public folder tree, Information Store, etc. I'm obviously doing something wrong. Can anyone help me?? It would be very much appreciated Riyat The simplest way I know is to add these accounts to your current ADS and Exchange serv...

Office 2007 Professional: Help Files Issues
Gents, I cannot find a solution to this odd issue and before I submit a support ticket I thought I would ask the community. We have office 2007 professional (volume licensing) on a Window 2003 terminal server. We have a few users out of a bunch that get the "This page is unavailable" I have tried the Refresh and back. I've tried online and offline modes. In offline I get the table of contents to the left but same unavailable message when I click the links. I noticed on testing some other users, that apparently never used the help. That there are some prompts...

Cannot send or receive emails 06-17-10
When I try to send or receive emails I get a security box appear asking me for my user name and password. When I have typed in the information, the box disappears only to reappear a few seconds later. An error message then appears - Account: 'mail.talktalk.net', Server: 'mail.talktalk.net', Protocol:Pop3,Server Response:'-Err Authentication failed', Port:110, Secure (SSL): No,Server Error 0x800CCC90, Error Number: 0x800CCC92. I have checked all the usual settings and everything appears okay. Under Tools - Servers, I have made sure that "log on using sec...

Outlook 2003 Messages and Calendar Appts Received as PLAIN TEXT
SGVsbG86DQoNCkkganVzdCBnb3QgYSBuZXcgbGFwdG9wIHdpdGggVmlzdGEgSG9tZSBCYXNpYyBv biBpdCBhbmQgSSBjb3BpZWQgbXkNCnBzdCBmaWxlIGZyb20gbXkgb2xkIGxhcHRvcCB0byB0aGUg bmV3IG9uZS4gRXZlcnl0aGluZyB3b3JrcyBmaW5lDQpleGNlcHQgYWxsIGUtbWFpbCBtZXNzYWdl cyBhbmQgY2FsZW5kYXIgYXBwdHMuIEkgcmVjZWl2ZWQgYXJlIGluIHBsYWluDQp0ZXh0LiBJJ3Zl IHNlYXJjaGVkIGV2ZXJ5d2hlcmUgZm9yIHRoaXMgZml4LCBidXQgZm91bmQgbm90aGluZy4gDQoN CkRvZXMgYW55b25lIGhhdmUgYW55IHN1Z2dlc3Rpb25zIGZvciBtZT8gDQoNClRoYW5rIHlvdSEN ClNwdWRkeQ0K me@cox.net <me@cox.net> wrote: > I just got a new laptop with Vista Home Basic on it and I copied my > pst file...

Send Hierarchy
Is it my imagination or is something wrong with my setup? I am using Exchange 2003 SP2 and found this article ... http://support.microsoft.com/?id=823817 But I cannot find the "Send Hierarchy" or "Send Contents" options .... Have I done something wrong or has it been removed? Anyone know??? Thanks, jON On Mon, 17 Apr 2006 13:41:12 +0100, "Jon Rowlan" <jon.rowlan@sads.com> wrote: >Is it my imagination or is something wrong with my setup? > >I am using Exchange 2003 SP2 and found this article ... > >http://support.microsoft.com/?id=82...

What options do I have for electronically sending a purchase orde.
I have the Microsoft Retail Management System install in my store. My vendor wants me to send him my purchase order in an electronic format instead of faxing it to them. What options do I have? Newwest tech has an add-on for just that. "Russell" <Russell@discussions.microsoft.com> wrote in message news:90EB96FD-4FE6-4B18-AF5A-41A516D24B6B@microsoft.com... >I have the Microsoft Retail Management System install in my store. My >vendor > wants me to send him my purchase order in an electronic format instead of > faxing it to them. What options do I have? R...

Spell Check Help
I have this code in the AfterUpdate in a TextBox set for a memo: If Len(Me!casefacts & "") > 0 Then DoCmd.RunCommand acCmdSpelling Else Exit Sub End If everytime the spell check executs, it check the whole form. How can I get it to just check that one textbox and not everything else. bladelock wrote: >I have this code in the AfterUpdate in a TextBox set for a memo: > >If Len(Me!casefacts & "") > 0 Then > DoCmd.RunCommand acCmdSpelling > Else > Exit Sub >End If &...

Help with Regexp, please
Hi, The regular expression (\d{15,16}) matches a substring in a cell. I want to extract the remaining part of the cell ie. from the character after the matched substring till the end of the string in the cell using a regular expression. Is it possible to do this? Thanks in advance for the help. Regards, Raj Raj, with abcd15,16xyz in a cell the code below abstracts abcxyz. Maybe you can use this as a basis to develop your code Function GetSubstring(S As String) As String Dim re As Object Set re = CreateObject("vbscript.regexp") re.Pattern = &quo...

Publisher 2007 Trial Help
I installed the trial version of Publisher 2007 and want to uninstall it now. I have tried to remove in the "add/remove" programs section. And I have also tried a suggestion I found in an earlier post about going to the "installer" and trying to uninstall it there. Oh and I tried repairing it and then trying to uninstall it. I can't even open the program from my programs menu and I can't get into the language section to check the language. It tells me that the language isn't compatible with my version or something to that effect. Nothing has worked...

Default Value on Form Help
I have a query that calculates the total of a field in my table - Field Name in my Table is Total Value which calculates the total for a series of records that has the same invoice number. Field in in my query is Aggregate Value. I now have a form where I bring in the Aggregate Value. I need to create another Text box Value Verified where I bring in the Aggregate Value as a default, but I may have to change it if the Value has changed - but the Aggregate Value has to remain the same. I tried using default value on the form for the Value Verified Text control that brings in ...

can't view pictures in email
The "don't download pictures automatically in HTML e-mails" box is unchecked in the Trusted zone and I still can't see them. this started happening out of the blue. I've reinstalled the office suite and also unstalled SP2. There is no need to disable this options and it is actually recommended to leave this option on. Outlook will display an Infobar if it blocked any images. If that Infobar is not being displayed, then you have a configuration issue on your machine. Which version of Windows and Internet Explorer are you using? I assume you are using Outlo...

Issues Accessing MS NewsGroups
microsoft.public.windows.powershell microsoft.public.windows.server.active_directory microsoft.public.windows.server.general There seem to be some problem with the above mentioned NewGroups, i cant access any information in them, either via IE or Outlook Explorer. Have these newgroups been decomissioned? begin 666 leaf.gif M1TE&.#EA$ `0`*('`( ``(" @,# P/\``/__`/___P```/___R'Y! $```<` M+ `````0`! ```-8>+ILQG"Y4EZSLQ!AE:&9L&W#<'P;-8K"T *&H+$K`92/ ML08\[QH`#RU *91P$A:1<AO )*-E@>,(-#92SK1S$@BDFBVD&B;,N...

PLEASE PLEASE HELP
I Have an emergency... I deleted a macro !!! I have 60 rows with checkboxes on cells A1 trough A60 that automatically as checked were inserting current dates on the cell next to it. for some reason a disaster happened and the macro was deleted or messed up. I tried searching for help in these groups, but none so far. I found one, but it is not a macro besides when I use that function all the other previous dates keep changing when other checkboxes are checked on in different days of the week. If you can please guide me to the right answer I will appreciated. Hope I made sense with my explana...

Cannot access a file -- HELP
I have this problem at work (using Excel 2000 Windows 2000) and at home (Excel 2003, Windows XP Pro). SOMETIMES...not always, I try to access a file on a network drive I get the message: "path..filename could not be found. Check the spelling of the file name and verify that the file location is correct". Once I get the message on that file, I always get it on the file....but there might be 27 others in the same folder that I can open. And I get the message if I try to open the file via explorer or via Excel. If I copy the file to my C: drive it opens fine. I even tried t...

Sum Function Help Please
I have created two Option Groups, setting up values against the radio buttons. The output from both boxes works fine (thanks to the Wizard), however when I'm creating a formula on the report, I'm unable to add the two returned values together. If I type in =([Q1]+[Q2]) then I get both numbers concatenated together (ie returned value from Q1 is 1 and returned value from Q2 is 2, the answer I get is 12 !!!!.) Interestingly if I enter =([Q1]-[Q2]) then I get the correct answer. Any help would be greatly appreciated here. I could be wrong, but it seems like access i...

2nd request for help -PLEASE PLEASE PLEASE
went through a windows update and was asked to reboot which I did. I had Outlook open and closed it before rebooting - it was opened to contacts. when I tried to access Outlook I got an error message saying "your personal address book could not be opened. the file is either not accessible or not a personal address book. choose retry to access your personal address book, or choose cancel to not open your personal address book with this application." I have no other application to open this address book with! my contact info is detrumental to me as well as my Calendar ...

In Word How do I switch off auto date insertion please
How can I disable? ...

Problem accessing multiple shared calendars
When a new user profile is first created on the computer for the user they can access as many shared Calendars as they have access too. The user exits outlook and starts it up again, they can only access one calendar in addition to their own. They open one calendar, then when the try to access another they get the message "The Calendar Folder Can not be found". If the user exits and restarts outlook once again, they can access their calendar, and they can then access the calendar they just got the error message on previous, but they can not access any others. Basically the...

Access is blocked from sending emails via Outlook 2000
I have a few macros in Access that send out emails with data to a list. Since we moved to Outlook 2000, that functionality is no longer available. Outlook spits out a message asking user permission to proceed with this. Is there some way to turn off this warning on a user level? That is, I don't want my entire organization to be able to do this, just a couple of people. TIA, Poorna. You'll need to either change how you do it from access or use Click yes. For more information on the security features, see http://www.slipstick.com/outlook/esecup.htm -- Diane Poremsky [MVP - O...

Remove template help task pane from startup
I created an invoice using one of Microsoft's templates. The help template appeared when I was designing the invoice. Now that the invoice is finished, I would like for the help template to NOT appear. I went to Tools-Options and unchecked "startup task pane" and also went to Tools-Customize and unchecked "Task Pane". This made the task pane go away, but only until I opened it again. Is there any way to make it not show up every time I open the document? ...

Is this the right news group for Outlook Web Access questions?
I am trying to find a way to add search folders in Web Access for 'For Follow up' and for 'unread' as I have int he real client. Cheers. Robin No, an Exchange group would be better suited as OWA is a part of Exchange, not Outlook. --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. All unsolicited mail sent to my personal account will be deleted without reading. After furious head scratching, Robin Jackson asked: | I am trying to find a way to add search folders in Web Access for 'For | Follow up' and for 'unread&...

Can't SEND SSL email out!! Please Help... it HURTZ!
OKay... being a bit silly about he hurting part. I have a strange email issue with some of my computers at home that I use for work. We have 4 computers. 2 of them work FINE, the other 2 have issues. I know the email accounts are working correctly because if I run them on the 2 *good* computers they work like they should. Configurations: (GOOD Notebooks) 1 - HP AMD-XP notebook with WinXP-Home SP1, Office 2000 2 - Sony P4 Notebook with WinXP-Home SP1, Office 2000 (Bad systems) 3 - Dell P3 notebook with WinXP-Pro SP1, Office 2002 4 - Compaq AMD-XP with WinXP-Home SP2, Office 2000 ALl ma...

making an equation in access
Hi, I would like to create a field that works out a formula based on other fields. i.e field z=field4, when field 1<field 2 - field 3 etc. Yes, it may be a silly question but I am only new to this....Thanks, Dani. Dani, recommend against creating a "field" in a table and storing this value. One of the generally accepted rules of relational database development is not to store a "computed" (any value that is based on the value of other fields in your database) value in the table. It is a waste of database space, and will eventually result in bad data (...

Sending from 2 different computers
I have Outlook 2003 on my desktop at home and 2002 on my laptop while traveling. My server is Comcast. I would strongly prefer to use Outlook (rather than Comcast's webmail) on both computers. I have configured Outlook on both computers to receive email. I can also leave a copy on the server so it can be downloaded again later on the other computer, assuring that I always have copies of all emails no matter which computer I'm using. Problem is I can't send from my laptop. I've tried Comcast's instructions for configuring Outlook 2002 for use while traveling, but it doesn&...