Auto create letters for mailing lists

[Guest]

Hello,

I'm fairly new to access, so I apologise if there is a simple solution for
this, but I have looked everywhere that I can think off to see if this is
possible and how to do it.

I have been tasked with creating a database of customers previous purchases
and then sending out letters to them, these letters would need to be
personalised so that for example: if Mr X brought good Y then the letter
would automatically be changed so that it would account for this and insert a
passage into the body of the letter saying something like;
"I hope that your are happy with your purchase of good Y"

Firstly is this possible in Access? And if so how?

Thanks in advance,

Yours,

Alex

 

[fredg]

Hello,

I'm fairly new to access, so I apologise if there is a simple solution for
this, but I have looked everywhere that I can think off to see if this is
possible and how to do it.

I have been tasked with creating a database of customers previous purchases
and then sending out letters to them, these letters would need to be
personalised so that for example: if Mr X brought good Y then the letter
would automatically be changed so that it would account for this and insert a
passage into the body of the letter saying something like;
"I hope that your are happy with your purchase of good Y"

Firstly is this possible in Access? And if so how?

Thanks in advance,

Yours,

Alex

Sure it's possible.

You would store the relevant items sold, the date of sale, customer
name, address, length of warranty, etc., in your table.

Then create your report using text controls something similar to this:

="Dear " & [CustomerFirstName] & " " & [CustomerLastName]

= "I hope that your are happy with your purchase of " & [Y] & chr(13)
& chr(10) & "on " & Format([DateSold],"mmmm d, yyyy") & "." & chr(13)
& chr(10) & "We hope that it fully meets your needs and we wish to
assure you that your warranty will cover any defect until " &
Format(DateAdd("m",[LengthOfWarranty],[DateSold]),"mmmm d, yyyy") &
"."

= "Sincerely Yours,"
etc.

 

[Guest]

Thanks for that, I'll give it ago!

Yours,

Alex

Hello,

I'm fairly new to access, so I apologise if there is a simple solution for
this, but I have looked everywhere that I can think off to see if this is
possible and how to do it.

I have been tasked with creating a database of customers previous purchases
and then sending out letters to them, these letters would need to be
personalised so that for example: if Mr X brought good Y then the letter
would automatically be changed so that it would account for this and insert a
passage into the body of the letter saying something like;
"I hope that your are happy with your purchase of good Y"

Firstly is this possible in Access? And if so how?

Thanks in advance,

Yours,

Alex

Sure it's possible.

You would store the relevant items sold, the date of sale, customer
name, address, length of warranty, etc., in your table.

Then create your report using text controls something similar to this:

="Dear " & [CustomerFirstName] & " " & [CustomerLastName]

= "I hope that your are happy with your purchase of " & [Y] & chr(13)
& chr(10) & "on " & Format([DateSold],"mmmm d, yyyy") & "." & chr(13)
& chr(10) & "We hope that it fully meets your needs and we wish to
assure you that your warranty will cover any defect until " &
Format(DateAdd("m",[LengthOfWarranty],[DateSold]),"mmmm d, yyyy") &
"."

= "Sincerely Yours,"
etc.

 

[Guest]

Sorry I've realised that it would also be useful if I could get Access to
compose the letters by for example if they brought product Y then it would
insert Paragraph A in to the body of the letter and if the customer brought
product Z then it inserted paragraph B.

So simply is it possible to get it Access to compose letters such as these?

Sorry I was not clearer,

Thanks

Alex

Hello,

I'm fairly new to access, so I apologise if there is a simple solution for
this, but I have looked everywhere that I can think off to see if this is
possible and how to do it.

I have been tasked with creating a database of customers previous purchases
and then sending out letters to them, these letters would need to be
personalised so that for example: if Mr X brought good Y then the letter
would automatically be changed so that it would account for this and insert a
passage into the body of the letter saying something like;
"I hope that your are happy with your purchase of good Y"

Firstly is this possible in Access? And if so how?

Thanks in advance,

Yours,

Alex

Sure it's possible.

You would store the relevant items sold, the date of sale, customer
name, address, length of warranty, etc., in your table.

Then create your report using text controls something similar to this:

="Dear " & [CustomerFirstName] & " " & [CustomerLastName]

= "I hope that your are happy with your purchase of " & [Y] & chr(13)
& chr(10) & "on " & Format([DateSold],"mmmm d, yyyy") & "." & chr(13)
& chr(10) & "We hope that it fully meets your needs and we wish to
assure you that your warranty will cover any defect until " &
Format(DateAdd("m",[LengthOfWarranty],[DateSold]),"mmmm d, yyyy") &
"."

= "Sincerely Yours,"
etc.