Sending multiple attachments in one email to multiple address

alpnz

Hi,
I have a need to send snap reports to various shipping agents.
E.g.

A PalletCard, A FreightNote, A Consignment Advice, and an Export declaration of Conformity.
It is easy enough to code a sendobject event for a button click, however this results in One email for each object, and it is named as per the report name. What I would like to achieve is One email with multiple attachments, which we send to a Contact Group in Outlook.

So I would like this to happen.

Name the attachment E.g. Pallet1234.snp, etc etc for each report I want to send. (The 1234 is a field in the Pallet Table.)
Group the attachments onto one email,

M$ is not entirely helpful on this subject, but surely the tools are there. Has anyone achieved this in the Past ... hint hint Mary

msquared

I doubt if sendobject can handle this as it's designed to send one object. I would guess we will need to use automation to outlook (in other words a lot of code). Post a reply to this thread on Wednesday or Thursday to remind me and I'll have a look.

Merry Christmas.

Mary

Quote:

Originally Posted by alpnz

Hi,
I have a need to send snap reports to various shipping agents.
E.g.

A PalletCard, A FreightNote, A Consignment Advice, and an Export declaration of Conformity.
It is easy enough to code a sendobject event for a button click, however this results in One email for each object, and it is named as per the report name. What I would like to achieve is One email with multiple attachments, which we send to a Contact Group in Outlook.

So I would like this to happen.

Name the attachment E.g. Pallet1234.snp, etc etc for each report I want to send. (The 1234 is a field in the Pallet Table.)
Group the attachments onto one email,

M$ is not entirely helpful on this subject, but surely the tools are there. Has anyone achieved this in the Past ... hint hint Mary

alpnz

Quote:

Originally Posted by mmccarthy

I doubt if sendobject can handle this as it's designed to send one object. I would guess we will need to use automation to outlook (in other words a lot of code). Post a reply to this thread on Wednesday or Thursday to remind me and I'll have a look.

Merry Christmas.

Mary

Did you have a good Xmas, Hope so, cause this problem is not an easy fix I think. My Partners brother, tells me it is better to use a pdf creation product like Adobe, and build them outside of Access, but surely we don't have to resort to this.

NeoPa

I have found Snapshots and the Snapshot viewer to be unreliable in various circumstances.
I don't use it any more :(.

alpnz

Quote:

Originally Posted by NeoPa

I have found Snapshots and the Snapshot viewer to be unreliable in various circumstances.
I don't use it any more :(.

OK,
One suggestion from an associate is that we use a PDF creator, to write the reports to. Have any of you implemented anything like this in the past?

NeoPa

I use that now.
I create the report normally and print to the Adobe printer which converts the print output to a PDF file.

msquared

Quote:

Originally Posted by alpnz

OK,
One suggestion from an associate is that we use a PDF creator, to write the reports to. Have any of you implemented anything like this in the past?

I have but it's been a while. If noone else answers this with code I'll try to find the procedure. May take a while.

Mary

alpnz

Quote:

Originally Posted by mmccarthy

I have but it's been a while. If noone else answers this with code I'll try to find the procedure. May take a while.

Mary

Yes the printing to an Adobe Printer is understood, but what is not clear to me is the consolidation of a number of reports into one report, or do I just use the PDF printers options??.

msquared

Quote:

Originally Posted by alpnz

Yes the printing to an Adobe Printer is understood, but what is not clear to me is the consolidation of a number of reports into one report, or do I just use the PDF printers options??.

Essentially you would add each report to the pdf as a new page or pages. This would require some kind of loop.

Mary

Sending multiple attachments in one email to multiple address

re: Sending multiple attachments in one email to multiple address

re: Sending multiple attachments in one email to multiple address

re: Sending multiple attachments in one email to multiple address

re: Sending multiple attachments in one email to multiple address

re: Sending multiple attachments in one email to multiple address

re: Sending multiple attachments in one email to multiple address

re: Sending multiple attachments in one email to multiple address

re: Sending multiple attachments in one email to multiple address

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about