emaildatabaseojbect to [Email] to send multiple

wnicole

New member
Local time
Yesterday, 23:16
Joined
Sep 28, 2013
Messages
9
See pic below.
I haven't been able to find right vba and wondering if I can use this macro set the Email field to link to my query Q_InspectorDailyDispatch. I need the macro to send to each individual person its jobs. (I prefer not to use VBA just too hard for me and I'm only frustrating more intelligent programmers with my lack of skill.:)

Can you look at the pic and tell me is that an (=) code I can use to link the two.
 

Attachments

  • Capture.JPG
    Capture.JPG
    17.7 KB · Views: 142
im sorry to say it and i know that you wont like it.

you need to learn vba. i was on here virtually every day with problems that i had encountered. most of the replies came back as vba. unless it was a simple copy and pastei would ignore it and ask for macro's etc.

now i have no macros!! need i say anymore.

vba is easy. is daunting at first(dont get me wrong) but once you get our teeth into it you will be inspired at how many different ideas you will get and just how many of them you will be able to do.

so my advise for this is a record set.

the record set will loop through all of your individual people and send them a pdf or a different pdf for each one.

if you would like i am doing something similar to your emails. im trying to send images and build the email as if it was html. i too will need a record set as i will be sending to over 1700 clients.

let me know if you would like me to post once i have finished it.
 
In Create Macro have you tried the "Email Data base Object" you may not see it unless you have the "Show All Actions" button on. This maybe a start to solving your issue.
 

Users who are viewing this thread

Back
Top Bottom