Mailing list

[Guest]

Hi,

I used the Mailing wizard to create a mailing list. It looks great! However,
I am concerned about the comma that separate between people names and their
titles.

Ex: Fistname LastName, title.
Address
City, State, Zip

The problem is if the person doesn't have his/her title, the label will show
the name with a comma. That is not perfect.

Ex: John Tran,
2244 Roland
Champaign, IL 61821

I wish the comma will be on the label if the person has his title and it
won't be appeared if the person doesn't have a title.

Do I need to use “If Statement†to make it works? I don’t know anything
about coding. Please help.

Thanks
Chi

 

[John W. Vinson]

Hi,

I used the Mailing wizard to create a mailing list. It looks great! However,
I am concerned about the comma that separate between people names and their
titles.

Ex: Fistname LastName, title.
Address
City, State, Zip

The problem is if the person doesn't have his/her title, the label will show
the name with a comma. That is not perfect.

Please open the wizard generated report in design view; view its Properties
(use the View menu item or rightclick the little square at the upper left
intersection of the rulers); find the Recordsource property on the Data tab;
click the ... icon by it to open the query; select View... SQL; and post the
SQL text here.

This is easily fixable but it would help to know what you're working with!

John W. Vinson [MVP]

 

[Peter Gr]

If I could just make a comment about entering names in a mailing list.
I work with numerous clients in cleansing their address records.
Please do yourself a favor and create a seperate field for Prefix,
FirstName, MidName, LastName, and Suffix. The same goes for
Address_Line1, Address_Line2, City, State, Zip, Country.
It makes it much easier to manage and search your list.

Peter

 

[John W. Vinson]

If I could just make a comment about entering names in a mailing list.
I work with numerous clients in cleansing their address records.
Please do yourself a favor and create a seperate field for Prefix,
FirstName, MidName, LastName, and Suffix. The same goes for
Address_Line1, Address_Line2, City, State, Zip, Country.
It makes it much easier to manage and search your list.

HEAR, HEAR!! <g>

John W. Vinson [MVP]

 

[Len Robichaud]

Try FirstName & " " & LastName & (", " + Title)
Something + Null always = Null. By enclosing (", " + Title) if Title is
Null then Nothing will be concatenated by the last ampersand.

Len Robichaud

Hi,

I used the Mailing wizard to create a mailing list. It looks great! However,
I am concerned about the comma that separate between people names and their
titles.

Ex: Fistname LastName, title.
Address
City, State, Zip

The problem is if the person doesn't have his/her title, the label will show
the name with a comma. That is not perfect.

Ex: John Tran,
2244 Roland
Champaign, IL 61821

I wish the comma will be on the label if the person has his title and it
won't be appeared if the person doesn't have a title.

Do I need to use "If Statement" to make it works? I don't know anything
about coding. Please help.

Thanks
Chi

 

[Guest]

Thank you for the responses.

Good Morning Len!

I would like to write your code, but I don't know how to do it. Please give
me more detail, like where I can start to do it.

Thank you
Chi

 

[Guest]

Hi John,

Do you mean the report Properties, not a wizard properties ? Sorry, I could
not find the View SQL. What is the SQL text? Please give me more detail or
write me some code.

Thanks
Chi Huynh

 

[Guest]

Hi Len,

You did a excellent job!!!! I appreciated. It works perfectly!!!!

 

[John W. Vinson]

Hi John,

Do you mean the report Properties, not a wizard properties ? Sorry, I could
not find the View SQL. What is the SQL text? Please give me more detail or
write me some code.

I cannot write you some code, Chi, because I do not know the names of your
tables, the names of your fields, the name of your report, or much of anything
about the application.

Please open the Report that the wizard generated in design view.

On the menu select View... Properties.

Be sure you're looking at the Report properties (not the properties of the
Detail section or of some control on the report).

On the Data tab the first property is the Recordsource. Click the ... icon by
it and view the query in design view.

Select View... SQL from the menu.

Post the SQL text here.

Also, post the Control Source property of the textbox that has the unwanted
comma.

John W. Vinson [MVP]

 

[Guest]

Hi John,

Thank you for answering my questions. Even though I got it, I will try your
ideas. That is something new that I should learn.

Chi