The error has gone away.
And loop works both way (i changed it to yours since it made more sence.)
I sent out 40+ emails( some with 1 and others with 2-3 attachements), to over 250 people in about 5mins. YaY for automation..
Thank you.
djsaix
Last Activity: Jan 16 '13, 04:59 PM
Joined: Nov 6 '12
Location:
-
Last edited by NeoPa; Dec 21 '12, 07:23 PM. Reason: Added more info. {NeoPa} Removed new question. Please remember to post new questions in their own threads. -
i think i love you..
Thank you..Leave a comment:
-
My appologies, thought I provided everything needed. The code has few minor changes, as I been playing around to get it to work..
Here is my current code:
...Code:Option Compare Database Option Explicit Private Sub Command65_Click() 'testing button on going through all records...but no success on setting up emailing for each record.. 'some variables are just for testing... 'tried
Leave a comment:
-
still having issues..any advice?Leave a comment:
-
Hey zmbd,
This computer that i am using doesnt seem to have zip (darn gov pc's).
I have tried doing doCmdsendobject (), but i am getting lost at how to properly loop it through that it sends out all my queries. I'll add in what i can, and once im hope ill zip it and add on what i have..(which isnt much sadly).
EmailReportTabl e (table)
Unit Unit Codes POC Emails QueryName Notes
xx1 ak...Leave a comment:
-
attachement
attached docs..trying to be sneaky..cant seem to add the database.....Leave a comment:
-
multiple queries to multiple contacts email - vba
Hello everyone, need some help on figuring out.
I have a table called EmailReports table, it has:
Unit, Unitcode, POC, Emails, QueryName, and Notes
so far, i have been exporting each query and sending it out manually, i would like to automate it.
So, when a member clicks email button, i would like:
for each unit, create an email, attach the query (that is in that record) set email,...
No activity results to display
Leave a comment: