[Susan May]

I have a list of email address in an 2007 Access query. I would like to
individually email merge articles I have written in MS Word and send them
thru MS Outlook individually so they are professional sent with their first
and last name on to To: field.

How can this be done successfully?

Many thanks for your help

[Doug Robbins - Word MVP on news.microsoft.com]

Do you mean rather than their email address?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"Susan May" wrote in message
...
I have a list of email address in an 2007 Access query. I would like to
individually email merge articles I have written in MS Word and send them
thru MS Outlook individually so they are professional sent with their
first
and last name on to To: field.

How can this be done successfully?

Many thanks for your help

[Susan May]

Doug, I want to take a list of emails I have in a query and individually send
them out so it looks like I'm sending them individually, but I'm actually
sending them using a Word email merge because what I'm sending them are
articles that we publish about the economy and these are potential recruits
that have contacted us for more information but have not joined our firm yet.
I don't want to copy and paste in bcc field in Outlook because that would
make me look like a blaster and I don't want our server to be black listed.
We have the rights to these emails so I was told by doing an email merge in
Word, I can set it up so it would go out to each one individually and not
alert the internet providers.

Also, when I set up my query, I selected the criteria for the email address
field "is not null", and there are still some blank records with no emails.
Why is that happening? There are not many, but is there a better syntax to
use to get rid of the records that do not have email addresses?

Many thanks.

PS Lately, when I've been notified of a response from my questions, the
link does not take me to the page where the question is. It is blank - do
you know why this is happening?

Susan

"Doug Robbins - Word MVP on news.microsof" wrote:

Do you mean rather than their email address?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"Susan May" wrote in message
...
I have a list of email address in an 2007 Access query. I would like to
individually email merge articles I have written in MS Word and send them
thru MS Outlook individually so they are professional sent with their
first
and last name on to To: field.

How can this be done successfully?

Many thanks for your help

[Peter Jamieson]

Also, when I set up my query, I selected the criteria for the email
address
field "is not null", and there are still some blank records with no
emails.

Different software packages can treat "null", "a string set to ''", and
"a string containing white space differently, and may also treat
variable-length and fixed-length data differently in this respect.

As far as Access is concerned, in some cases if you enter "white space",
Access leaves the field value as "null". However, if you set a text
value to '' in code, it isn't regarded as null but will otherwise look
no different to the user in many cases.

So generally speaking, you have to test a string for both null and
blank. to detect that in the SQL in Access you need something like

WHERE mystring is not null AND mystring ''

If the string could contain one or more spaces, you would probably need
to add another condition, e.g.

WHERE mystring is not null AND mystring '' AND trim(mystring) ''

but if mystring could contain other types of "whitespace" such as tabs,
non-breaking spaces, I think you would need to ask an Access person. You
might be able to use LIKE with a pattern to do it.


Peter Jamieson

http://tips.pjmsn.me.uk

Susan May wrote:
Doug, I want to take a list of emails I have in a query and individually send
them out so it looks like I'm sending them individually, but I'm actually
sending them using a Word email merge because what I'm sending them are
articles that we publish about the economy and these are potential recruits
that have contacted us for more information but have not joined our firm yet.
I don't want to copy and paste in bcc field in Outlook because that would
make me look like a blaster and I don't want our server to be black listed.
We have the rights to these emails so I was told by doing an email merge in
Word, I can set it up so it would go out to each one individually and not
alert the internet providers.

Also, when I set up my query, I selected the criteria for the email address
field "is not null", and there are still some blank records with no emails.
Why is that happening? There are not many, but is there a better syntax to
use to get rid of the records that do not have email addresses?

Many thanks.

PS Lately, when I've been notified of a response from my questions, the
link does not take me to the page where the question is. It is blank - do
you know why this is happening?

Susan

"Doug Robbins - Word MVP on news.microsof" wrote:

Do you mean rather than their email address?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"Susan May" wrote in message
...
I have a list of email address in an 2007 Access query. I would like to
individually email merge articles I have written in MS Word and send them
thru MS Outlook individually so they are professional sent with their
first
and last name on to To: field.

How can this be done successfully?

Many thanks for your help

[Susan May]

Peter: I tried this WHERE mystring is not null AND mystring '' AND
trim(mystring) '' with mystring name as Email1Address, and it created 3
different columns with the criteria "is not null"; "; and
Trim(Emai1lAddress) with criteria ", and I'm still getting blank emails.
What did I do wrong?


"Peter Jamieson" wrote:

Also, when I set up my query, I selected the criteria for the email
address
field "is not null", and there are still some blank records with no
emails.

Different software packages can treat "null", "a string set to ''", and
"a string containing white space differently, and may also treat
variable-length and fixed-length data differently in this respect.

As far as Access is concerned, in some cases if you enter "white space",
Access leaves the field value as "null". However, if you set a text
value to '' in code, it isn't regarded as null but will otherwise look
no different to the user in many cases.

So generally speaking, you have to test a string for both null and
blank. to detect that in the SQL in Access you need something like

WHERE mystring is not null AND mystring ''

If the string could contain one or more spaces, you would probably need
to add another condition, e.g.

WHERE mystring is not null AND mystring '' AND trim(mystring) ''

but if mystring could contain other types of "whitespace" such as tabs,
non-breaking spaces, I think you would need to ask an Access person. You
might be able to use LIKE with a pattern to do it.


Peter Jamieson

http://tips.pjmsn.me.uk

Susan May wrote:
Doug, I want to take a list of emails I have in a query and individually send
them out so it looks like I'm sending them individually, but I'm actually
sending them using a Word email merge because what I'm sending them are
articles that we publish about the economy and these are potential recruits
that have contacted us for more information but have not joined our firm yet.
I don't want to copy and paste in bcc field in Outlook because that would
make me look like a blaster and I don't want our server to be black listed.
We have the rights to these emails so I was told by doing an email merge in
Word, I can set it up so it would go out to each one individually and not
alert the internet providers.

Also, when I set up my query, I selected the criteria for the email address
field "is not null", and there are still some blank records with no emails.
Why is that happening? There are not many, but is there a better syntax to
use to get rid of the records that do not have email addresses?

Many thanks.

PS Lately, when I've been notified of a response from my questions, the
link does not take me to the page where the question is. It is blank - do
you know why this is happening?

Susan

"Doug Robbins - Word MVP on news.microsof" wrote:

Do you mean rather than their email address?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"Susan May" wrote in message
...
I have a list of email address in an 2007 Access query. I would like to
individually email merge articles I have written in MS Word and send them
thru MS Outlook individually so they are professional sent with their
first
and last name on to To: field.

How can this be done successfully?

Many thanks for your help

[Doug Robbins - Word MVP on news.microsoft.com]

In the Query output field use Trim(EmailAddress) and set the Criteria to Is
Not Null

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"Susan May" wrote in message
news

Peter: I tried this WHERE mystring is not null AND mystring '' AND
trim(mystring) '' with mystring name as Email1Address, and it created 3
different columns with the criteria "is not null"; "; and
Trim(Emai1lAddress) with criteria ", and I'm still getting blank
emails.
What did I do wrong?


"Peter Jamieson" wrote:

Also, when I set up my query, I selected the criteria for the email
address
field "is not null", and there are still some blank records with no
emails.

Different software packages can treat "null", "a string set to ''", and
"a string containing white space differently, and may also treat
variable-length and fixed-length data differently in this respect.

As far as Access is concerned, in some cases if you enter "white space",
Access leaves the field value as "null". However, if you set a text
value to '' in code, it isn't regarded as null but will otherwise look
no different to the user in many cases.

So generally speaking, you have to test a string for both null and
blank. to detect that in the SQL in Access you need something like

WHERE mystring is not null AND mystring ''

If the string could contain one or more spaces, you would probably need
to add another condition, e.g.

WHERE mystring is not null AND mystring '' AND trim(mystring) ''

but if mystring could contain other types of "whitespace" such as tabs,
non-breaking spaces, I think you would need to ask an Access person. You
might be able to use LIKE with a pattern to do it.


Peter Jamieson

http://tips.pjmsn.me.uk

Susan May wrote:
Doug, I want to take a list of emails I have in a query and
individually send
them out so it looks like I'm sending them individually, but I'm
actually
sending them using a Word email merge because what I'm sending them are
articles that we publish about the economy and these are potential
recruits
that have contacted us for more information but have not joined our
firm yet.
I don't want to copy and paste in bcc field in Outlook because that
would
make me look like a blaster and I don't want our server to be black
listed.
We have the rights to these emails so I was told by doing an email
merge in
Word, I can set it up so it would go out to each one individually and
not
alert the internet providers.

Also, when I set up my query, I selected the criteria for the email
address
field "is not null", and there are still some blank records with no
emails.
Why is that happening? There are not many, but is there a better
syntax to
use to get rid of the records that do not have email addresses?

Many thanks.

PS Lately, when I've been notified of a response from my questions,
the
link does not take me to the page where the question is. It is blank -
do
you know why this is happening?

Susan

"Doug Robbins - Word MVP on news.microsof" wrote:

Do you mean rather than their email address?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"Susan May" wrote in message
...
I have a list of email address in an 2007 Access query. I would like
to
individually email merge articles I have written in MS Word and send
them
thru MS Outlook individually so they are professional sent with their
first
and last name on to To: field.

How can this be done successfully?

Many thanks for your help

[Peter Jamieson]

1. FWIW you can probably reduce the criteria I suggested to

WHERE mystring is not null AND trim(mystring) ''

since the other condition should be taken care of by the trim() condition.

2. I think the next thing to do is check what's actually in that field
in some of the records that should be eliminated. (I tend to work
directly on the SQL, but if you are more familiar with the graphical
designer I'd try to stick with that).

3. e.g. add a few columns to your query such as
len(trim(Email1Address))
asc(mid(trim(Email1Address),1,1))

If the address looks blank but len(trim(Email1Address)) is 0 then the
field probably contains invisible non-space characters. The asc()
function should tell us what the first character is. You can use
asc(mid(trim(Email1Address),2,1))
etc. to look at the other characters.

Peter Jamieson

http://tips.pjmsn.me.uk

Susan May wrote:
Peter: I tried this WHERE mystring is not null AND mystring '' AND
trim(mystring) '' with mystring name as Email1Address, and it created 3
different columns with the criteria "is not null"; "; and
Trim(Emai1lAddress) with criteria ", and I'm still getting blank emails.
What did I do wrong?


"Peter Jamieson" wrote:

Also, when I set up my query, I selected the criteria for the email
address
field "is not null", and there are still some blank records with no
emails.

Different software packages can treat "null", "a string set to ''", and
"a string containing white space differently, and may also treat
variable-length and fixed-length data differently in this respect.

As far as Access is concerned, in some cases if you enter "white space",
Access leaves the field value as "null". However, if you set a text
value to '' in code, it isn't regarded as null but will otherwise look
no different to the user in many cases.

So generally speaking, you have to test a string for both null and
blank. to detect that in the SQL in Access you need something like

WHERE mystring is not null AND mystring ''

If the string could contain one or more spaces, you would probably need
to add another condition, e.g.

WHERE mystring is not null AND mystring '' AND trim(mystring) ''

but if mystring could contain other types of "whitespace" such as tabs,
non-breaking spaces, I think you would need to ask an Access person. You
might be able to use LIKE with a pattern to do it.


Peter Jamieson

http://tips.pjmsn.me.uk

Susan May wrote:
Doug, I want to take a list of emails I have in a query and individually send
them out so it looks like I'm sending them individually, but I'm actually
sending them using a Word email merge because what I'm sending them are
articles that we publish about the economy and these are potential recruits
that have contacted us for more information but have not joined our firm yet.
I don't want to copy and paste in bcc field in Outlook because that would
make me look like a blaster and I don't want our server to be black listed.
We have the rights to these emails so I was told by doing an email merge in
Word, I can set it up so it would go out to each one individually and not
alert the internet providers.

Also, when I set up my query, I selected the criteria for the email address
field "is not null", and there are still some blank records with no emails.
Why is that happening? There are not many, but is there a better syntax to
use to get rid of the records that do not have email addresses?

Many thanks.

PS Lately, when I've been notified of a response from my questions, the
link does not take me to the page where the question is. It is blank - do
you know why this is happening?

Susan

"Doug Robbins - Word MVP on news.microsof" wrote:

Do you mean rather than their email address?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"Susan May" wrote in message
...
I have a list of email address in an 2007 Access query. I would like to
individually email merge articles I have written in MS Word and send them
thru MS Outlook individually so they are professional sent with their
first
and last name on to To: field.

How can this be done successfully?

Many thanks for your help

[Susan May]

Doug - no records appear when I enter in your string. What am I doing wrong?

Susan

"Doug Robbins - Word MVP on news.microsof" wrote:

Do you mean rather than their email address?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"Susan May" wrote in message
...
I have a list of email address in an 2007 Access query. I would like to
individually email merge articles I have written in MS Word and send them
thru MS Outlook individually so they are professional sent with their
first
and last name on to To: field.

How can this be done successfully?

Many thanks for your help

[Doug Robbins - Word MVP on news.microsoft.com]

What did you have for the criteria? It should be Is Not Null. The use of
the Trim() function would remove any spaces that might be in an otherwise
empty record and the Is Not Null would prevent such a record from being
displayed so that only records that contained characters other than spaces
would be displayed.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"Susan May" wrote in message
...
Doug - no records appear when I enter in your string. What am I doing
wrong?

Susan

"Doug Robbins - Word MVP on news.microsof" wrote:

Do you mean rather than their email address?

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP, originally posted via msnews.microsoft.com

"Susan May" wrote in message
...
I have a list of email address in an 2007 Access query. I would like to
individually email merge articles I have written in MS Word and send
them
thru MS Outlook individually so they are professional sent with their
first
and last name on to To: field.

How can this be done successfully?

Many thanks for your help