design new mail by code in access (VBA)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hi,
i have code in access to open new mail, with body,
can i design the body in the code? now it align to left, i want it will
align to right etc'
i want to set the font and add picture.
how can i do it,
and something more, can i add signature to the body? how am i writing the
path of the signature?
thank,
 
hi,
i have code in access to open new mail, with body,
can i design the body in the code? now it align to left, i want it will
align to right etc'
i want to set the font and add picture.
how can i do it,
and something more, can i add signature to the body? how am i writing the
path of the signature?

How are you sending mail in Access? Are you using SendObject? If so, you're pretty well stuck with the default methods
and settings of your email client.

If you're using Outlook via automation, you can set many of these items (except the sig - I'm not sure you can do this).
Note that font manipulation means you'll need to be in HTML or Richtext format, which may not be the default option of
your email client.

RE: The signature, I don't believe you can manipulate this via code directly, expect to perhaps use SendKeys to "press"
the buttons in Outlook which would insert the sig. This is an option setting in Outlook, so when you build a new email
OUtlook will append a signature if you've set that option correctly. There are some instances where you can grab the sig
file from the default location (Docs and SEttings\USERNAME\Application\Data\Microsoft\Signatures in newer versions of
Outlook) but if the user has more than one, you still won't know which one to use. I could be wrong about this, of
course, but look here for a good collection of info about Outlook:

www.slipstick.com

Scott McDaniel
scott@takemeout_infotrakker.com
www.infotrakker.com
 
As Scott mentioned, if you are automating Outlook this can be done. Your
best bet is to ask this question in an Outlook forum as it is specific to
Outlook. once you have the basic code from there adapting it to be used
through access should be stright forward.
 
Back
Top