Re: Email Merge in Word

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

> 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" <SusanMay@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:31C79BEF-0609-4FCD-81D6-A3044E38B86C@xxxxxxxxxxxxxxxx
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


.

Relevant Pages

  • Programatically Changing Query Criteria
    ... Save your query in SQL. ... the following to determine your criteria. ... Dim strSQL As String ... MsgBox "There was a problem building the SQL String" ...
    (microsoft.public.access.macros)
  • Re: Complex query criteria - desperate appeal
    ... I made an ASP website using an Access DB ... criteria listboxes have the ALL choice, and the value passed to the query is ... I then build a string of the selected ID's and use ...
    (microsoft.public.access.queries)
  • Re: Passing multiple strings from a text box to a select query
    ... Search Criteria database page on your website have given me lots of new ... Will a filtered form allow a subform that displays records from a query ... The article explains how to create the string to use as the WhereCondition ... This allows me to enter "seat" in the text box and return ...
    (microsoft.public.access.forms)
  • RE: List Box and Query
    ... I would not put any criteria in qry_Suppliers. ... build up a Where string and then apply that "WHERE" criteria to a Select ... Query (qrySupplierTEST) to get my desired records. ...
    (microsoft.public.access.formscoding)
  • Re: Email Merge in Word
    ... WHERE mystring is not null AND trim'' ... Trimwith criteria ", and I'm still getting blank 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. ...
    (microsoft.public.word.mailmerge.fields)