D
DEBMICHELS
Is it possible to do this? I am totally new to Access but am very familiar
with Word.
with Word.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John Vinson
Word is an excellent word-processing program; Access is a relational
database. They are different programs for different purposes with different
techniques. Just what are you trying to accomplish?
Note that you can use Access (for example, a database of names and
addresses) as the datasource for a Mail Merge document in Word. It's not
clear if that's what you're trying to do though!
database. They are different programs for different purposes with different
techniques. Just what are you trying to accomplish?
Note that you can use Access (for example, a database of names and
addresses) as the datasource for a Mail Merge document in Word. It's not
clear if that's what you're trying to do though!
D
DanielWalters6
John Vinson.
I have seen your posting about Mail Merge, and you've got a little MVP logo,
so I hope I'm talking to the right person.
I have a query that I would like to use as the source for one of my mail
merges. (It basically finds people from my customerdata table who have
aggreed to let me send them promotional mail.)
Like an iddiot, at the start of building my database I chose to concatenate
all of my address fields into one. This means that If I wanted a simple
leaflet/poster designed in word I couldn't make an address appear like:
123 BlueBottle Road,
Warboys,
Huntingdon,
Cambs,
AB12 3CD
It would appear like
123 BlueBottle Road, Warboys, Huntingdon, Cambs, AB12 3CD
Anyway, seeking help, an associate and I produce a module that found the all
of the ","s in my address field and split them up. (The data in my database
is still stored in the one field)
In my query, I have the following fields
Name
Address (The original address, which it's set not to show)
Line1 : ExtractAddrLine1([CustomerData]![Address])
Line2 : ExtractAddrLine2([CustomerData]![Address])
Line3 : ExtractAddrLine3([CustomerData]![Address])
Line4 : ExtractAddrLine4([CustomerData]![Address])
Line5 : ExtractAddrLine5([CustomerData]![Address])
PromotionalMail {This criteria is set to yes, and is also not shown}
When I run this query I get exactly the results that I wish for.
The name of the person, The five lines of their address in seperate fields,
and only people that want the promotional mail in the first place.
When I use this query as the source for my mail merge, Word gives me only
three different fields that I can enter into my document.
NAME, ADDRESS (not the line1, line2, line3.. that I wanted), and
PROMOTIONALMAIL.
Why won't it show these "tempory fields"?
Do I have to make it put all of that data it returns into a NEW table, which
I will have to use as the source for my merge?
Hope you can help, I'm sorry my explanations arn't brilliant.
It's been nagging me for some time and appreciate any help you could
possibly give me.
Thankyou
Dan
I have seen your posting about Mail Merge, and you've got a little MVP logo,
so I hope I'm talking to the right person.
I have a query that I would like to use as the source for one of my mail
merges. (It basically finds people from my customerdata table who have
aggreed to let me send them promotional mail.)
Like an iddiot, at the start of building my database I chose to concatenate
all of my address fields into one. This means that If I wanted a simple
leaflet/poster designed in word I couldn't make an address appear like:
123 BlueBottle Road,
Warboys,
Huntingdon,
Cambs,
AB12 3CD
It would appear like
123 BlueBottle Road, Warboys, Huntingdon, Cambs, AB12 3CD
Anyway, seeking help, an associate and I produce a module that found the all
of the ","s in my address field and split them up. (The data in my database
is still stored in the one field)
In my query, I have the following fields
Name
Address (The original address, which it's set not to show)
Line1 : ExtractAddrLine1([CustomerData]![Address])
Line2 : ExtractAddrLine2([CustomerData]![Address])
Line3 : ExtractAddrLine3([CustomerData]![Address])
Line4 : ExtractAddrLine4([CustomerData]![Address])
Line5 : ExtractAddrLine5([CustomerData]![Address])
PromotionalMail {This criteria is set to yes, and is also not shown}
When I run this query I get exactly the results that I wish for.
The name of the person, The five lines of their address in seperate fields,
and only people that want the promotional mail in the first place.
When I use this query as the source for my mail merge, Word gives me only
three different fields that I can enter into my document.
NAME, ADDRESS (not the line1, line2, line3.. that I wanted), and
PROMOTIONALMAIL.
Why won't it show these "tempory fields"?
Do I have to make it put all of that data it returns into a NEW table, which
I will have to use as the source for my merge?
Hope you can help, I'm sorry my explanations arn't brilliant.
It's been nagging me for some time and appreciate any help you could
possibly give me.
Thankyou
Dan
J
John Vinson
When I use this query as the source for my mail merge, Word gives me only
three different fields that I can enter into my document.
NAME, ADDRESS (not the line1, line2, line3.. that I wanted), and
PROMOTIONALMAIL.
Doublecheck that you ARE using the Query rather than the Table.
I'm not really expert on mail merges pre se, but IME if you base a
mail merge on a query, you see the fields in that query.
That said... it might not be a bad idea to create a new Table with the
multiple address fields, and use your query as the basis of an Append
query to split up the non-atomic address field you now have. There
will be quite a few advantages to having the data in separate fields
(e.g. easily searching for all customers on one town, among others).
John W. Vinson[MVP]